Database servers are an important component in business critical applications.When the business grows the critical applications should be able to scale more. MySQL replication feature gives the ability for the applications to scale a lot when MySQL is used in the backend.Also it acts as hot spare when there is a crash in the master server.
ManageEngine Applications Manager MySQL monitor helps you to monitor the availability and health of the MySQL servers.Recently we have added support for monitoring the replication status in mysql servers.
Monitored parameters:
Slave Staus – Checks whether the Slave is running or not.
Slave I\O Status – Checks whether the Slave I\O threads are running or not.
Slave SQL threads – Checks whether the Slave SQL threads are running or not.
Time behind the master – This indicates of “how” late the slave is behind the master.
Last Error – The last error occurred when Slave is synching the data from master.
You can configure notifications for the above monitored parameters.For example you can configure email notification when the Slave SQL threads are not running or the Slave is behind the Master above the configured time.
Thanks,
Arunkumar
Where will the monitor be installed ?
In Replication Server or Master Server or as a Client.
Will Client require ‘root’ user access of MySQL Server.