数据校验工具 pt-table-checksum

1.构建主从

2. 构造数据

sysbench /usr/share/sysbench/oltp_read_write.lua --mysql-host=10.186.63.82 \
--mysql-port=4380 --mysql-user=gengjin --mysql-password=123 --mysql-db=test \
--table-size=1000000 --tables=10 --threads=50 --report-interval=3 --time=20 prepare

3. 校验

wget https://www.percona.com/downloads/percona-toolkit/3.1.0/binary/tarball/percona-toolkit-
3.1.0_x86_64.tar.gz
yum -y install perl-devel perl-Digest-MD5 perl-DBI perl-DBD-MySQL perl-IO-Socket-SSL.noarch perl-Time-HiRes
cd percona-toolkit-3.1.0/
perl Makefile.PL PREFIX=/usr/local/
make
make install

pt-table-checksum h=10.186.63.82,u=gengjin,p='123',P=3306 --databases=test --tables=sbtest1,sbtest2 --nocheck-replication-filters

https://zhuanlan.zhihu.com/p/340411904