percona模版监控mysql

1. 安装

1.1 php安装

yum install php php-mysql -y

1.2 软件下载

https://www.percona.com/software/mysql-database/percona-server

[root@m01 ~]# cd /data/soft/
[root@m01 /data/soft]# wget https://www.percona.com/downloads/percona-monitoring-plugins/percona-monitoring-plugins-1.1.8/binary/redhat/7/x86_64/percona-zabbix-templates-1.1.8-1.noarch.rpm
[root@m01 /data/soft]# rpm -ivh percona-zabbix-templates-1.1.8-1.noarch.rpm 
警告：percona-zabbix-templates-1.1.8-1.noarch.rpm: 头V4 DSA/SHA1 Signature, 密钥 ID cd2efd2a: NOKEY
准备中...                          ################################# [100%]
正在升级/安装...
   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

安装：

yum localinstall -y percona-zabbix-templates-1.1.8-1.noarch.rpm 

cd /var/lib/zabbix/percona

[root@zabbix percona]# tree
.
├── scripts
│   ├── get_mysql_stats_wrapper.sh
│   └── ss_get_mysql_stats.php
└── templates
    ├── userparameter_percona_mysql.conf
    └── zabbix_agent_template_percona_mysql_server_ht_2.0.9-sver1.1.8.xml

2 directories, 4 files

1.3 修改get_mysql_stats_wrapper.sh

cd /var/lib/zabbix/percona/scripts

vim get_mysql_stats_wrapper.sh

[root@m01 v]# sed -n '19p' get_mysql_stats_wrapper.sh 
RES=`HOME=~zabbix mysql -uroot -p123456 -e 'SHOW SLAVE STATUS\G' | egrep '(Slave_IO_Running|Slave_SQL_Running):' | awk -F: '{print $2}' | tr '\n' 

1.4 修改ss_get_mysql_stats.php

[root@m01 /var/lib/zabbix/percona/scripts]# sed -n '30,31p' ss_get_mysql_stats.php 
$mysql_user = 'root';
$mysql_pass = '123456';

1.5 复制自定义监控项配置文件到zabbix目录

cd /var/lib/zabbix/percona/templates/
cp userparameter_percona_mysql.conf /etc/zabbix/zabbix_agentd.d/
cd /etc/zabbix/zabbix_agentd.d/
ls

重启：

systemctl restart zabbix-agent

zabbix_get -s 127.0.0.1  -k MySQL.Sort-scan

2. zabbix-web导入模板

wget http://jaminzhang.github.io/soft-conf/Zabbix/zbx_percona_mysql_template.xml

2.1 主机连接模板

应用即可