MySQL Forums
Forum List  »  Replication

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
3126
March 30, 2009 06:10PM
1821
March 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.