Home / server / Questions / 341268
Accepted
Cédric Girard
Asked: 2011-12-16 08:19:24 +0800 CST

How to check if data are the same between to Mysql servers setup as master-master replication

  • 772

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?

mysql mysql-replication

1 Answers

  1. Best Answer

    you may use Percona tools for such check Percona toolkit

    I think that this 2 tools should help

    pt-table-cheksum
    pt-heartbeat

    • 2