Zabbix監控MySQL5.7配置

測試版本如下：

centos 7.6

mysql版本5.7

zabbix版本4.4.8

zabbix家目錄為/usr/local/zabbix

添加mysql模闆配置檔案/usr/local/zabbix/etc/template_db_mysql.conf

UserParameter=mysql.ping,HOME=/usr/local/zabbix  mysqladmin -h"$1" -P"$2" ping

UserParameter=mysql.get_status_variables[*],HOME=/usr/local/zabbix mysql -h"$1" -P"$2" -sNX -e "show global status"

UserParameter=mysql.version[*],HOME=/usr/local/zabbix mysqladmin -s -h"$1" -P"$2" version

UserParameter=mysql.db.discovery[*],HOME=/usr/local/zabbix mysql -h"$1" -P"$2" -sN -e "show databases"

UserParameter=mysql.dbsize[*],HOME=/usr/local/zabbix mysql -h"$1" -P"$2" -sN -e "SELECT COALESCE(SUM(DATA_LENGTH + INDEX_LENGTH),0) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='$3'"

UserParameter=mysql.replication.disc