pt-table-checksum使用记录

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]# 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
Print Friendly

发表评论

电子邮件地址不会被公开。 必填项已用*标注