Skip to main content
edited tags
Link
RolandoMySQLDBA
  • 184.3k
  • 33
  • 323
  • 531
edited tags
Link
Hannah Vernon
  • 70.5k
  • 22
  • 177
  • 321
Tweeted twitter.com/#!/StackDBAs/status/209151276271931392
Source Link
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.