利用Zabbix监控mysql主从
mysql主从监控#脚本如下，截取主从关键字
cat check_mysql_slave.sh #!/bin/bash# declare -a 定义数组，slave_is 会被视为数组declare -a slave_isslave_is=($(/data/mysql/bin/mysql -e "show slave status\G"|grep -E "Slave_IO_Running|Slave_SQL_Running:"|awk '{print $2}'))if [ "${slave_is}" = "Yes" -a "${slave_is}" = "Yes" ];then echo "ok -slave is running" exit 0else echo "down -slave is not running" exit 2fi #zabbix_agentd.conf文件的配置如下：
cat zabbix_agentd.conf | grep -v "^#" | grep -v "^$"LogFile=/tmp/zabbix_agentd.logEnableRemoteCommands=1Server=10.74.246.70ListenPort=10050ServerActive=10.74.246.70Hostname=10.74.244.33AllowRoot=1Include=/usr/local/zabbix/etc/zabbix_agentd.conf.d/*.confUnsafeUserParameters=1UserParameter=tomcat_port,/usr/local/zabbix/share/zabbix/alertscripts/tomcat_port.sh $1UserParameter=tcp
[*],/usr/local/zabbix/share/zabbix/alertscripts/tcp_connection.sh $1UserParameter=nginx_port,/usr/local/zabbix/share/zabbix/alertscripts/nginx_port.sh $1UserParameter=erro_log
[*],/usr/local/zabbix/share/zabbix/alertscripts/error_log.sh $1#mysql主从监控脚本，grep -c "ok",ok出现的次数UserParameter=mysql.slave,/usr/local/zabbix/share/zabbix/alertscripts/check_mysql_slave.sh | grep -c 'ok' #创建自定义模板：
https://s4.51cto.com/wyfs02/M02/8D/C5/wKioL1iqlzuwt5IAAAB1cMKGs0M728.png-wh_500x0-wm_3-wmp_4-s_3373413785.png
#创建应用集：
https://s2.51cto.com/wyfs02/M00/8D/C7/wKiom1iql0qziLLoAAA-Z5gK6yo795.png-wh_500x0-wm_3-wmp_4-s_320333487.png
#创建监控项：
https://s5.51cto.com/wyfs02/M00/8D/C5/wKioL1iql1nRqEVSAACBBxQ-w-4399.png-wh_500x0-wm_3-wmp_4-s_2334766626.png
#创建触发器：
https://s3.51cto.com/wyfs02/M02/8D/C5/wKioL1iql2qQ4r1yAABWusrBR98896.png-wh_500x0-wm_3-wmp_4-s_3378958502.png
#添加mysql-slave监控图形：
https://s3.51cto.com/wyfs02/M00/8D/C7/wKiom1iql3exr7dfAAByRawHVEs909.png-wh_500x0-wm_3-wmp_4-s_661076081.png
#查看图形监控效果：
https://s4.51cto.com/wyfs02/M01/8D/C5/wKioL1iql8fT8n63AACjkApsH4k989.png-wh_500x0-wm_3-wmp_4-s_1272964032.png
模板文件下载：
页:
[1]