Amiph wrote:
>
> Hi !
>
> Ok. I've made correctly replication with two servers in a two-way replication. Both
>servers are master/slave. But I would like to know if is it possible to make three
>servers to replicate and receive the updates from each others like this:
>
> a sends updates to b and c
> a receives updates from b and c
>
> b sends updates to a and c
> b receives updates from a and c
>
> c sends updates to a and b
> c receives updates from a and b
>
> Anyone have got an idea ?
> I've got another question. How to use the log made with --log-slave-updates to
>transmit updates in another database ?
>
> Thanks
> Jimmy
Aside from the fact that the replication is not really supposed to be
two-way,
doing it the way you suggest would set up two counter-rotating
replication
whirlwinds.
Set up a bidirectional from a to b, and another from a to c.
Updates to c will go to a, and out to b.
Updates on b will go to a, and out to c.
Updates on a will go to both b and c.
It is not ballanced. so recovery after a hardware failure will be more
difficult.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
