How to use snmp to check MySQL replication or Clustering

[NagiosNewbis]

Hi;

I have two Linux server running MySQL in clustering mode, in which the primary MySQL will replicate data to the secondary host. How can I use snmp to monitor the clustering or replication between two MySQL boxes? Where should I start? The clustering or replication of these two hosts were configured by a 3rd party company, how can I collect the clustering information from these two hosts without calling them?

thx!

[abrist]

This is a tricky one. First, you will need to configure snmp on the clusters, though you may find that the default net-snmp packages do not include OIDs for mysql clusters. For this, you most likely need a specialized daemon and/or custom MIBS. I suggest some google-fu is in order.

Second, it sounds like you want to check the cluster passively. To do this, you will have to configure snmp traps. Additional reading required with this step as well.

This can be done, but it is one of the more complex/difficult type of checks to set up in nagios.