In this article, we are going to monitor Mysql Server with most popular monitoring tool called Nagios Monitoring.
I hope you already install Nagios server and NRPE Service if not or you are new who just started working on Nagios then refer below links which help you to clear your doubts regarding Nagios Application.
Read : How to install and configure Nagios Monitoring Server?
Read : How to add remote host on nagios server for monitoring?
Default Nagios plugins installation only provide you some plugins which help us to monitor default services and application on the server. In such case, we need to install custom plugins which help us to monitor particular services and applications on Server.
When we face any issue related to our MySql server we only come to know about this issue when our client informs us 🙂 or when we realized our website is down and after that, we go on server start checking for an issue. After wasting so much time on finding an issue we understand our MySql server causing the issue.
But when we have already monitoring tool which informed us before any critical things happen on the server and then we simply go on a server and fixed the issue without wasting any time. That’s the beauty of any monitoring tool.
This article helps you in how to configure Nagios to monitor your Mysql servers.
Below are the parameters we are going to monitor on Mysql :
Installation and Configuration Of Mysql Custom Plugins
Step 1 : Install Dependencies
Before start installing MySQL plugins we need to install some plugin dependency on the server.
Below are some mysql plugin dependencies :