[ic] Clustering

[interchange-users@icdevgroup.org (Dan Browning)]

At 07:43 PM 8/1/2002 +0200, you wrote:
>Dan Browning wrote:
>...
>>>They also wish to cluster the Mysql databases.
>>
>>I haven't done this yet, but if I were going to, I would use DBI::Multiplex.
>...
>
>How about
>
>http://www.phpbuilder.com/columns/tanoviceanu20000912.php3
>
>a quick test in our company, it works well with two MySQL-servers as a 
>master slave pair in both way.
>
>Joachim

It sounds like you have two-way replication going (if I understood you 
correctly).  But I didn't think the was possible, because according to 
http://www.mysql.com/doc/R/e/Replication_Features.html two-way replication 
isn't supported:

MySQL only supports one master and many slaves. In 4.x, we will add a 
voting algorithm to automatically change master if something goes wrong 
with the current master. We will also introduce 'agent' processes to help 
do load balancing by sending select queries to different slaves.

+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Dan Browning, Kavod Technologies <db@kavod.com>
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
7:30, Channel 5: The Bionic Dog (Action/Adventure)
         The Bionic Dog drinks too much and kicks over the National
         Redwood Forest.