使用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

				

					
				
				

					
				
				

					
				
				

					
				
			

5、关联模板

6、查看数据

7、发现少一个监控项关于主从的

1）手动执行脚本