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

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

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 agentdvim/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

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

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

cd/usr/local/zabbix/bin

./zabbix_get-s172.16.2.39-kMySQL.file-reads

7, 下载模板导入到 zabbix https://www.ttlsa.com/wp-content/uploads/2016/07/Percona-MySQL-Server-Template.zip 参考文档: Download Percona Monitoring Plugins https://www.percona.com/downloads/percona-monitoring-plugins/percona-monitoring-plugins-1.1.7/ zabbix3.0.2 使用 percona mysql 插件来监控 mysql5.7 的详细实现过程 https://blog.csdn.net/mchdba/article/details/51447750 zabbix-3.0 导入 percona 模板报错 http://www.ttlsa.com/mysql/zabbix-3-0-import-percona-template-failure/

来源: http://www.bubuko.com/infodetail-2745055.html