利用Zabbix监控mysql主从

megnlingling

　　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[0]}" = "Yes" -a "${slave_is[1]}" = "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'　　#创建自定义模板：

　　#创建应用集：

　　#创建监控项：

　　#创建触发器：

　　#添加mysql-slave监控图形：

　　#查看图形监控效果：

　　模板文件下载：