Fpmmm (MPM) Monitoring MySQL module installation

Zabbix MPM monitoring MySQL is a pretty good monitoring module, but recently the official website has not called MPM, but called fpmmm, for the reasons:

Fpmmm is the successor of MPM. MPM is renamed to Fpmmm because of the naming conflict with the Apache multi-processing Modules (MPM).

Start the installation below:

First step: Download the Fpmmm module:

Http://www.fromdual.com/download-performance-monitor

Click Get the Latest release.

Select the appropriate version, and then you will be asked to fill in some information, download the link it will be sent by email to you.

Step Two: Install Fpmmm

The following is an example of CENTOS6:

Yum install php-cli php-process php-mysqli php-memcached php-posix

Cat << _eof >/etc/php.d/fpmmm.inivariables_order = "Egpcs" _eof

The official website has the time which sets up in Europe, does not need, in the/etc/php.ini set to the Chinese time zone is good. TAR-ZXVF fpmmm-0.10.5.tar.gz-c/USR/LOCAL/ZABBIX/CD/USR/LOCAL/ZABBIX/MV fpmmm-0.10.5 fpmmmcd/usr/local/zabbix/ FPMMM/TPLCP fpmmm.conf.template fpmmm.confchown-r Zabbix.      /usr/local/zabbix The third step: Modify the parameters fpmmm.conf, mainly modify the following parameters: # information for MySQL connections:username = User_fpmmmpassword = 123456MysqlHost = 127.0.0.1MysqlPort = 3307 # Zabbix Server IP addresszabbixserver = 192.168.1.240# Here you could add a random name of your mysql/mariadb instance[ gl.mysql.3307] # This must match Hostname in zabbix!  Type = Mysqldmysqlport = 3307Modules = Process MySQL MyISAM innodb master slave securitypidfile = /home/mysql/i3307/mysql.pid

Fourth step: Create a monitored MySQL user

CREATE USER ' user_fpmmm ' @ ' 127.0.0.1 ' identified by ' 123456 '; GRANT PROCESS on * * to ' user_fpmmm ' @ ' 127.0.0.1 '; GRANT REPLICATION CLIENT on * * to ' user_fpmmm ' @ ' 127.0.0.1 '; GRANT REPLICATION SLAVE on * * to ' user_fpmmm ' @ ' 127.0.0.1 '; #这一条官网没有, but no words will remind you of the need in log, mainly for show slave hostsGRANT SELECT on Mysql.user to ' user_fpmmm ' @ ' 127.0.0.1 '; flush privileges;

Fourth step: Test Validation:

[Email protected] zabbix]#/usr/local/zabbix/fpmmm/bin/fpmmm--config=/usr/local/zabbix/fpmmm/tpl/fpmmm.conf
1
Returns 1 represents hope, but does not mean success, but also depends on fpmmm log

Cat/tmp/fpmmm/fpmmm.log

If there is nothing unusual with the log file, that means success.

Ps:

Official website Detailed installation process: Http://www.fromdual.com/fpmmm-installation-guide

Fpmmm (MPM) Monitoring MySQL module installation