ameter=<key>,<shell command>,如
UserParameter=check_delay,/scripts/mysql_delay.sh
UserParameter=check_status,/scripts/mysql_status.sh
#重启客户端
[root@Hyrule001 ~]# pkill zabbix
[root@Hyrule001 ~]# zabbix_agentd
#编写监控延迟的脚本
[root@Hyrule ~]# mkdir /scripts
[root@Hyrule ~]# vim /scripts/mysql_delay.sh
#!/bin/bash
master_log_pos=$(mysql -e 'show slave status \G;'|egrep "Read_Master_Log_Pos"|awk '{print $NF}')
exec_log_pos=$(mysql -e 'show slave status \G;'|egrep "Exec_Master_Log_Pos"|awk '{print $NF}')
echo "$[$master_log_pos-$exec_log_pos]"
[root@Hyrule001 Hyrule]# chown zabbix.zabbix /scripts/mysql_delay.sh
[root@Hyrule001 Hyrule]# chmod 777 /scripts/mysql_delay.sh
#编写监控运行状态的脚本
[root@Hyrule ~]# vim /scripts/mysql_status.sh
#!/bin/bash
IO_status=$(mysql -e 'show slave status \G;'|egrep "Slave_IO_Running"|awk '{print $NF}'|grep "Yes"|wc -l)
SQL_status=$(mysql -e 'show slave status \G;'|egrep "Slave_SQL_Running"|awk '{print $NF}'|grep "Yes"|wc -l)
if [ $[$IO_status+$SQL_status] -eq 2 ];
then
echo 0
else
echo 1
fi
[root@Hyrule001 Hyrule]# chown zabbix.zabbix /scripts/mysql_status.sh
[root@Hyrule001 Hyrule]# chmod 777 /scripts/mysql_status.sh
添加监控项、触发器和报警媒介
配置报警媒介详见zabbix监控配置与邮件告警的邮件告警章节