MySQL Forums :: Replication :: re syncing a broken replicatoin


Advanced Search

re syncing a broken replicatoin
Posted by: Cat Millenium ()
Date: March 30, 2009 06:10PM

I am looking for the fastest (with minimum downtime for the master) way to resync a broken replication whith a high turnover master?
Here my proposal:

On master:
flush tables with read lock;; show master status;
tar up master database
stop slave;
shutdown slave
unlock tables;
edit /var/lib/mysql/relay-log.info in line 4 with master position
copy over and untar master database into slave directory
start slave database
check replication

Does anybody has recomondations or additions to this procedure?

Options: ReplyQuote


Subject Views Written By Posted
re syncing a broken replicatoin 3013 Cat Millenium 03/30/2009 06:10PM
Re: re syncing a broken replicatoin 1806 Rick James 03/31/2009 08:26PM


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.