We have an RDS custom plugin available to allow you to monitor your RDS instances via Server Density.
Installation
- Install python-boto
sudo apt-get install python-boto
- Configure the plugin in
/etc/sd-agent/plugins.cfg
- Drop the
RDS.py script
in your plugin directory, most likely/usr/local/share/sd-plugins/
. Check yourconfig.cfg
if you're unsure. - 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.
Comments