1. percona-toolkit 安装
pt-table-checksum 和 pt-table-sync 是它的几个组件
wget http://www.percona.com/get/percona-toolkit.tar.gz
tar zxvf percona-toolkit-2.2.13.tar.gz
cd percona-toolkit-2.2.13
perl Makefile.PL
make && make install
yum install perl-DBI
yum install perl-DBD-MySQL
yum install perl-Time-HiRes
yum install perl-IO-Socket-SSL
如果出现 Can't locate ExtUtils/MakeMaker.pm
yum install perl-ExtUtils-CBuilder perl-ExtUtils-MakeMaker cpan
如果出现过 Can't locate Digest/MD5.pm
yum install -y perl-Digest-MD5
2. 安装成功后检验
$ pt-query-digest --help
$ pt-table-checksum --help
3. checksum 检查
pt-table-checksum -h 10.5.XXX.169 -u root -p '123456' -P 3307 --databases=xxxx --nocheck-replication-filters
4. sync 修复
pt-table-sync --print --verbose --execute--sync-to-master h=192.168.8.111,P=3306,u=copy,p='123456'--databases=xxxx;
--print 每次修复前,需要用户确认;
--execute 执行查询,使表具有相同数据;
--sync-to-master Treat the DSN as a slave and sync it to itsmaster
--verbose 输出明细