Monitor MySQL via Application
Hello,
We are attempting to setup monitors on our LTMs to monitor if the MySQL DB is active or not.
We have 4 Windows servers running an application, behind that application is our MySQL Databases. We thought we could use WMI to see if the services are up and active, but it seems the WMI monitors in the LTMs will only monitor the servers CPU/MEM/DISK Usage.
I found another article talking about using WMIC, but requires to be created on Linux Distro and then imported into the LTMs in order to monitor the services, but it seems overly complicated for the simple task of just wanting to monitor if the app and db are active.
Basically, we are just looking to setup two monitors, one for the app, which we can just use an existing TCP monitor for, and one for the DB. For the DB we need to make the call through the app and just have a small return string to match in order to say its active.
Can anyone help us out with this or point me in the right direction of what we're looking for? Even a small script?
Thanks.