zabbix监控mysql

目录

• 创建监控用户
• 修改zabbix_agent2.conf
• 验证结果
• 修改zabbix模板
• 主机绑定模板
• 查看监控数据图

 

---

回到顶部

创建监控用户

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

回到顶部

修改zabbix模板

回到顶部

主机绑定模板

回到顶部

查看监控数据图