Mysql – How to rebuilt MySQL replication without dumping the master

MySQLreplication

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 use pt-table-sync afterward.