I'm try to use pt-table-checksum tool. I have Master/Slave tables, and I add some rows to the slave to check it.
pt-table-checksum --ignore-databases mysql S=/tmp/5.6.22_3306_Master/data/mysql.sock --user=SlaveUser --password=1234
produce this result:
TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
07-21T16:47:35 0 0 8 1 0 0.008 test.Countries
07-21T16:47:35 0 0 0 1 0 0.006 test.Persons
When I run this query (
How I can see the right result and the diff with pt-table-checksum?
Thanks!
SELECT * FROM percona.checksums WHERE db not like 'mysql';
) on the **slave** I can see the difference:

Asked by ElazarG
(1 rep)
Jul 21, 2016, 01:53 PM
Last activity: Oct 30, 2019, 08:02 PM
Last activity: Oct 30, 2019, 08:02 PM