mysql集群软件_maatkit--MySQL集群管理工具（Mysql管理必备工具Maatkit详解

sedby other processes.mk-show-grants Canonicalize and print MySQL grants so you can effectively replicate, compare and version-control them.mk-slave-delay Make a MySQL slave server lag behind its master.mk-slave-find Find MySQL replication slaves and execute commands on them.mk-slave-move Move a MySQL slave around in the replication hierarchy.mk-slave-prefetch Pipeline relay logs on a MySQL slave to pre-warm caches.mk-slave-restart Watch and restart MySQL replication after errors.mk-table-checksum Perform an online replication consistency check, or checksum MySQL tables efficiently on one or many servers.mk-table-sync Synchronize MySQL tables efficiently.mk-visual-explain Format EXPLAIN output as a tree.-r-xr-xr-x 1 root root 76K Jan 19 16:19 mk-slave-prefetch-r-xr-xr-x 1 root root 56K Jan 19 16:19 mk-slave-move-r-xr-xr-x 1 root root 64K Jan 19 16:19 mk-query-profiler-r-xr-xr-x 1 root root 26K Jan 19 16:19 mk-profile-compact-r-xr-xr-x 1 root root 119K Jan 19 16:19 mk-log-parser-r-xr-xr-x 1 root root 67K Jan 19 16:19 mk-heartbeat-r-xr-xr-x 1 root root 59K Jan 19 16:19 mk-find-r-xr-xr-x 1 root root 187K Jan 19 16:19 mk-table-sync-r-xr-xr-x 1 root root 180K Jan 19 16:19 mk-table-checksum-r-xr-xr-x 1 root root 53K Jan 19 16:19 mk-slave-find-r-xr-xr-x 1 root root 45K Jan 19 16:19 mk-slave-delay-r-xr-xr-x 1 root root 38K Jan 19 16:19 mk-show-grants-r-xr-xr-x 1 root root 64K Jan 19 16:19 mk-parallel-restore-r-xr-xr-x 1 root root 118K Jan 19 16:19 mk-parallel-dump-r-xr-xr-x 1 root root 50K Jan 19 16:19 mk-deadlock-logger-r-xr-xr-x 1 root root 101K Jan 19 16:19 mk-audit-r-xr-xr-x 1 root root 116K Jan 19 16:19 mk-archiver-r-xr-xr-x 1 root root 71K Jan 19 16:19 mk-visual-explain-r-xr-xr-x 1 root root 75K Jan 19 16:19 mk-slave-restart-r-xr-xr-x 1 root root 69K Jan 19 16:19 mk-duplicate-key-checker-r-xr-xr-x 1 root root 26K Jan 19 16:19 mk-checksum-filter示例：[root@ldap-b

~]# mk-table-checksum -g mysql,information-schame--count -d test

u=root,h=127.0.0.1,P=3333 u=root,h=127.0.0.1,P=4444DATABASE TABLE      CHUNK HOST       ENGINE       COUNT          CHECKSUM TIME WAIT STAT  LAGtest      my_cms_00      0 127.0.0.1 MyISAM           7          a5a17d45     0     0 NULL NULLtest      my_cms_00      0 127.0.0.1 MyISAM           7          a5a17d45     0     0 NULL NULLtest      my_cms_01      0 127.0.0.1 MyISAM          11          919e0949     0     0 NULL NULLtest      my_cms_01      0 127.0.0.1 MyISAM          11          919e0949     0     0 NULL NULLtest      my_cms_02      0 127.0.0.1 MyISAM           0              NULL     0     0 NULL NULLtest      my_cms_02      0 127.0.0.1 MyISAM           0              NULL     0     0 NULL NULLtest      xx             0 127.0.0.1 MyISAM           0              NULL     0     0 NULL NULLtest      xx             0 127.0.0.1 MyISAM           0              NULL     0     0 NULL NULLtest      yy             0 127.0.0.1 InnoDB         102          aeb84950     0     0 NULL NULLtest      yy             0 127.0.0.1 InnoDB         102          aeb84950     0     0 NULL NULL