Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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