MPM (MySQL Performance Monitor) 是 Fpmmm 的前身,雖然版本較早但仍有參考價值。本文記錄基於 Perl 版 MPM Agent 的安裝、配置與 Zabbix 整合流程。
wget -c https://www.shinguz.ch/download/mysql_performance_monitor-latest.tar.gz
tar xf mysql_performance_monitor-latest.tar.gz
yum install -y perl-File-Which perl-libwww-perl perl-Digest-SHA perl-DBD-MySQL perl-Time-HiRes
tar xf mysql_performance_monitor_agent-0.9.1.tar.gz
cd mysql_performance_monitor_agent-0.9.1
mkdir -p /etc/fpmmm
cp etc/FromDualMySQLagent.conf.template /etc/fpmmm/FromDualMySQLagent.conf
vim /etc/zabbix/zabbix_agentd.conf
# 新增 UserParameter
UserParameter=mysql.mpm,/usr/local/mysql_performance_monitor_agent-0.9.1/FromDualMySQLagent.pl /etc/fpmmm/FromDualMySQLagent.conf
# 重啟 Agent
/etc/init.d/zabbix-agent restart
# 建立日誌與快取目錄
mkdir -p /var/log/zabbix /var/log/zabbix/cache
chown -R zabbix: /var/log/zabbix /var/log/zabbix/cache
# 加入 crontab 每分鐘執行
crontab -e
* * * * * /usr/local/mysql_performance_monitor_agent-0.9.1/FromDualMySQLagent.pl /etc/fpmmm/FromDualMySQLagent.conf >/dev/null
[default]
Type = mysqld
Debug = 2
LogFile = /var/log/zabbix/FromDualMySQLagent.log
CacheFileBase = /var/log/zabbix/cache/FromDualAgentCache
Username = fpmmm
Password = password
MysqlHost = 127.0.0.1
MysqlPort = 3306
ZabbixServer = 192.168.158.128
Disabled = false
Modules = process mysql myisam innodb
ClusterLog = /var/lib/mysql-cluster/ndb_1_cluster.log
PidFile = /var/lib/mysqld/mysqld.pid
[db1]
Type = mysqld
MysqlPort = 3306
Modules = process mysql myisam slave
PidFile = /var/run/mysqld/mysqld.pid
注意:[db1] 區段的名稱必須與 Zabbix 前端設定的 Hostname 完全一致。
編輯 /usr/local/mysql_performance_monitor_agent/lib/sendData.pm,註解掉 checkConnectionToZabbixServer 呼叫,避免誤判導致資料無法送出。
ls -l /var/log/zabbix/cache/
# 確保擁有者為 zabbix
chown -R zabbix:zabbix /var/log/zabbix/cache/
# 若出現 "ERR : Load of cache file failed. rc=1301"
rm -f /var/log/zabbix/cache/FromDualAgentCache.db1.cache
觀察 Agent 日誌確認資料正常收集,並匯入與 Fpmmm 相同的監控模板集合。

