pt工具使用

pt-table-checksum h='IP',u='pt_checksum',p='pt_checksum',P=3307 -d test --nocheck-replication-filters --no-check-binlog-format  --nocheck-plan

 pt-table-checksum h='IP',u='pt_checksum',p='pt_checksum',P=3307 -d test --nocheck-replication-filters --no-check-binlog-format

07-29T18:38:03 Skipping chunk 2 of test.difftime because it is oversized.  The current chunk size limit is 20896 rows (chunk size=10448 * chunk size limit=2.0), but MySQL estimates that there are 22700 rows in the chunk.

pt-table-sync --replicate=percona.checksums h=IP,u=pt_checksum,p=pt_checksum,P=3307 h=IP,u=pt_checksum,p=pt_checksum,P=3308 –print

 pt-table-sync --replicate=percona.checksums h=IP,u=pt_checksum,p=pt_checksum,P=3307 h=IP,u=pt_checksum,p=pt_checksum,P=3308 --execute

 

yum install perl-DBI

yum install perl-DBD-MySQL

yum install perl-Time-HiRes

yum install perl-IO-Socket-SSL

perl(Term::ReadKey) is needed by percona-toolkit-3.0.4-1.el6.x86_64

rpm -ivh perl-TermReadKey-2.30-13.el6.x86_64.rpm