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 <[EMAIL PROTECTED]> 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]