Home >Database >Mysql Tutorial >mysql监控工具:zabbix+MPM(PerformanceMonitorforMySQL)_MySQL

mysql监控工具:zabbix+MPM(PerformanceMonitorforMySQL)_MySQL

WBOY
WBOYOriginal
2016-06-01 13:01:161275browse

MPM主要用于监控mysql的各种参数性能指标,下面简单说一下他与zabbix的配置:

下面是它的配置文件关系图

\

主要包含两部分:

1、zabbix 模板:Template_FromDual.MySQL.*.xml

2、MPM agent perl 模块:FromDualMySQL*.pm

安装方法:

一、先安装MPM

下面是在linux 6.4下安装,先安装如下包:

yum install perl-File-Which perl-libwww-perl perl-Digest-SHA perl-DBD-MySQL perl-Time-HiRes \
perl-Crypt-SSLeay

解压缩下载的包:

tar xf mysql_performance_monitor-latest.tar.gz
tar xf mysql_performance_monitor_templates-latest.tar.gz

其中mysql_performance_monitor_templates-latest.tar.gz里面的内容,根据需要导入到zabbix server模板中,mysql_performance_monitor-latest.tar.gz解压后,放在zabbix的客户端中。

二、配置zabbix client

1、在客户端中解压相关脚本,并配置zabbix_agentd.conf文件,加入如下内容:

UserParameter=FromDual.MySQL.check,/opt/mysql_performance_monitor_agent/FromDualMySQLagent.pl /etc/zabbix/FromDualMySQLagent.conf

2、cp FromDualMySQLagent.conf.template /etc/zabbix/FromDualMySQLagent.conf

并修改相关内容:

[default]

Type = mysqld
LogFile = /var/log/zabbix/FromDualMySQLagent.log
Username = root
Password = <secret>
MysqlHost = 127.0.0.1
MysqlPort = 3306
ZabbixServer = localhost
Modules = process mysql myisam innodb


[<db_server>]

Type = mysqld
Modules = mpm server

[mysql1] ####这个名字必须与zabbix server增加的主机名保持一致。

Type = mysqld
Modules = process mysql myisam innodb
PidFile = /mysql/data/mysql.pid #mysql server pid



下面是监控用户在mysql数据库所需要的权限:
CREATE USER 'mpm'@'127.0.0.1' IDENTIFIED BY 'mpmsecret';
GRANT PROCESS ON *.* TO 'mpm'@'127.0.0.1';
GRANT REPLICATION CLIENT ON *.* TO 'mpm'@'127.0.0.1';

 

3、创建相关目录与文件,并加权限

mkdir -p /var/log/zabbix /var/log/zabbix/cache
chown -R zabbix: /var/log/zabbix /var/log/zabbix/cache

4、修改zabbix_send的在FromDualMySQLagent.pl脚本中的路径

FromDualMySQLagent.pl中zabbix_sender的路径。sed -i 's|/usr/local/bin|/usr/local/zabbix/bin/|g' FromDualMySQLagent.pl

5、启动agentd,service zabbix_agentd start

三、在zabbix服务端配置

1、导入相关的模板,其中Template_FromDual.MySQL.mpm.xml是必导的,其它可根据自己的需要再导入;

2、新增主机,并link到MPM模板上即可。

注意主机名必须与被监控的客户端主机名保持一致。

测试验证:

/usr/local/zabbixt/mpm/FromDualMySQLagent.pl /etc/zabbix/FromDualMySQLagent.conf
返回值为1:表示MPM插件正常,重启zabbix_agent,加载mpm插件

也可以放在crontab中定时进行监控

* * * * * /usr/local/zabbixt/mpm/FromDualMySQLagent.pl /etc/zabbix/FromDualMySQLagent.conf 1>/dev/null 2>&1

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn