psong wrote: »
pt-table-checksum needs to be run on the master. It automatically detects the slaves by methods defined in --recursion-method, where the default being processlist, hosts. It runs the checksum queries on the master, and saves the results to a table. It uses statement-based replication for the session and so the same checksum query will be executed on the slaves as well. The default table that stores the checksum results is percona.checksums, which could be set by --replicate option. At the end, the tool queries the checksum table on the slaves and output any inconsistency.
Please refer to the document for more details and options: http://www.percona.com/doc/percona-toolkit/2.2/pt-table-checksum.html#cmdoption-pt-table-checksum--recursion-method
Give it a try and take a look at percona.checksums table on master and slave to see what the tool recorded.
MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.