percona+mysql插件_使用percona mysql插件来监控mysql5.7

1、安装 php

yum install -y php php-mysql

2、安装 percona-zabbix

yum install -y https://www.percona.com/downloads/percona-monitoring-plugins/percona-monitoring-plugins-1.1.7/binary/redhat/7/x86_64/percona-zabbix-templates-1.1.7-2.noarch.rpm

3、配置 zabbix agentd

vim /usr/local/zabbix/etc/zabbix_agentd.conf

Include=/usr/local/zabbix/etc/zabbix_agentd.conf.d/*.conf

cd /var/lib/zabbix/percona/templates

cp userparameter_percona_mysql.conf /usr/local/zabbix/etc/zabbix_agentd.conf.d/

killall -9 zabbix_agentd

/usr/local/zabbix/sbin/zabbix_agentd

4、配置 MySQL 默认登陆账号

su - zabbix

cat .my.cnf

[client]

password=MySQL2018

user=root

5、修改 php 脚本

cd /var/lib/zabbix/percona/scripts/

vim ss_get_mysql_stats.php

$mysql_user = 'root';

$mysql_pass = 'MySQL2018';

$mysql_port = 3306;

$mysql_socket = '/tmp/mysql.sock';

6、测试获取 MySQL 数据

cd /var/lib/zabbix/percona/scripts/

/usr/bin/php ss_get_mysql_stats.php --host localhost --items gg

chown zabbix.zabbix /tmp/localhost-mysql_cacti_stats.txt

cd /usr/local/zabbix/bin

./zabbix_get -s 172.16.2.39 -k MySQL.file-reads