Its important to monitor your Database. Be it availability, DB size etc. We can monitor mysql Database in various Monitoring tools. Here in this article we’ll see how to do it in Zabbix.
1. Create monitoring User.
mysql create user ‘zabbix’@’localhost’ IDENTIFIED BY ‘Password’;
Query OK, 0 rows affected (0.00 sec)
mysql GRANT USAGE ON *.* TO ‘zabbix’@’localhost’ IDENTIFIED BY ‘Password’;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql quit