Trying to verify replication integrity of my replica. And I found that pt-table-checksum
is one of the best ways of doing it.
I have a simple Master->Slave set up. Have created a sample table with 10 rows on the Master, which has successfully replicated on the Slave. Intentionally on the slave I have changed a column in one of the rows of that table. Executed -
pt-table-checksum "h=host,u=user,p=password,P=3306" --function=MD5 --databases=test --tables=tentotal
And indeed in my checksums
table that pt-table-checksum
created, I could see different checksum for master and slave for that table. Excellent so far!
Output was -
TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
09-05T12:17:30 0 0 3 1 0 0.182 test.tentotal
Strangely the DIFF column says 0 which is incorrect. What am I missing here?
Percona tool kit version: 2.1.3