数据校验工具 pt-table-checksum
2023-04-09 本文已影响0人
古飞_数据
1.构建主从
- 构造数据
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
- 校验
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
