Zabbix监控mysql

Zabbix监控mysql

通过percona官网提供的模板监控mysql，模板下载地址：
https://www.percona.com/downloads/percona-monitoring-plugins/LATEST/

安装percona

# 下载rpm包
wget https://downloads.percona.com/downloads/percona-monitoring-plugins/percona-monitoring-plugins-1.1.8/binary/redhat/7/x86_64/percona-zabbix-templates-1.1.8-1.noarch.rpm
# 安装
rpm -ivh percona-zabbix-templates-1.1.8-1.noarch.rpm
# 安装完成会有以下提示
Scripts are installed to /var/lib/zabbix/percona/scripts # 脚本路径
Templates are installed to /var/lib/zabbix/percona/templates # 模板路径，版本不对

# 将agent配置文件放到/etc/zabbix/zabbix_agentd.d/下
mv /var/lib/zabbix/percona/templates/userparameter_percona_mysql.conf /etc/zabbix/zabbix_agentd.d/

# 修改php用户信息
vi /var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php
$mysql_user = 'zabbix';
$mysql_pass = '123456';

# 重启agent
systemctl restart zabbix-agent.service

# 通过zabbix_get取值
zabbix_get -s 127.0.0.1 -k MySQL.Open-files

导入xml模板

http://pan.baidu.com/s/1pL1wDYj

关联模板获取数据

发现MySQL running slave最新数据没有，权限拒绝

# 修改脚本
vi /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh
RES=`HOME=~zabbix mysql -uroot -e 'SHOW SLAVE STATUS\G' | egrep '(Slave_IO_Running|Slave_SQL_Running):' | awk -F: '{print $2}' | tr '\n' ','`

然后就正常了，如果是主从数据库就会监控到数据了

参考：https://oldqiang.com/archives/213.html