Our MySQL database has grown fairly large, and I am running with master replication. Replication is broken. I am trying to rebuild the second master without freezing up the first master in doing a mysqldump. The database is big enough that the dump is taking a few hours, and I cannot have the database offline that long.
How can I rebuilt MySQL replication without dumping the master?
Best Answer
Take a look at the Percona Toolkit.
pt-table-checksum
can help you find out the tables out of sync and you can usept-table-sync
afterward.