如何在Zabbix上安装MySQL监控插件PMP

PMP，全称是Percona Monitoring Plugins，是Percona公司为MySQL监控写的插件。支持Nagios，Cacti。从PMP 1.1开始，支持Zabbix。下面，看看如何在Zabbix上安装PMP。配置Zabbix Agent下载PMP下载地址：https://www.percona.com/downloads/percona-monitoring-plugins/因为我的Linux版本是RHEL 6.7，故选择RPM包 # wget https://www.percona.com/downloads/percona-monitoring-plugins/1.1.6/percona-zabbix-templates-1.1.6-1.noarch.rpm# rpm -ivh percona-zabbix-templates-1.1.6-1.noarch.rpmwarning: percona-zabbix-templates-1.1.6-1.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEYPreparing...########################################### [100%] 1:percona-zabbix-template########################################### [100%]Scripts are installed to /var/lib/zabbix/percona/scriptsTemplates are installed to /var/lib/zabbix/percona/templates 拷贝PMP的配置文件# cp /var/lib/zabbix/percona/templates/userparameter_percona_mysql.conf /etc/zabbix/zabbix_agentd.d/确保Zabbix-Agent配置文件中已经开启Include=/etc/zabbix/zabbix_agentd.d/ 重启Zabbix-Agent服务# service zabbix-agent restart 创建MySQL的监控用户mysql> grant process,super,select on *.* to monitor@"localhost" identified by "monitor";mysql> flush privileges; 修改脚本中的用户名和密码# vim /var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php$mysql_user = "monitor";$mysql_pass = "monitor";$mysql_port = 3306; 测试脚本能否获取到数据库的状态信息该脚本需测试两部分内容1. MySQL实例本身的状态变量2. MySQL是否为Slave 测试MySQL实例本身的状态变量# /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh gg/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh: line 35: /usr/bin/php: No such file or directoryERROR: run the command manually to investigate the problem: /usr/bin/php -q /var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php --host localhost --items gg因为它的脚本是用PHP实现的，故需要安装php和php-mysql# yum install php php-mysql重新测试该脚本# /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh gg有值返回就代表OK 测试MySQL是否为Slave# /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh running-slave返回0和1是正常值，返回“Access denied”则有问题。 导入PMP的模板即/var/lib/zabbix/percona/templates目录中的zabbix_agent_template_percona_mysql_server_ht_2.0.9-sver1.1.6.xml一些Zabbix相关教程集合：Ubuntu 14.04下Zabbix2.4.5 源码编译安装 http://www.linuxidc.com/Linux/2015-05/117657.htm安装部署分布式监控系统Zabbix 2.06 http://www.linuxidc.com/Linux/2013-07/86942.htm《安装部署分布式监控系统Zabbix 2.06》 http://www.linuxidc.com/Linux/2013-07/86942.htmCentOS 6.3下Zabbix安装部署 http://www.linuxidc.com/Linux/2013-05/83786.htmZabbix分布式监控系统实践 http://www.linuxidc.com/Linux/2013-06/85758.htmCentOS 6.3下Zabbix监控apache server-status http://www.linuxidc.com/Linux/2013-05/84740.htmCentOS 6.3下Zabbix监控MySQL数据库参数 http://www.linuxidc.com/Linux/2013-05/84800.htm64位CentOS 6.2下安装Zabbix 2.0.6 http://www.linuxidc.com/Linux/2014-11/109541.htmZABBIX 的详细介绍：请点这里
ZABBIX 的下载地址：请点这里本文永久更新链接地址