* Bhavin Vyas > Is there a way to have DB-A and DB-B such that DB-A is the master and DB-B > is the slave. However, I also want to make DB-B the master and DB-A it's > slave so that if I have to fail over to DB-B then DB-A is automatically > following the changes. It doesn't seem probable that this is > possible, but I wanted to know if there was a way to do this, that I > don't know of.
Yes, this is possible, but it may be difficult, depending on your application. <URL: http://www.mysql.com/doc/R/e/Replication_Features.html > "Starting in Version 3.23.26, it is safe to connect servers in a circular master-slave relationship with log-slave-updates enabled. Note, however, that many queries will not work right in this kind of setup unless your client code is written to take care of the potential problems that can happen from updates that occur in different sequence on different servers." See also the replication FAQ: <URL: http://www.mysql.com/doc/R/e/Replication_FAQ.html > -- Roger --------------------------------------------------------------------- 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
