zabbix:percona mysql监控插件使用方法
一、配置Zabbix Agent
1、插件安装及配置
下载地址:https://www.percona.com/downloads/percona-monitoring-plugins/
安装percona的监控mysql软件包:
rpm -ivh percona-zabbix-templates-1.1.7-1.noarch.rpm 查看rpm安装的文件路径:
# rpm -ql percona-zabbix-templates-1.1.7-1.noarch
/var/lib/zabbix/percona
/var/lib/zabbix/percona/scripts
/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh
/var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php
/var/lib/zabbix/percona/templates
/var/lib/zabbix/percona/templates/userparameter_percona_mysql.conf
/var/lib/zabbix/percona/templates/zabbix_agent_template_percona_mysql_server_ht_2.0.9-sver1.1.7.xml 其中get_mysql_stats_wrapper.sh和ss_get_mysql_stats.php是mysql监控脚本,供zabbix agent调用;userparameter_percona_mysql.conf是zabbix agent的配置文件,包含了mysql监控的自定义key;zabbix_agent_template_percona_mysql_server_ht_2.0.9-sver1.1.7.xml是zabbix模板文件,需要在zabbix web端导入。
查看zabbix agent的Include目录:
# grep '^Include' /etc/zabbix/zabbix_agentd.conf
Include=/etc/zabbix/zabbix_agentd.d/ 复制配置文件到zabbix agent的Include目录:
cp /var/lib/zabbix/percona/templates/userparameter_percona_mysql.conf /etc/zabbix/zabbix_agentd.d/ 进入percona的脚本目录:
cd /var/lib/zabbix/percona/scripts 修改脚本里的mysql连接地址:
vim get_mysql_stats_wrapper.sh
HOST=localhost 创建mysql连接配置文件ss_get_mysql_stats.php.cnf,写入用户名和密码:
vim ss_get_mysql_stats.php.cnf
页:
[1]