zabbix配置mysql监控

zabbix配置mysql监控

目录

• zabbix配置mysql监控
  • 1.创建用户
  • 2.编辑zabbix配置文件
  • 3.配置宏
  • 4.添加如下监控模板

1.创建用户

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

2.编辑zabbix配置文件

vi /etc/zabbix/zabbix_agentd2.confServer=ops-zabbix-01,192.168.xx.1
ListenPort=10050systemctl stop zabbix-agent.service
systemctl disable zabbix-agent.servicesystemctl restart zabbix-agent2.service
systemctl enable zabbix-agent2.service
systemctl status zabbix-agent2.service

添加主机和ip映射

vi /etc/hosts
192.168.xx.xxx ops-zabbix-01

3.配置宏

{$MYSQL.DSN}  tcp://192.168.xx.xx:3306
{$MYSQL.USER} zbx_monitor
{$MYSQL.PASSWORD} password

4.添加如下监控模板

MySQL by Zabbix agent 2