安装：
wget
tar zxvf percona-toolkit-2.2.16.tar.gz
cd percona-toolkit-2.2.16
yum install -y perl-ExtUtils-MakeMaker perl-ExtUtils-CBuilder perl perl-DBI perl-DBD-MySQL perl-IO-Socket-SSL perl-Time-HiRes
perl Makefile.PL;make;make install
校验数据一致性：
pt-table-checksum h='172.16.8.151',u='checksums',p='checksums',P=3306 --nocheck-replication-filters --replicate=test.checksums --no-check-binlog-format --databases=mysql
阅读(1832) | 评论(0) | 转发(0) |
