Percona Amazon RDS Monitoring Template for Cacti

This page gives installation instructions specific to the RDS graph template, shows examples of graphs in the RDS template collection, and shows what they do.

Installation Notes

This template utilizes the Python script and boto module (Python interface to Amazon Web Services) to get various RDS metrics from CloudWatch.

To make the script working, please follow the instructions:

The script ~cacti/scripts/ss_get_rds_stats.py that is run under cacti user should have permissions to read the config /etc/boto.cfg or ~cacti/.boto.

For example:

[root@centos6 ~]# cat /etc/boto.cfg
[Credentials]
aws_access_key_id = THISISATESTKEY
aws_secret_access_key = thisisatestawssecretaccesskey

If you do not use this config with other tools such as our Nagios plugin, you can secure this file the following way:

[root@centos6 ~]# chown cacti /etc/boto.cfg
[root@centos6 ~]# chmod 600 /etc/boto.cfg

IMPORTANT: If you decide to create ~cacti/.boto instead, which is not secure as it falls under the web directory, ensure this file is not accessible from Web. Check out Hardening Cacti setup guide.

Test the script assuming DB instance identifier is blackbox:

[root@centos6 ~]# sudo -u cacti ~cacti/scripts/ss_get_rds_stats.py --ident=blackbox --metric=CPUUtilization
gh:6.53

To check RDS details you can run:

[root@centos6 ~]# sudo -u cacti ~cacti/scripts/ss_get_rds_stats.py --ident=blackbox --print
...

Now, you can add a device to the Cacti using Amazon RDS Server template and graph it.

NOTE: you need to specify DB instance identifier as Hostname on adding device page.

Sample Graphs

The following sample graphs demonstrate how the data is presented.

../_images/rds_binlog_disk_usage.png

The amount of disk space occupied by binary logs on the master.

../_images/rds_cpu_utilization.png

The percentage of CPU utilization.

../_images/rds_database_connections.png

The number of database connections in use.

../_images/rds_disk_iops.png

The average number of disk I/O operations per second.

../_images/rds_disk_latency.png

The average amount of time taken per disk I/O operation.

../_images/rds_disk_queue_depth.png

The number of outstanding IOs (read/write requests) waiting to access the disk.

../_images/rds_disk_throughput.png

The average number of bytes read from/written to disk per second.

../_images/rds_memory.png

The amount of used random access memory. The total available memory is the value according to the instance class. See http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.DBInstanceClass.html

../_images/rds_replica_lag.png

The amount of time a Read Replica DB Instance lags behind the source DB Instance.

../_images/rds_storage_space.png

The amount of used storage space.

../_images/rds_swap_usage.png

The amount of swap space used on the DB Instance.

© Copyright 2012, Percona Inc.
Except where otherwise noted, this documentation is licensed under the following license:
CC Attribution-ShareAlike 2.0 Generic
This documentation is developed in Launchpad as part of the Percona Monitoring Plugins source code.
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.