Amazon RDS

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

DB Instances

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:

Monitoring board for the EC2 Instance resource dataset. Visualizations include summary of instance types, chart of how many instances are in each availability zone, how many failed status checks, and CPU utilization per instance.

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

  • Latency

  • IOPS

And also system metrics, such as:

  • CPU utilization

  • Network throughput

  • Free memory

  • 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.

RDS Clusters

Get an overview of the state of your RDS DB clusters with the RDS Cluster dataset:

Monitoring board for the EC2 Instance resource dataset. Visualizations include summary of instance types, chart of how many instances are in each availability zone, how many failed status checks, and CPU utilization per instance.

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:

For Aurora:

  • 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:

  • IOPS

Monitors

The following Monitor templates are included:

For Clusters:

  • 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.

Setup

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.