Mysql主從管理軟件Maatkit

小版主殺手

1.配置完DBD,mysql,DBI.perl環(huán)境應(yīng)該系統(tǒng)默認(rèn)就安裝好了�？梢詐erl -v 查看下
進(jìn)redhat5 安裝光盤，安裝
rpm -ivh perl-DBI-1.52-2.el5.x86_64.rpm
然后安裝
rpm -ivh MySQL-shared-compat-5.5.15-1.rhel4.x86_64
最后就可以無依賴的安裝DBD
rpm -ivh perl-DBD-MySQL-3.0007-2.el5.x86_64.rpm

接著 進(jìn)入
安裝只要幾個(gè)命令:
# cd maatkit-2725/
# perl Makefile.PL
# make
# make install

可以使用
mk-table-checksum h=192.168.0.1,u=root,p=mysql密碼 h=192.168.0.2,u=root,p=mysql密碼 -d test -t test
DATABASE TABLE           CHUNK HOST          ENGINE      COUNT         CHECKSUM TIME WAIT STAT  LAG
wohenhao busi_film     0 192.168.1.127 InnoDB       NULL       3239810890    0    0 NULL NULL
wohenhao busi_film     0 192.168.1.128 InnoDB       NULL       3239810890    0    0 NULL NULL

解釋下輸出的意思：
DATABASE：數(shù)據(jù)庫(kù)名
TABLE：表名
CHUNK：checksum時(shí)的近似數(shù)值
HOST：MYSQL的地址
ENGINE：表引擎
COUNT：表的行數(shù)
CHECKSUM：校驗(yàn)值
TIME：所用時(shí)間
WAIT：等待時(shí)間
STAT：MASTER_POS_WAIT()返回值
LAG：slave的延時(shí)時(shí)間
這里需要順帶介紹下mk-table-checksum的過濾工具mk-checksum-filter，例如我只想知道上面的例子中，test庫(kù)中哪些表不是一致的。只需要加一個(gè)管道符
mk-table-checksum h=192.168.1.127,u=root,p=123456 h=192.168.1.128,u=root -d wohenhao  |mk-checksum-filter
如果不一致會(huì)提示，如
wohenhao.busi_user does not exist on slave 192.168.1.128:3306 at /usr/bin/mk-table-checksum line 6883.
wohenhao busi_user             0 192.168.1.127 InnoDB       NULL       2486274203    0    0 NULL NULL
wohenhao busi_user             0 192.168.1.128 InnoDB       NULL             NULL    0    0 NULL NULL
一致的話無任何提示



下面是一些有用的功能
1、mk-table-checksum 檢查主從表是否一致及有效的工具
2、mk-table-sync 使表一致的工具，不必重載從表而能夠保證一致
3、mk-visual-explain exlpain解釋工具
4、mk-heartbeat 主從同步的監(jiān)視工具，能夠給出從落后于主多少
5、mk-parallel-dump 多線程的mysqldump工具
6、mk-parallel-restore 多線程的表修復(fù)工具
7、mk-query-profiler 查詢檢測(cè)分析工具
8、mk-deadlock-logger 死鎖的記錄工具
9、mk-duplicate-key-checker key偵測(cè)工具
10、mk-show-grants 權(quán)限管理顯示工具
11、mk-slave-restart slave的檢測(cè)和重啟工具
12、mk-slave-delay slave delay replication 的工具
mk-archiver Archive rows from a MySQL table into another table or a file.
mk-audit Analyze, summarize and report on MySQL config, schema and operation
mk-checksum-filter Filter checksums from mk-table-checksum.
mk-deadlock-logger Extract and log MySQL deadlock information.
mk-duplicate-key-checker Find possible duplicate indexes and foreign keys on MySQL tables.
mk-fifo-split Split files and pipe lines to a fifo without really splitting.
mk-find Find MySQL tables and execute actions, like GNU find.
mk-heartbeat Monitor MySQL replication delay.
mk-log-parser Analyze and review MySQL logs.
mk-log-player Split and play MySQL slow logs.
mk-log-server Serve MySQL binary logs.
mk-parallel-dump Dump sets of MySQL tables in parallel.
mk-parallel-restore Load files into MySQL in parallel.
mk-profile-compact Compact the output from mk-query-profiler.
mk-query-profiler Execute SQL statements and print statistics, or measure activity caused by 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

小版主殺手

歡迎樓下補(bǔ)充  :wink:

ning_lianjie

顯現(xiàn)已經(jīng)在percona中更新了
pt-tools