A: 192.168.1.190, 系統CentOS 6.3,部署Zabbix Server
B: 192.168.1.191, 系統CentOS 6.3,部署Zabbix Agent, MySQL 5.5.29 (MySQL Slave)
MPM/Zabbix監控結構:
MPM/Zabbix監控MySQL的大概步驟如下:
請參考《安裝部署分布式監控系統Zabbix 2.06》 http://www.linuxidc.com/Linux/2013-07/86942.htm
MPM(PERFORMANCE MONITOR FOR MYSQL)依賴的相關Perl模塊安裝:
# yum install perl-File-Which perl-libwww-perl perl-Digest-SHA1 perl-DBD-MySQL perl-Time-HiRes perl-Crypt-SSLeay
下載MPM並解壓:
# wget -c http://www.shinguz.ch/download/mysql_performance_monitor-latest.tar.gz # tar zxvf mysql_performance_monitor-latest.tar.gz
MPM模板:
# tar zxvf mysql_performance_monitor_templates-0.9.1.tar.gz # cd mysql_performance_monitor_templates-0.9.1/xml
在Zabbix Web UI導入監控所需的模板(“Configuration”->”Templates”->”Import”):
Template_FromDual.MySQL.mpm.xml (監控mpm agent本身,這個必須導入)
Template_FromDual.MySQL.server.xml (監控Linux系統跟數據庫使用相關的附加項)
Template_FromDual.MySQL.process.xml (監控各種Linux進程[比如:mysqld,ndbd])
Template_FromDual.MySQL.mysql.xml (監控MySQL常用狀態變量)
Template_FromDual.MySQL.innodb.xml (監控InnoDB存儲引擎狀態變量)
Template_FromDual.MySQL.myisam.xml (監控MyISAM存儲引擎狀態變量)
Template_FromDual.MySQL.master.xml (監控MySQL主從復制的Master狀態)
Template_FromDual.MySQL.slave.xml (監控MySQL主從復制的Slave狀態)
MPM其它用途的模板:
Template_FromDual.MySQL.ndb.xml (監控MySQL Cluster)
Template_FromDual.MySQL.galera.xml (監控MySQL Galera Cluster)
Template_FromDual.MySQL.pbxt.xml (監控PBXT存儲引擎狀態變量)
Template_FromDual.MySQL.aria.xml (監控Aria存儲引擎的狀態變量)
Template_FromDual.MySQL.drbd.xml (監控DRBD設備狀態信息)
安裝MPM:
# tar zxvf mysql_performance_monitor_agent-0.9.1.tar.gz # mv mysql_performance_monitor_agent-0.9.1 /usr/local/mysql_performance_monitor-agent
修改FromDualMySQLagent.pl中的zabbix_sender的路徑:
# cd /usr/local/mysql_performance_monitor-agent/ # sed -i 's|/usr/local/bin|/usr/local/zabbix/bin/|g' FromDualMySQLagent.pl
將MPM Agent的Keys配置添加到Zabbix Agentd配置文件目錄中:
# cd /usr/local/zabbix/etc/zabbix_agentd.conf.d # vi FromDual_MySQL_monitoring.conf # cat FromDual_MySQL_monitoring.conf
UserParameter=FromDual.MySQL.check,/usr/local/mysql_performance_monitor-agent/FromDualMySQLagent.pl /usr/local/mysql_performance_monitor-agent/etc/FromDualMySQLagent.conf