RDS events monitoring

[vinayvemula]

Hi Team,

We were given a request to monitor amazon RDS monitoring.

We are able to monitor few of RDS metrics through check_cloudwatch_status-2.5.07.rb plugin

`RUBYOPT=rubygems ruby /usr/local/nagios/libexec/cloud_watch/check_cloudwatch_status-2.5.07.rb -a rdsendpoint -i rdsinstance -f /usr/local/nagios/libexec/cloud_watch/ec2_credentials.cfg -D DatabaseConnections -c 20 -S Maximum ; echo -e "Return Code: $?"`

with above we are able to receice status of RDS metrics like CPU, Storage, number of DB connections from instance level.

in every instance we have multiple DBs and would like to get the status of DBs.

But we have additional request to monitor Event level monitoing like DB availability, DB failover

Could you please help us if there is a possibility to get status at amazon Event level (DB availability)

[jbrunkow]

I see one plugin out there for monitoring Amazon RDS. You might want to take a look to see if that can monitor the things your current plugin can't.
pmp-check-aws-rds.py

Try using the -h option on a given plugin to see all the options it has to offer.

You may find that you have to use a variety of methods to monitor every aspect of this that you want to. Can you please help me understand what you mean by monitoring at "amazon event level" and "availability"? I can try to advise what solution will be best, but I can't be sure that Amazon will offer up the required level of access to their systems.

Sometimes if you can't find the exact plugin to monitor a device, a more general method like SNMP will work or a database-specific plugin. That might also be worth looking into!

[vinayvemula]

Hi,
With the RDS plugin we have currently we are able to monitor RDS metrics.
It is instance level means as a whole instance cpu, number of DB connections, free storage on whole instance etc.

But what we required is Event level monitoring.

Every instance will have number of DBs in it..
We would like to know the each individual DB availability which is event level.

Hope this make sense to get clarified on what is our requirement is all about.

[jbrunkow]

In that case you may want to try running the appropriate Configuration Wizard against each database you have through RDS. That may allow you to monitor each database individually.