pt-table-checksum使用

30 3 * * * /home/backup/pt-checksum/check_differ.sh

–/home/backup/pt-checksum/check_differ.sh
#!/bin/bash
base="/var/sofware/mysql/percona-toolkit-2.2.14/bin"
sh $base/checksum.sh |sed 1d|awk ‘{ if ($3 == 1) {print $0}}’ > $base/b_2016102705

–checksum.sh
#!/bin/bash
base="/var/sofware/mysql/percona-toolkit-2.2.14/bin"
$base/pt-table-checksum --nocheck-replication-filters --no-check-binlog-format --recursion-method=hosts --replicate=zk.checksum --databases=db001
–tables=t1 h=ip,u=checksum,p=“xxxx”,P=3306