CentOS下zabbix监控mysql5.6版本主从
上次Zabbix添加了监控MySQL性能，因此此次在其基础上添加主从监控，文章过程中不在介绍MySQL5.6版本相关细节处理，具体可以参考上次文章：http://ygqygq2.blog.运维网.com/1009869/1797986
1. Zabbix添加自定义监控流程
[*] Zabbix agentd添加自定义key；
[*] 自定义key调用的是获取监控数据源脚本等；
[*] 添加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 zabbix_select@localhost identified by 'zabbix'"
#Mysql5.6
# mysql_config_editor set --login-path=local --host=localhost --user=zabbix_select -p
MYSQL_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}" = "Yes" -a "${slave_is}" = "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)"
;;
esac2. mysql赋权
grant REPLICATION CLIENT on *.* to zabbix_select@localhost identified by 'zabbix';
3. 查看脚本执行效果
# chmod a+x check_mysql_slave.sh
# sh check_mysql_slave.sh Slave_Running
1
# sh check_mysql_slave.sh Slave_Seconds
0
#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 $25. 添加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
http://img.blog.csdn.net/20170122201559122?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQveWdxeWdxMg==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast
6. 主机链接模板
http://img.blog.csdn.net/20170122202350283?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQveWdxeWdxMg==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast
7. 查看结果
在Zabbi Server端查看：
# /usr/local/zabbix/bin/zabbix_get -s mysql-slave-IP -k "mysql.slave"
0
# /usr/local/zabbix/bin/zabbix_get -s mysql-slave-IP -k "mysql.slave"
1在页面上查看：
http://img.blog.csdn.net/20170122202956583?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQveWdxeWdxMg==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast
页:
[1]