Search Results

Installation apt-get -y install percona-toolkit Priviledges 目标库 GRANT SELECT ON foo.* TO 'pttable'@'%'; 校验结果库 GRANT CREATE, INSERT, UPDATE, DELETE ON percona.* TO 'pttable'@'%'; 其它权限 GRANT PROCESS, REPLICATION CLIENT, REPLICATION SLAVE ON *.* TO 'pttable'@...

Usage Print Diff pt-table-sync \ --print \ --chunk-size=1000 \ h=master_host,P=3306,u=root,p=123456,D=mydb,t=mytable \ h=slave_host,P=3306,u=root,p=123456 Execute Diff pt-table-sync \ --execute \ --chunk-size=1000 \ h=master_host,P=3306,u=root,...