MySQL Bothway Replication - Fail Back - Hold Master while Slave is Synchronizing.
I have the following question: Is it possible to have a slave on machine M1 synchronizing with a master on another machine M2 while the master on the first machine M1 does not accept requests yet (i.e. it is not available to a client yet)? Background info: Why do I want this? Well, I have a configuration where two machines run MySQL. They are configured to replicate each others updates. Although two masters are effectively running, only one is used at a time. This is taken care of by the client. When the first machine fails, the client detects this and goes to the other machine. So for so good. When machine M1 comes on-line again then our client immediately starts to use it (fail-back) (it has - let's say - a preferred machine and I can't disable this). The database, however, is not correct yet. The slave needs to synchronize with M2 still. So we read old data. This situation could be avoided if we can let the master on M1 wait until the salve on M1 has completed its synchronization, and the databases are in sync again. Thanks, Johan. --------------------------------------------------------------------- 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