zabbix使用percona template监控MySQL数据库,可以长期监控innodb存储引擎项以及MySQL性能
MySQL version:mysql Ver 14.14 Distrib 5.6.24, for Linux (x86_64)
zabbx templates:<span style="font-family: Arial, Helvetica, sans-serif;">percona-zabbix-templates-1.1.6</span>
#!/bin/sh
SCRIPT_DIR='/var/lib/zabbix/percona/scripts'
TEMPLATE_DIR='/var/lib/zabbix/percona/templates'
for pkg in php-devel php-mysql.x86_64 wget
do
yum install $pkg -y
done
if [ ! -f "/tmp/percona-zabbix-templates-1.1.6-1.noarch.rpm" ];then
/usr/bin/wget https://www.percona.com/downloads/percona-monitoring-plugins/1.1.6/percona-zabbix-templates-1.1.6-1.noarch.rpm -P /tmp
else
echo "percona-zabbix-templates-1.1.6-1.noarch.rpm exist"
fi
rpm -ivh /tmp/percona-zabbix-templates-1.1.6-1.noarch.rpm
cp -f $TEMPLATE_DIR/userparameter_percona_mysql.conf /etc/zabbix/zabbix_agentd.d/
service zabbix-agent start
if (($?==0));then
echo "zabbix-agent restart success"
else
echo "zabbix-agent restart error"
fi