I have two servers using Mysql Master-Master replication. Actually, only one server receives write orders. One of the databases is out of sync. Several tables don't have the same numbers of records, or the same value for autoinc (which is configured with a step of two to work on master-master).

How to check the others databases? Is there a tool to do it? A tips?

link|improve this question

feedback

1 Answer

up vote 2 down vote accepted

you may use Percona tools for such check Percona toolkit

I think that this 2 tools should help

pt-table-cheksum
pt-heartbeat

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.