Skip to main content
1 of 3
KM.
  • 1.4k
  • 4
  • 14
  • 20

Replication Broken, List Out of Sync Tables

In a master-slave setup on MySQL 5.5 on RHEL 6.1, when db replication breaks (for whatever reason), what is a good way to:

  • check (and alert) replication is broken?
  • get a list of tables that are out of synch across various databases?

I don't have access to server logs, but can query the tables under "mysql" db and "information_schema", in addition to the dbs used by the applications.

KM.
  • 1.4k
  • 4
  • 14
  • 20