How to monitor MySQL process via SAM - snmp

Question

Hi,

I want to monitor whether MySQL is up and running on my Linux servers and alert if it stops / is not running.  The servers are already monitored with the snmp monitor, but this only tells us if the servers are up.  I need something like the SQL Server (via SNMP) template but for MySQL.  Is tihs possible?

I have already used the MySQL templates for monitoring database performance, but I just need something to tell me if the service is running or not ('service mysqld status' check), and I can't seem to find that.

Thanks,

Paula.

aLTeReGo · Accepted Answer

Adding a component to monitor the MySQL process itself is fairly straightforward. Simply launch the Real-Time Process Explorer from the Application or Node Details view of the server running MySQL. Next, click the "Start Monitoring" button next to the "mysqld" process you wish to monitor, then walk through the wizard to either add this component to an existing template or create a new one.