Zabbix: How to configure MySQL Monitoring on Zabbix system

Overview

The article show how to configure MySQL Monitoring on Zabbix. The system consists of Zabbix Server installed on CentOS and MySQL installed on Ubuntu Server

How to configure

Configure on Ubuntu Server (MySQL)

  • Create user monitoring to manage MySQL
  • Declare the newly created user
  • Write to the file .my.cnf content as follows
  • Check that /etc/zabbix/zabbix_agentd.conf has the following line

Include=/etc/zabbix/zabbix_agentd.d/*.conf

  • Check in /etc/zabbix/zabbix_agentd.d directory with ls command to have userparameter_mysql.conf file
  • Edit file userparameter_mysql.conf with vi with the content as below
  • Restart zabbix-agent service

systemctl restart zabbix-agent

Configure on web interface Zabbix Server

  • Create host on Zabbix Server
  • Choose template Template DB MySQL
  • Check that the MySQL monitoring service on zabbix is ​​working

1 Comment

Leave a Reply

Your email address will not be published.


*