How to Monitor Databases in AWS RDS Service

The full form for AWS RDS is Relational Database Service .User’s of AWS services, when they define databases to RDS service, it’s their responsibility to monitor the service.

It is possible to monitor 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.

AWS RDS best practices

• Decide baseline of metrics
• Decide Tools you need to monitor

How to monitor AWS RDS: Tools you need

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

How to automate: Available services

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

RDS ClowdWatch 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