Not the answer you need?
Register and ask your own question!

Use pt-table-checksum

Elazar GurElazar Gur EntrantInactive User Role Beginner
Hi,

I have 2 Mysql instances, Master & Slave. I added some rows to the slave so it is nor consistent with the master.

When I run pt-table-checksum I don't see any DIFFS:
ii1> pt-table-checksum --empty-replicate-table -d test S=/tmp/5.6.22_3306_[B]Master[/B]/data/mysql.sock --user=SlaveUser --password=***
            TS ERRORS  DIFFS     ROWS  CHUNKS SKIPPED    TIME TABLE
07-11T17:02:15      0      0        7       1       0   0.008 test.Countries
07-11T17:02:15      0      0        0       1       0   0.006 test.Persons
ii1> 
ii1> pt-table-checksum --empty-replicate-table -d test S=/tmp/5.6.22_3310_[B]Slave[/B]/data/mysql.sock --user=SlaveUser --password=***
            TS ERRORS  DIFFS     ROWS  CHUNKS SKIPPED    TIME TABLE
07-11T17:02:20      0      0       13       1       0   0.007 test.Countries
07-11T17:02:20      0      0        0       1       0   0.006 test.Persons

What am I missing?

Thanks
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.