MySQL Forums
Forum List  »  Database Administration & Monitoring

Advanced Search
New Topic

mysql master/slave synchronisation failed and restored, now ?
Posted by: Didier Wiroth
Date: September 18, 2013 03:24AM

Hi,
I have 2 windows servers (one master, one slave) running MySQL 5.6.13 with MySQL replication.

At some point a few days ago the replication failed due to the following bug:
http://bugs.mysql.com/bug.php?id=68892
(Invalid use of GRANT command breaks replication)

It was indeed an invalid grant command I issued at some point.

I issued the following command on the slave to restore synchronization between both servers:
set global sql_slave_skip_counter=1
start slave

The slave is now running again and show master/slave status look both ok.

How can I be sure that both servers are 100% in sync?
Are there any free windows tools that makes it possible to compare both databases to be sure they are correctly in sync?
(I want to be sure I didn't skip or miss something ....)

Thank you very much!!!!
Didier

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
mysql master/slave synchronisation failed and restored, now ?
Didier Wiroth
September 18, 2013 03:24AM


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.