基于mysql主从,在客户端操作
1.配置mysql监控主从脚本,创建用户
[root@kafka01 ~]# cd /etc/zabbix/scripts/
[root@kafka01 scripts] vim check_mysql.sh^C
[root@kafka01 scripts] cat check_mysql.sh
#!/bin/bash
case $1 in
slave_status)
mysql -uchecke -p123 -e "show slave status \G;" | grep 'Running' | grep "Yes" |wc -l
;;
esac
#在slave库创建授权用户
MariaDB [(none)]> grant all on *.* to 'checke'@'localhost' identified by '123';
MariaDB [(none)]> flush privileges;
2,编辑客户端配置文件,并重启
[root@kafka01 zabbix] vim /etc/zabbix/zabbix_agentd.d/chkc_mysql.conf
[root@kafka01 zabbix] cat /etc/zabbix/zabbix_agentd.d/chkc_mysql.conf
UserParameter=mysql_status[*],/etc/zabbix/scripts/check_mysql.sh $1
systemctl restart zabbix-agent
3.在zabbix服务端测试
[root@kafka02 ~]# zabbix_get -s 192.168.245.173 -k mysql_status[slave_status]
2
#返回值是2 位正常