Monitoring Amazon RDS

We have an RDS custom plugin available to allow you to monitor your RDS instances via Server Density.

Installation

1. Install python-boto sudo apt-get install python-boto
2. Configure the plugin in /etc/sd-agent/plugins.cfg
3. Drop the RDS.py script in your plugin directory, most likely /usr/local/share/sd-plugins/. Check your config.cfg if you're unsure.
4. Restart the agent to apply changes sudo service sd-agent restart

Collected Metrics

 

total_diskUsage

database_connections

used_memory

free_storage_space

network_transmit_throughput

write_latency

read_latency

cpu_utiulzation

maximum_used_transaction_ids

read_iops

write_throughput

oldest_repulcation_slot

network_received_throughput

write_iops

disk_queue_depth

transaction_logs_disk_usage

transaction_logs_generation

used_diskusage

total_memory

read_throughput

swap_usage

Troubleshooting

You can run the script directly from the command line to collect the metrics:

 $ python RDS.py -k YOUR_ACCESS_KEY -p YOUR_SECRET -e YOUR_ENDPOINT

Database Metrics

Every minute the RDS plugin pulls the 2 minute average for each configured RDS instance from Cloudwatch and posts that to Server Density. The reason it pulls a 2 minute average rather than a 1 minute average is that when pulling a 1 minute average CPU utilization is not available. As these metrics do not expose how your database is performing you may also wish to configure a plugin for your chosen database software, so that you can see those metrics too.