When the databases get out of sync during replication, what is the best way
to re-sync them on a Windows system? The only way I know of right now is to
do it late at night, and pray that no one gets in while you're doing it.
Stop the slave, do a backup (using MySQL Administrator, or mysqldump), note
the log position on the master, restore the data on the slave, change the
log position on the slave, then re-start the slave. Is this the best way to
do it?
My issue has always been that I need the master MySQL running all the time.
I might be able to stop it for a minute or two, and I'm sure that'll
generate errors, but what can I do. But, in order to run a backup, it needs
to be running. I've tried the "copy the physical files" thing, and that has
never worked for me. Don't know why, but it doesn't.
Any ideas?
Thanks,
Jesse
--
MySQL Replication Mailing List
For list archives:
http://lists.mysql.com/replication
To unsubscribe:
http://lists.mysql.com/replication?unsub=lists@pantek.com
Received on Sat Sep 29 07:55:51 2007
This archive was generated by hypermail 2.1.8
: Sun Oct 07 2007 - 10:14:24 EDT
|