mysql 检查主从数据是否一致

1、master 上创建

create database percona;
CREATE TABLE `percona`.`dsns` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) DEFAULT NULL,
`dsn` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
);

use percona;
insert into dsns(dsn) values('h=从库的IP,P=3318,u=pt_table_check2,p=checksum123');

GRANTSELECT, PROCESS, SUPER, REPLICATION SLAVEON *.* TO pt_table_check2@'192.168.0.%'IDENTIFIEDBY'checksum123';

在主库上

pt-table-checksum -S /tmp/mysql_3316.sock --tables=xxx_sns.sns_users_hp_coin --replicate=percona_schema.checksums --no-check-binlog-format --no-check-replication-filters --recursion-method dsn=t=percona.dsns,h=从库的IP,P=3318,u=pt_table_check2,p=checksum123