I recently encountered a situation in which after running Percona Toolkits pt-table-checksum on a customer system, 95% of the table on the MySQL master was different on the MySQL slave. Although this table was not a critical part of the infrastructure, from time to time, writes to the table from the master would break replication. [&]

The post Syncing MySQL slave table with pt-online-schema-change appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/17/syncing-mysql-slave-table-with-pt-online-schema-change/