Zabbix + Mysql Fpmmm (MPM) monitoring tutorial

Mysql Fpmmm is an upgraded version of MPM. It is more convenient to use fpmmm than mpm, but the corresponding optimization parameters must be enabled.
1. Configure the pid

Copy the startup script

Cp support-files/mysql. server/etc/init. d/mysqld
Chkconfig -- add mysqld
Service mysqld start
Pid-file =/var/run/mysqld. pid
Configure environment variables

Vim/etc/profile. d/mysql. sh
Export PATH =/usr/local/mysql/bin: $ PATH
Sh vim/etc/profile. d/mysql. sh
Add the pid in the configuration file

[Root @ localhost mysql] # vim/etc/mysql/my. cnf
Pid-file =/var/run/mysqld. pid
[Root @ localhost mysql] # mkdir/var/run/mysqld
[Root @ localhost mysql] # chown-R mysql. mysql/var/run/mysqld
[Root @ localhost mysql] #/etc/init. d/mysqld start
2. Install zabbx-agnet

Rpm-ivh http://repo.zabbix.com/zabbix/2.4/rhel/6/x86_64/zabbix-release-2.4-1.el6.noarch.rpm
Yum install-y zabbix-agent-2.4.7 zabbix-sender-2.4.7 zabbix-2.4.7 agent-2.4.7
Vim/etc/zabbix/zabbix_server.conf
Server = 192.168.128.128
ErverActive = 192.168.128.128
Hostname = Zabbix server
3. fpmmm monitoring

Yum install php-cli php-process php-mysqli
Cat <_ EOF>/etc/php. d/fpmmm. ini
Variables_order = "EGPCS"
Date. timezone = 'Europe/Zurich'
_ EOF
Download fpmmm

Wget-P/usr/local/https://support.fromdual.com/admin/download/fpmmm-0.10.5.tar.gz
Cd/usr/local
Tar xf fpmmm-0.10.5.tar.gz
Ln-s fpmmm-0.10.5 fpmmm
Cd fpmmm
Mkdir/etc/fpmmm
Cp/usr/local/fpmmm/tpl/fpmmm. conf. template/etc/fpmmm. conf
Chown-R zabbix:/etc/fpmmm
Authorize fpmmm,

Vim/etc/profile. d/mysql. sh
Export PATH =/usr/local/mysql/bin: $ PATH
Sh vim/etc/profile. d/mysql. sh
Mysql-e "grant all on *. * TO 'fpmmm' @ '192. 168.158.130 'identified BY 'password ';""
Mysql-e "grant all on *. * TO 'fpmmm' @ '2017. 0.0.1 'identified BY 'password ';"
Add zabbix users to mysql

Usermod-G mysql zabbix
Modify the fpmm configuration file

[Root @ localhost fpmmm] # egrep-v "^ # | ^ $"/etc/fpmmm. conf
[Default]
Type = mysqld
LogLevel = 2
LogFile =/tmp/fpmmm. log
CacheFileBase =/tmp/fpmmm/fpmmmCache
AgentLockFile =/tmp/fpmmm. lock
Username = fpmmm
Password = password
MysqlHost = 127.0.0.1
MysqlPort = 3306
ZabbixServer = 192.168.158.128
Disabled = false
Modules = innodb master myisam mysql process security
PidFile =/var/lib/mysql/mysqld. pid
[Mysql-master] # This MUST match Hostname in Zabbix!
Type = mysqld
Modules = fpmmm server
[Mysql-master] # This MUST match Hostname in Zabbix!
Type = mysqld
MysqlPort = 3306
Modules = process mysql myisam innodb master slave security
PidFile =/var/run/mysqld. pid
Test

[Root @ localhost fpmmm] #/usr/local/fpmmm/bin/fpmmm -- config =/etc/fpmmm. conf
1
Add mysql. check

