CentOS下zabbix監控mysql5.6版本主從

標籤：zabbix   mysql   主從   

上次Zabbix添加了監控MySQL效能，因此此次在其基礎上添加主從監控。文章過程中不在介紹MySQL5.6版本相關細節處理，具體可以參考上次文章： 
http://blog.csdn.net/ygqygq2/article/details/53264955

1. Zabbix添加自訂監控流程

1. Zabbix agentd添加自訂key；

2. 自訂key調用的是擷取監控資料來源指令碼等；

3. 添加Zabbix主機資料來源模板，主機連結模板;

2. 具體步驟1. 編寫監控mysql主從指令碼

vim /usr/local/zabbix/shell/check_mysql_slave.sh

#!/usr/bin/env bash#Create by zijin 2014.09.28##Need "grant REPLICATION CLIENT on *.* to [email protected] identified by ‘zabbix‘"#Mysql5.6# mysql_config_editor set --login-path=local --host=localhost --user=zabbix_select -pMYSQL_SOCK="/tmp/mysql.sock" MYSQL_PWD="zabbix"MYSQL="/usr/local/mysql/bin/mysql"MYSQL_ADMIN="${MYSQL}admin"ARGS=1 if [ $# -ne "$ARGS" ];then     echo "Please input one arguement:" fi case $1 in         Slave_Running)                 slave_is=($(sudo ${MYSQL} --login-path=local -S $MYSQL_SOCK -e "show slave status\G"|egrep "\bSlave_.*_Running\b"|awk ‘{print $2}‘))                if [ "${slave_is[0]}" = "Yes" -a "${slave_is[1]}" = "Yes" ];then                     result="1"                else                     result="0"                fi                echo $result        ;;        Seconds_Behind)                result=$(sudo ${MYSQL} --login-path=local -S $MYSQL_SOCK -e "show slave status\G"|egrep "\bSeconds_Behind_Master\b"|awk ‘{print $2}‘)                echo $result        ;;        *)                 echo "Usage:$0(Slave_Running|Seconds_Behind)"         ;; esac 1234567891011121314151617181920212223242526272829303112345678910111213141516171819202122232425262728293031

2. mysql賦權

grant REPLICATION CLIENT on *.* to [email protected] identified by ‘zabbix‘;

3. 查看指令碼執行效果

[[email protected] shell]# chmod a+x check_mysql_slave.sh [[email protected] shell]# sh check_mysql_slave.sh Slave_Running                                                    1[[email protected] shell]# sh check_mysql_slave.sh Slave_Seconds0[[email protected] shell]#123456123456

4. Zabbix用戶端添加自訂key

vim /usr/local/zabbix/etc/zabbix_agentd.conf.d/check_mysql_slave_key

UserParameter=mysql.slave[*],/usr/local/zabbix/shell/check_mysql_slave.sh $1 $211

5. 添加Zabbix監控MySQL主從模板

從Zabbix頁面匯入模板Template App MySQL Slave.xml，如下連結為模板地址： 
https://github.com/ygqygq2/zabbix/blob/master/%E6%A8%A1%E6%9D%BF/Template%20App%20MySQL%20Slave.xml 
650) this.width=650;" src="http://img.blog.csdn.net/20170122201559122?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQveWdxeWdxMg==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="這裡寫圖片描述" title="" style="border:none;height:auto;" />

6. 主機連結模板

650) this.width=650;" src="http://img.blog.csdn.net/20170122202350283?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQveWdxeWdxMg==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="這裡寫圖片描述" title="" style="border:none;height:auto;" />

7. 查看結果

在Zabbi Server端查看：

[[email protected] ~]# /usr/local/zabbix/bin/zabbix_get -s mysql-slave-IP -k "mysql.slave[Seconds_Behind]"0[[email protected] ~]# /usr/local/zabbix/bin/zabbix_get -s mysql-slave-IP -k "mysql.slave[Slave_Running]" 112341234

在頁面上查看： 
650) this.width=650;" src="http://img.blog.csdn.net/20170122202956583?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQveWdxeWdxMg==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="這裡寫圖片描述" title="" style="border:none;height:auto;" />

本文出自 “ygqygq2” 部落格，請務必保留此出處http://ygqygq2.blog.51cto.com/1009869/1893783

CentOS下zabbix監控mysql5.6版本主從