Amazon Relational Database Service (Amazon RDS) provides easy to manage and scalable relational databases and database clusters in the AWS Cloud. Database instances may use one of several common database engines, such as MySQL or Microsoft SQL Server.
Observe helps you monitor the health and activity of your RDS deployments with:
Datasets containing details of RDS clusters and individual DB instances, allowing you to see which instances are part of which clusters, their engine and instance class, and other attributes.
A board with at-a-glance insights, such as the number of connections, and read/write latency.
Additional dataset for RDS deployment logs (see Setup.)
Sample Monitor configurations to alert on common problems, such as high error rates.
View RDS activity in Observe¶
To see details of your RDS DB instances, go to the “RDS Instance” dataset in Observe. The “Monitoring” board provides an overview of the state of your DB instances:
This board includes visualizations with information about your instances. Use it to answer questions like:
How many instances in each account or region?
How many instances of each DB engine type, and what versions are they running?
How many instances of each instance class?
How many instances are part of a cluster?
The Monitoring board has useful database metrics, such as:
Number of database connections
And also system metrics, such as:
Free storage space
Disk queue depth
For Aurora clusters, also:
Commit latency and throughput
For a complete list of RDS metrics collected, see Amazon RDS metrics.
Get an overview of the state of your RDS DB clusters with the RDS Cluster dataset:
The RDS Cluster Monitoring board includes all of the visualizations that the RDS Instance “Monitoring” board does, as well as additional metrics specific to different types of clusters:
Serverless database capacity (for serverless clusters)
Replica lag (for provisioned clusters with read replicas)
For MySQL on Aurora:
DML latency and throughput
Number of blocked transactions
For PostgreSQL on Aurora:
The following Monitor templates are included:
Alert if the average latency across the cluster is more than 20 miliseconds:
RDS High Cluster Read Latency
RDS High Cluster Write Latency
For DB instances:
Alert if the latency for a single instance is more than 20 miliseconds:
RDS High Instance Read Latency
RDS High Instance Write Latency
Alert if the error rate has increased by more than 10% in the past hour:
RDS Increased Error Logs
Alert if an instance has less than 10% free storage:
RDS Low Free Storage Space
To use a template, go to the list of templates on the Monitors page and select Duplicate for the one you wish to use. Make any desired configuration changes on the Create a Monitor page and save to enable it.
Contact us for assistance with installing the Observe AWS Integration, creating datasets, and customizing Monitors. For the optional RDS Logs dataset, we recommend enabling automatic subscription of CloudWatch Log Groups. For details, see How do I send CloudWatch Log Groups to Observe? in the AWS Integration documentation.