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.