[TOC]
## 一.环境准备
```python
[zabbix-agent]
主机名 = host-1
系统 = centos-7.3
地址 = 1.1.1.1
软件 = percona-1.1.6
```
[percona](https://www.percona.com/doc/percona-monitoring-plugins/1.1/zabbix/index.html "percona")是zabbix的一个模板,相比于自带的监控更加详细。
## 二.程序安装
yum依赖
`yum -y install php php-mysql`
2.安装插件
`yum -y install https://www.percona.com/downloads/percona-monitoring-plugins/1.1.6/percona-zabbix-templates-1.1.6-1.noarch.rpm`
3.目录说明
脚本
/var/lib/zabbix/percona/scripts
get_mysql_stats_wrapper.sh
ss_get_mysql_stats.php
模板
/var/lib/zabbix/percona/templates
userparameter_percona_mysql.conf
zabbix_agent_template_percona_mysql_server_ht_2.0.9-sver1.1.6.xml
4.修改脚本php,账号密码
`vim /var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php`
![file](http://linkdevops.oss-cn-beijing.aliyuncs.com/wp-content/uploads/2020/04/image-1586940831666.png)
如果监听本地的mysql则将localhost替换为127.0.0.1
`vim /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh`
![file](http://linkdevops.oss-cn-beijing.aliyuncs.com/wp-content/uploads/2020/04/image-1586940839052.png)
5.修改配置文件
`vim /usr/local/zabbix/etc/zabbix_agentd.conf`
```python
#加载其它配置
Include=/usr/local/zabbix/etc/zabbix_agentd.conf.d/*.conf
#开启允许自定义 Key
UnsafeUserParameters=1
```
复制配置文件到加载目录
`cp /var/lib/zabbix/percona/templates/userparameter_percona_mysql.conf /usr/local/zabbix/etc/zabbix_agentd.conf.d/`
重启zabbix客户端
` /etc/init.d/zabbix_agentd restart`
6.下载模板,自带的模板只支持zabbix-2版本,当前支持3
`wget http://jaminzhang.github.io/soft-conf/Zabbix/zbx_percona_mysql_template.xml`
导出模板,需要lrzsz安装包
`sz zbx_percona_mysql_template.xml`
## 三.图形配置
1.导入模板
![file](http://linkdevops.oss-cn-beijing.aliyuncs.com/wp-content/uploads/2020/04/image-1586940890947.png)
将刚刚下载的xml模板文件导入到服务器上
![file](http://linkdevops.oss-cn-beijing.aliyuncs.com/wp-content/uploads/2020/04/image-1586940897556.png)
点击导入,就会看见成功的字样了
![file](http://linkdevops.oss-cn-beijing.aliyuncs.com/wp-content/uploads/2020/04/image-1586940934969.png)
2.连接模板,需要点击添加后再更新
![file](http://linkdevops.oss-cn-beijing.aliyuncs.com/wp-content/uploads/2020/04/image-1586940946008.png)
3.查看数据,检测中-图形-选择主机-监控项
![file](http://linkdevops.oss-cn-beijing.aliyuncs.com/wp-content/uploads/2020/04/image-1586940950724.png)