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. 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Monday  —  Friday.

10am  —  6pm UK.

Dedicated Support.