mysql: master:192.168.0.11 slave:192.168.0.12 [master]# yum install perl-IO-Socket-SSL perl-DBD-MySQL
[master]#cd /opt
[master]# wget https://www.percona.com/downloads/percona-toolkit/3.0.2/binary/redhat/6/x86_64/percona-toolkit-3.0.2-1.el6.x86_64.rpm
[master]# wget https://www.percona.com/downloads/percona-toolkit/3.0.2/binary/redhat/6/x86_64/percona-toolkit-debuginfo-3.0.2-1.el6.x86_64.rpm
[master]# rpm -ivh percona-toolkit-debuginfo-3.0.2-1.el6.x86_64.rpm
[master]# rpm -ivh percona-toolkit-3.0.2-1.el6.x86_64.rpm
[master]mysql> GRANT SELECT,PROCESS,SUPER,REPLICATION SLAVE ON *.* TO ‘checksums’@’192.168.0.%’ IDENTIFIED BY ‘passwd’;
[master]mysql> CREATE database pt CHARACTER SET utf8;
[master]mysql> GRANT ALL PRIVILEGES ON pt.* TO ‘checksums’@’192.168.0.%’ IDENTIFIED BY ‘passwd’;
[master]mysql> CREATE TABLE IF NOT EXISTS pt.checksums (
db CHAR(64) NOT NULL,
tbl CHAR(64) NOT NULL,
chunk INT NOT NULL,
chunk_time FLOAT NULL,
chunk_index VARCHAR(200) NULL,
lower_boundary TEXT NULL,
upper_boundary TEXT NULL,
this_crc CHAR(40) NOT NULL,
this_cnt INT NOT NULL,
master_crc CHAR(40) NULL,
master_cnt INT NULL,
ts TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (db,tbl,chunk),
INDEX ts_db_tbl(ts,db,tbl)
) ENGINE=InnoDB;
[master]mysql> \q
[master]# pt-table-checksum h=’192.168.0.11′,u=’checksums’,p=’passwd’,P=3306 -d test –nocheck-replication-filters –replicate=pt.checksums –no-check-binlog-format
[master]# pt-config-diff h=localhost h=192.168.0.12 –user=checksums –password=passwd