Percona監控MySQL資料庫

配置zabbix-agent

• 安裝percona插件

yum -y install http://www.percona.com/downloads/percona-release/redhat/0.1-6/percona-release-0.1-6.noarch.rpm
yum -y install php php-mysql percona-zabbix-templates           

• 拷貝配置檔案并重新開機zabbix-agent

cp /var/lib/zabbix/percona/templates/userparameter_percona_mysql.conf /etc/zabbix_agentd.conf.d/userparameter_percona_mysql.conf
systemctl restart zabbix-agent           

• 檢視percona相關目錄

rpm -ql percona-zabbix-templates
/var/lib/zabbix/percona
/var/lib/zabbix/percona/scripts
/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh   # 腳本調用PHP
/var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php       # PHP采集資料
/var/lib/zabbix/percona/templates
/var/lib/zabbix/percona/templates/userparameter_percona_mysql.conf
/var/lib/zabbix/percona/templates/zabbix_agent_template_percona_mysql_server_ht_2.0.9-sver1.1.8.xml   # 模闆檔案，3.x導入會報錯           

導入修改過的模闆檔案

配置MySQL連接配接

• 配置php連接配接資料庫

mysql> GRANT USAGE, PROCESS, REPLICATION CLIENT ON *.* TO 'zabbix'@'localhost' IDENTIFIED BY "zabbix00";
vim /var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php.cnf
<?php
$mysql_user = 'zabbix';
$mysql_pass = 'zabbix00';           

• 測試腳本

/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh gg
73           

• 配置~zabbix/.my.cnf

vim ~zabbix/.my.cnf
[client]
user=zabbix
password='zabbix00'           

sudo -u zabbix -H /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh running-slave
# 結果為1或0為正常