percona-zabbix-templates外掛程式安裝監控MySQL

標籤：

1.在zabbix用戶端安裝mysql監控外掛程式rpm包

rpm -ivh https://www.percona.com/downloads/percona-monitoring-plugins/1.1.6/percona-zabbix-templates-1.1.6-1.noarch.rpm
cd /var/lib/zabbix/percona/templates
cp userparameter_percona_mysql.conf /usr/local/zabbix/etc/zabbix_agentd.conf.d/　　#(具體路徑根據實際情況而定)

在zabbix監控頁面中匯入此模板檔案　　zabbix_agent_template_percona_mysql_server_ht_2.0.9-sver1.1.6.xml

2.編輯設定檔/usr/local/zabbix/etc/zabbix_agentd.conf

Include=/usr/local/zabbix/etc/zabbix_agentd.conf.d/

3.修改MySQL的執行命令檔案 /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh

RES=`HOME=~zabbix /usr/bin/mysql -uUSER -pPASS -e ‘SHOW SLAVE STATUS\G‘ | egrep ‘(Slave_IO_Running|Slave_SQL_Running):‘ | awk -F: ‘{print $2}‘ | tr ‘\n‘ ‘,‘`

 修改 /var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php檔案，換成自己MySQL的使用者名稱和密碼

$mysql_user = ‘USER‘;$mysql_pass = ‘PASS‘;

4.在zabbix監控頁面中添加MySQL監控，並選擇Percona MySQL Server Template模板

 

percona-zabbix-templates外掛程式安裝監控MySQL