正文
毕业设计之zabbix 之mysql主从状态的监控
小程序:扫一扫查出行
【扫一扫了解最新限行尾号】
复制小程序
【扫一扫了解最新限行尾号】
复制小程序
建立监控脚本在自定义的位置
/usr/local/zabbix/script/
[root@mysql.quan.bbs script]$pwd
/usr/local/zabbix/script
[root@mysql.quan.bbs script]$cat mysql_status_replication.sh
#!/bin/bash
#
#********************************************************************
#Author: betterman
#QQ: 1602604658
#Date: 2020-03-03
#FileName: mysql_status_replication.sh
#URL: https://www.cnblogs.com/betterquan/
#Description: The test script
#Copyright (C): 2020 All rights reserved
#********************************************************************
#
user='root'
password="20004"
item=$1
function slave_io_status()
{
io_status=`mysql -u root -p2004 -e "show slave status\G;" 2>/dev/null |grep " Slave_IO_Running" |awk '{print $2}'`
if [ "$io_status" == "Yes" ]
then
echo 1
else
echo 0
fi
} function slave_sql_status()
{
sql_status=`mysql -u root -p2004 -e "show slave status\G;" 2>/dev/null |grep "Slave_SQL_Running" |awk '{print $2}' |head -1`
if [ "$sql_status" == "Yes" ]
then
echo 1
else
echo 0
fi
} case $item in
io.status)
slave_io_status
;;
sql.status)
slave_sql_status
;;
*)
echo "Usage:$0 [io.status | sql.status]"
esac
修改配置文件,包括变量配置目录
[root@mysql.quan.bbs script]$vim /usr/local/zabbix/etc/zabbix_agentd.conf # Include=/usr/local/etc/zabbix_agentd.userparams.conf
#Include=/usr/local/etc/zabbix_agentd.conf.d/
#Include=/usr/local/etc/zabbix_agentd.conf.d/*.conf
Include=/usr/local/zabbix/etc/zabbix_agentd.conf.d/
编辑变量配置文件
[root@mysql.quan.bbs script]$vim /usr/local/zabbix/etc/zabbix_agentd.conf.d/userparameter_mysql_re_status.conf UserParameter=mysql_re.satus[*],/usr/local/zabbix/script/mysql_status_replication.sh $1
重启zabbix_agent
zabbix_server 测试
[root@ansz.quan.bbs logs]$zabbix_get -s 192.168.111.151 -k mysql_re.satus[sql.status]
1
[root@ansz.quan.bbs logs]$zabbix_get -s 192.168.111.151 -k mysql_re.satus[io.status]
1
web页面配置
创建主机组 MYSQL
创建模板:Template mysql_replication
监控项