zabbix使用percona监控插件监控mysql

怼烎@ 2022-03-20 05:54 314阅读 0赞

参考官网链接https://www.percona.com/doc/percona-monitoring-plugins/1.1/zabbix/index.html  
**一、软件安装(在agent上操作)**  
1）percona依赖php和php-mysql

yum -y install php php-mysql

2）安装percona的yum源

yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm

3）安装percona-zabbix-templates

yum -y install percona-zabbix-templates

**二、查看配置文件和模板的安装位置(在agent上操作)**

[root@localhost ~]# rpm -ql percona-zabbix-templates
    /var/lib/zabbix/percona
    /var/lib/zabbix/percona/scripts
    /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh
    /var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php
    /var/lib/zabbix/percona/templates
    /var/lib/zabbix/percona/templates/userparameter_percona_mysql.conf
    /var/lib/zabbix/percona/templates/zabbix_agent_template_percona_mysql_server_ht_2.0.9-sver1.1.8.xml

**三、导入模板**  
percona已经帮我们生成好了一个模板，位置在/var/lib/zabbix/percona/templates/zabbix\_agent\_template\_percona\_mysql\_server\_ht\_2.0.9-sver1.1.8.xml  
但是这个模板导入的时候会报两个错：  
Invalid tag “/zabbix\_export/date”:“YYYY-MM-DDThh:mm:ssZ” is expected.  
Invalid tag “/zabbix\_export/templates/template(1)/items/item(1)”: the tag “snmp\_community” is missing.  
所以我们重新导入一个模板zbx\_mysql\_export\_templates.xml，下载地址为https://github.com/wangchaoforever/peizhiwenjian/blob/master/zabbix/zbx\_mysql\_export\_templates.xml

**四、拷贝配置文件(在agent上操作)**

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

**五、创建.cnf配置文件(在agent上操作)**  
cd /var/lib/zabbix/percona/scripts  
vim ss\_get\_mysql\_stats.php.cnf

<?php
    $mysql_user = 'root';
    $mysql_pass = '123456';

注意：线上环境最好创建一个用于监控的用户

**六、修改ss\_get\_mysql\_stats.php中的数据库连接信息(在agent上操作)**  
vim /var/lib/zabbix/percona/scripts/ss\_get\_mysql\_stats.php

$mysql_user = 'root';
    $mysql_pass = '123456';
    $mysql_port = 3306;
    $mysql_socket = NULL;
    $mysql_flags = 0;

**七、重启zabbix-agent(在agent上操作)**

systemctl restart zabbix-agent.service

**八、进行测试会返回结果(在agent上操作)**

cd /var/lib/zabbix/percona/scripts/
    
    ./get_mysql_stats_wrapper.sh gm      
    0
    
    ./get_mysql_stats_wrapper.sh gw
    85892

**九、修改文件权限(在agent上操作)**  
由于进行了测试，/tmp下生成的localhost-mysql\_cacti\_stats.txt文件的属主是root的，需要改成zabbix