zabbix监控mysql今天值和昨天值对比

脚本：查询数据返回并追加到文件中。进行判断。

[root@localhost~]# cat /etc/zabbix/scripts/number.sh 
#!/bin/bash
/apps/icfcc/MySql-5.7.18/bin/mysql -uroot -pxxxxxx --port=7007 -A -S /apps/data/nifa_dbxp/MysqlNode-0.sock 2>/dev/null -e "use nifa_db;select count(*) from (select distinct(sorganation) from nifa_business_a_info) a ;" >/etc/zabbix/scripts/Today.txt && >> /etc/zabbix/scripts/Today.txt
sudo sed -i 1d /etc/zabbix/scripts/Today.txt
Yesterday=$(cat /etc/zabbix/scripts/Yesterday.txt)
Today=$(cat /etc/zabbix/scripts/Today.txt)
if [ $Today -ge $Yesterday ]
then
    echo "0"
else
    echo "1"
fi
/apps/icfcc/MySql-5.7.18/bin/mysql -uroot -ppassword --port=7007 -A -S /apps/data/nifa_dbxp/MysqlNode-0.sock 2>/dev/null -e "use nifa_db;select count(*) from (select distinct(sorganation) from nifa_business_a_info) a ;" >/etc/zabbix/scripts/Yesterday.txt && >> /etc/zabbix/scripts/Yesterday.txt
sudo sed -i 1d /etc/zabbix/scripts/Yesterday.txt

查询出的文件

[root@localhost ~]# ll /etc/zabbix/scripts/
total 12
-rwxrwxrwx. 1 zabbix zabbix 852 Mar 20 16:19 number.sh
-rwxrwxrwx. 1 zabbix zabbix   4 Mar 21 08:03 Today.txt
-rwxrwxrwx. 1 zabbix zabbix   4 Mar 21 08:03 Yesterday.txt

授权：由于zabbix用户无法调用一些命令权限，所以需要授权

usermod -aG wheel zabbix

zabbix-server端测试

[root@zabbix ~]# zabbix_get -s 172.16.0.218 -p 10050 -k number
0

定义监控项

定义触发器

到最新数据里面查看