How to Monitor AWS RDS Service

Here are the necessary tools and metrics to use for monitoring the AWS RDS service. The AWS RDS is also called Relational Database Service. When a user defines a database for RDS service, it’s their responsibility to monitor the service.

The metrics you can monitor are network throughput; I/O for reading, writing, and/or metadata operations; client connections; and burst-credit balances for DB instances. Here are the available RDS instance types.

IN THIS PAGE

  1. Amazon RDS monitoring tools and metrics
  2. AWS RDS metrics

Amazon RDS monitoring tools and metrics

Tools

  1. CloudWatch
  2. AWS management console
  3. RDS console

Amazon RDS sends metrics to Amazon CloudWatch for each active database instance every minute.

Standard Metrics

  • Disc space consumption
  • High CPU/RAM consumption
  • Network traffic
  • Database connections
  • IOPS metrics

Log services

  1. CloudWatch Alarm
  2. CloudWatch Logs
  3. RDS console
  4. CloudWatch Events
  5. RDS Events
  6. CloudTrail Logs
  7. Database Log files

AWS RDS metrics

  • BinLogDiskUsage: Amount of disk space occupied by binary logs on the primary database. Applies to MySQL Read Replicas and is measured in bytes
  • CPUUtilization: Percentage of CPU utilization
  • DatabaseConnections: Number of database connections in use
  • DiskQueueDepth: The number of outstanding read and write requests waiting to access the disk
  • FreeStorageSpace: Amount of available storage space
  • FreeableMemory: Amount of available RAM
  • NetworkReceiveThroughput: Inbound network traffic on the DB instance that includes both customer database traffic and Amazon RDS traffic used for monitoring and replication
  • NetworkTransmitThroughput: Outbound network traffic on the DB instance that includes both customer database traffic and Amazon RDS traffic used for monitoring and replication
  • ReadIOPS: Average number of disk I/O operations per second
  • ReadLatency: Average amount of time taken per disk I/O operation
  • ReadThroughput: Average number of bytes read from disk per second
  • ReplicaLag: Amount of time a Read Replica DB instance lags behind the source DB instance. Applies to MySQL, MariaDB, and PostgreSQL Read Replicas
  • SwapUsage: Amount of swap space used on the DB instance
  • WriteIOPS: Average number of disk I/O operations per second
  • WriteLatency: Average amount of time taken per disk I/O operation
  • WriteThroughput: Average number of bytes written to disk per second

Related posts

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.