MySQL Forums :: Replication :: How to resync a master-slave server

Advanced Search

How to resync a master-slave server
Posted by: Flavio Tobias ()
Date: January 22, 2012 10:03PM

Hi I have two servers one master and another slave. The slave had a crash and because of that the databases has become unsynchronized.
When I try to start the slave with "START SLAVE" I got a lot of problems, I tried to solve them one by one manualy but every time I fix one another pops up.

My last alternative is to make a hard copy of data folder of master on slave, but in order to do that I need to stop the mysql for about 3 hours, and I cannot do that.

Is there any way to resync these databases without shuting down the master database?


Options: ReplyQuote

Subject Views Written By Posted
How to resync a master-slave server 2170 Flavio Tobias 01/22/2012 10:03PM
Re: How to resync a master-slave server 720 Scott Nemes 01/23/2012 05:55PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.