Steve, Are the two servers roughly equal in terms of hardware?
Scott Helms > > 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 --------------------------------------------------------------------- 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