使用percona插件监控mysql
一、下载插件
https://www.percona.com/downloads/percona-monitoring-plugins/LATEST/
二、安装在有数据库的机器上
1、上传、安装
[root@zabbix ~]# rz percona-zabbix-templates-1.1.8-1.noarch.rpm
[root@zabbix ~]# rpm -ivh percona-zabbix-templates-1.1.8-1.noarch.rpm
warning: percona-zabbix-templates-1.1.8-1.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:percona-zabbix-templates-1.1.8-1 ################################# [100%]
Scripts are installed to /var/lib/zabbix/percona/scripts
Templates are installed to /var/lib/zabbix/percona/templates
#####
模板:Templates are installed to /var/lib/zabbix/percona/templates
[root@zabbix /var/lib/zabbix/percona/templates]# ll
total 284
-rw-r--r-- 1 root root 18866 Jan 10 2018 userparameter_percona_mysql.conf
-rw-r--r-- 1 root root 269258 Jan 10 2018 zabbix_agent_template_percona_mysql_server_ht_2.0.9-sver1.1.8.xml
三、添加mysql监控
1、下载xml模板文件
链接:https://pan.baidu.com/s/1SHwNNRTfVNVmp9T5o3upxQ
提取码:agu8
2、导入模板
3、添加修改配置文件
1)查看
[root@zabbix /var/lib/zabbix/percona/templates]# ll
total 284
-rw-r--r-- 1 root root 18866 Jan 10 2018 userparameter_percona_mysql.conf
-rw-r--r-- 1 root root 269258 Jan 10 2018 zabbix_agent_template_percona_mysql_server_ht_2.0.9-sver1.1.8.xml
2)mv移动配置文件
[root@zabbix /var/lib/zabbix/percona/templates]# mv userparameter_percona_mysql.conf /etc/zabbix/zabbix_agentd.d/
3)重启zabbix客户端
systemctl restart zabbix-agent.service
4)修改php文件用户及密码
vim /var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php
...
$mysql_user = 'zabbix';
$mysql_pass = '123456';
....
4、命令行取值
[root@zabbix /etc/zabbix/zabbix_agentd.d]# zabbix_get -s 127.0.0.1 -k MySQL.Open-files
21