zabbix监控mysql

创建监控用户

CREATE USER 'zbx_monitor'@'%' IDENTIFIED BY '123456';
GRANT REPLICATION CLIENT,PROCESS,SHOW DATABASES,SHOW VIEW ON *.* TO 'zbx_monitor'@'%';
flush  privileges;

修改zabbix_agent2.conf

~# sed -i 's@# Plugins.Mysql.CallTimeout=<Global timeout>@Plugins.Mysql.CallTimeout=30@g' /etc/zabbix/zabbix_agent2.conf
~# sed -i 's@# Plugins.Mysql.Sessions.*.Uri=@Plugins.Mysql.Sessions.Prod.Uri=unix:/data/mysql/mysql.sock@g' /etc/zabbix/zabbix_agent2.conf
~# sed -i 's@# Plugins.Mysql.Sessions.*.User=@Plugins.Mysql.Sessions.Prod.User=zbx_monitor@g' /etc/zabbix/zabbix_agent2.conf
~# sed -i 's@# Plugins.Mysql.Sessions.*.Password=@Plugins.Mysql.Sessions.Prod.Password=123456@g' /etc/zabbix/zabbix_agent2.conf
~# 
~# grep Plugins.Mysql /etc/zabbix/zabbix_agent2.conf | grep -v "^#"
Plugins.Mysql.CallTimeout=30
Plugins.Mysql.Sessions.Prod.Uri=unix:/data/mysql/mysql.sock
Plugins.Mysql.Sessions.Prod.User=zbx_monitor
Plugins.Mysql.Sessions.Prod.Password=123456
~# systemctl restart zabbix-agent2

验证结果

~# /usr/local/zabbix/bin/zabbix_get -s 172.16.2.170 -p 10050 -k "mysql.db.discovery["unix:/data/mysql/mysql.sock","zbx_monitor","123456"]"
[{"Database":"information_schema"},{"Database":"mysql"},{"Database":"performance_schema"},{"Database":"sys"}]
~# /usr/local/zabbix/bin/zabbix_get -s 172.16.2.170 -p 10050 -k "mysql.ping["unix:/data/mysql/mysql.sock","zbx_monitor","123456"]"
1