Data inconsistencies in replication environments are a pretty common. There are lots of posts that explain how to fix those using pt-table-checksum and pt-table-sync. Usually we only care about the data but from time to time we receive this question in support: How can I check the table definition consistency between servers? Replication also allow [&]

The post Checking table definition consistency with mysqldiff appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/04/15/checking-table-definition-consistency-mysqldiff/