On Tue, 23 May 2006 15:32:31 -0700 Mace Eliason meliason@shaw.ca wrote:
My only question is I have found in the system that I setup with mysql replication it worked great but if you remove one of the servers and put it back in you have to stop mysql and copy over the newer database and then restart both to get it to replicate correctly.
Is there a way to get replication to work so it will automatically sync the master and slave without having to stop and copy and restart?
This is only neccessary if somethign ugly happens to your binary logs so the syncing thread of mysql has nowhere to get the good data from. Usually this should not happen. I only had it hapen when I run out of disk space. I suggest you check your setup and mysql replication docs again.