Vim/etc/zabbix/zabbix_agentd.conf
UserParameter = FromDual. MySQL. check,/usr/lcaol/fpmmm/bin/fpmmm -- config =/etc/fpmmm. conf
Scheduled Tasks

[Root @ localhost fpmmm] # crontab-l
* ***/Usr/local/fpmmm/bin/fpmmm -- config =/etc/fpmmm. conf>/dev/null
Observe logs

96402: 12:09:02. 338-WARN: Instance db2 seems not to be a Slave. (rc = 1577 ).
96402: 12:09:02. 373-INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) run finished (rc = 0 ).
96608: 12:10:01. 438-INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) (0.10.5) run started.
96608: 12:10:02. 616-WARN: Instance db2 seems not to be a Slave. (rc = 1577 ).
96608: 12:10:02. 649-INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) run finished (rc = 0 ).
96808: 12:11:01. 678-INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) (0.10.5) run started.
96808: 12:11:02. 823-WARN: Instance db2 seems not to be a Slave. (rc = 1577 ).
96808: 12:11:02. 866-INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) run finished (rc = 0 ).
97010: 12:12:01. 891-INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) (0.10.5) run started.
97010: 12:12:03. 048-WARN: Instance db2 seems not to be a Slave. (rc = 1577 ).
97010: 2016-05-12:12:03. 081-INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) run finished (rc = 0 ).
97210: 12:13:01. 137-INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) (0.10.5) run started.
97210: 12:13:02. 322-WARN: Instance db2 seems not to be a Slave. (rc = 1577 ).
97210: 12:13:02. 355-INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) run finished (rc = 0 ).
97411: 12:14:01. 380-INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) (0.10.5) run started.
97411: 12:14:02. 534-WARN: Instance db2 seems not to be a Slave. (rc = 1577 ).
97411: 12:14:02. 569-INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) run finished (rc = 0 ).
97611: 12:15:01. 607-INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) (0.10.5) run started.
97611: 12:15:02. 765-WARN: Instance db2 seems not to be a Slave. (rc = 1577 ).
97611: 12:15:02. 799-INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) run finished (rc = 0 ).
97811: 12:16:01. 846-INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) (0.10.5) run started.
97811: 12:16:03. 003-WARN: Instance db2 seems not to be a Slave. (rc = 1577 ).
97811: 2016-05-12:16:03. 037-INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) run finished (rc = 0 ).
98011: 2016-05-12:17:01. 095-INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) (0.10.5) run started.
98011: 12:17:02. 263-WARN: Instance db2 seems not to be a Slave. (rc = 1577 ).
98011: 12:17:02. 304-INFO: FromDual Performance Monitor for MySQL and MariaDB (fpmmm) run finished (rc = 0 ).
View graph

 

 

 

Template_FromDual.MySQL.mpm.xml (monitor the mpm agent itself, which must be imported)
Template_FromDual.MySQL.server.xml (additional items related to Linux and database usage)
Template_FromDual.MySQL.process.xml (monitors various Linux processes [such as mysqld, ndbd])
Template_FromDual.MySQL.mysql.xml (monitor common MySQL status variables)
Template_FromDual.MySQL.innodb.xml (monitor InnoDB storage engine status variables)
Template_FromDual.MySQL.myisam.xml (monitor the status variable of the MyISAM storage engine)
Template_FromDual.MySQL.master.xml (monitor the Master status of MySQL Master-slave replication)
Template_FromDual.MySQL.slave.xml (monitor the Slave status of MySQL master-Slave replication)

Other MPM templates:
Template_FromDual.MySQL.ndb.xml (monitoring MySQL Cluster)
Template_FromDual.MySQL.galera.xml (monitoring MySQL Galera Cluster)
Template_FromDual.MySQL.pbxt.xml (monitor PBXT storage engine status variables)
Template_FromDual.MySQL.aria.xml (monitor the status variables of the Aria storage engine)
Template_FromDual.MySQL.drbd.xml (monitor the status of a DRBD device)