主从检测及修复工具Maatkit

1.下载

http://www.maatkit.org/download

http://code.google.com/p/maatkit/downloads/list

2.文档
http://www.maatkit.org/doc/

3.安装
查看INSTALL

perl MAKEFILE.PL PREFIX=~

 

4.检查一致性

./mk-table-checksum h=192.168.200.110,u=remote,p=yourpassword h=192.168.200.111,u=remote,p=yourpassword -d wasu --count|./mk-checksum-filter

根据校验和便知道哪些表不一致了

转载于:https://www.cnblogs.com/istrong/archive/2012/06/07/2540353.html