[ic] Clustering

Richard Houston interchange-users@icdevgroup.org
Thu Aug 1 15:57:01 2002


Thanks for everyone's comment on the clustering question.
I do appreciate it.

Thanks

Rich

Dan Browning wrote:

> 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.
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>