tags:

views:

38

answers:

1
+4  Q: 

How to Master/Slave switch, load balancing in CakePHP

I need to implement master/slave/load balancing into an existing site.

Does anyone use these (or other) implementations for master/slave switching?

The resources I found on how to implement master/slave into Cake:.

  • (preferable) gamephase.net/posts/view/master-slave-datasource-behavior-cakephp
  • bakery.cakephp.org/articles/view/master-slave-support-also-with-multiple-slave-support
  • bakery.cakephp.org/articles/view/load-balancing-and-mysql-master-and-slaves-2

I'm getting number 1) to work most of the times but it has trouble with some of the joins.

I welcome new sources, hacks or mods for master/slave implementation as for now I can't get my head around it.

*(Cake version I am using atm is 1.2) (I'm cross posting this on CakePHP's google groups http://groups.google.co.uk/group/cake-php/browse_thread/thread/4b77af429759e08f)*

A: 

Take a look at this tutorial in regards to Master/Slave over several nodes.

http://www.howtoforge.com/setting-up-master-master-replication-on-four-nodes-with-mysql-5-on-debian-etch

This may help you understand better.

RobertPitt  2010-08-26 12:45:37
Hi Robert, thank you for the link.What I am looking for is specifically how to either implement the master/slave based on the 3 sources I gave or a total new implementation into CakePHP. As it seems to have some difficulty deeper within Cake.
Kana  2010-08-26 13:10:57

related questions

Have you ever implemented a programming language?
How does "Find Nearest Locations" work?
How are Python's Built In Dictionaries Implemented
Interfaces with static fields in java for sharing 'constants'
Problem Implementing XmlTextWriter in new XmlRecordsetWriter for Streams
How is the NodeList implemented?
NHibernate IInterceptor implementation(add properties to DB table that original domain class doesn't have)
Why to Use Explicit Interface Implementation To Invoke a Protected Method?
C#: How can Dictionary<K,V> implement ICollection<KeyValuePair<K,V>> without having Add(KeyValuePair<K,V>)?
uses for state machines
How does Base 64 handle binary data with zeroes at the end
Is there any good JavaScript hash(code/table) implementation out there?
implementing a compiler in "itself"
How would I implement a Python bit map?
Can Dns.GetHostEntry ever return an IPHostEntry with an empty AddressList?
Recursive overloading semantics in the Scala REPL - JVM languages
What's a good Common Lisp implementation for Windows?
How would one code test and set behavior without a special hardware instruction?
Singleton: How should it be used
Implements several interfaces with conflict in signatures
Which should I implement first, PayPal or Google Checkout, on my eCommerce website?
How to solve call ambiguity between Generic.IList<T>.this[] and IList.this[]?
How would you implement the IEnumerator interface?
How would you implement a hashtable in language x?
When should I use type abstraction in embedded systems