Hello.
Similar questions are often asked in the list. Search in
archives about various solutions at http://lists.mysql.com/mysql.
See:
http://dev.mysql.com/doc/mysql/en/replication-faq.html
Luis Calero <lcalero@stripped> wrote:
> Hello, I've been discussing with a coworker if it's possible to
> setup the following replication scenario: We've got two boxes, machine
> A that has machine B as his master, and machine B that has machine A
> as his master (A->B B->A), both boxes are masters and slaves. Over
> this two boxes there's an Alteon sending all the traffic to machine A
> and it gets replicated in B. If A dies, then the alteon starts sending
> the traffic to B, and when A comes up again, because B is replicated
> in A, A starts to catch up with the updates needed.
>
> Can this be done this way or it is necessary that only one of them
> is the master and the other one the slave and change from master to
> slave manually?
>
> Thanks!
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
