MySQL Database Comparison
Hello,
We have Master/Slave setup with 1 Master and 2 Slaves using mixed MyISAM and InnoDB databases. We recently had some issues with our environment now everything is back to normal but I would like to compare the tables between Master and Slave. I can use CHECKSUM but I won't be able to use LOCK TABLES on Master as it's a live server. Are there any tools that can compare and maybe sync the missing records either on Master or Slave without locking the tables? We cannot afford to have any downtime. I would really appreciate any help.
Subject
Written By
Posted
MySQL Database Comparison
December 28, 2011 02:37PM
December 29, 2011 11:15AM
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.