Please help, I've read through the manual and this case is suggested but not really laid out. I'm using mysql 3.23.37 and can't upgrade to 4.0 yet.
Okay, I've got replication on 2 machines with a one-way failover setup: Master fails, slave takes over. Now the slave has been recording updates for a day, and I want the master to start again. But I don't want to lose the last day's updates. Since replication is only one-way, there really shouldn't be any updates happening on the slave, but in the failover case, I've got no choice. So how do I isolate those updates and reapply them to the master, and switch back? My best guess so far is really clumsy and I'm not sure it will work: with master still shut down and client running on the slave: run FLUSH TABLES WITH READ LOCK on the slave copy all the .myi and .myd files with recent changes to a tgz file and over to the master start the master UNLOCK TABLES on the slave switch my client over to use the master. I'm not certain this will preserve the replication and bin files. Can anyone offer help, this seems to be a pretty common case. -steve -- Steve Rapaport World Citizen --------------------------------------------------------------------- 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
