本文主要介绍zabbix监控mysql的配置,包含使用zabbix自带模板监控mysql相关信息及自定义key监控mysql同步情况。同时介绍了触发器的创建及zabbix通过邮件方式告警配置。
一、配置自带模板监控mysql
1.提供配置文件模板
文件位置在源码包/usr/local/src/zabbix-3.0.4/conf/zabbix_agentd/userparameter_mysql.conf#cp/usr/local/src/zabbix-3.0.4/conf/zabbix_agentd/userparameter_mysql.conf /usr/local/zabbix/etc/zabbix_agentd.conf.d
2.修改模板文件#sed -i 's@/var/lib/zabbix@/usr/local/zabbix/etc@g' /usr/local/zabbix/etc/zabbix_agentd.conf.d/userparameter_mysql.conf
修改后的文件
UserParameter=mysql.status[*],echo
"show global status where Variable_name='$1';" |
HOME=/usr/local/zabbix/etc /usr/local/mysql/bin/mysql -N | awk '{print $$2}'
UserParameter=mysql.size[*],bash
-c 'echo "select sum($(case "$3" in both|"") echo
"data_length+index_length";; data|index) echo "$3_length";;
free) echo "data_free";; esac)) from information_schema.tables$([[
"$1" = "all" || ! "$1" ]] || echo " where
table_schema=\"$1\"")$([[ "$2" = "all" || !
"$2" ]] || echo "and table_name=\"$2\"");" |
HOME=/usr/local/zabbix/etc /usr/local/mysql/bin/mysql -N'
UserParameter=mysql.ping,HOME=/usr/local/zabbix/etc
/usr/local/mysql/bin/mysqladmin ping | grep -c alive
UserParameter=mysql.version,/usr/local/mysql/bin/mysql
-V