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
- CloudWatch
- AWS management console
- 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
- CloudWatch Alarm
- CloudWatch Logs
- RDS console
- CloudWatch Events
- RDS Events
- CloudTrail Logs
- 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 bytesCPUUtilization
: Percentage of CPU utilizationDatabaseConnections
: Number of database connections in useDiskQueueDepth
: The number of outstanding read and write requests waiting to access the diskFreeStorageSpace
: Amount of available storage spaceFreeableMemory
: Amount of available RAMNetworkReceiveThroughput
: Inbound network traffic on the DB instance that includes both customer database traffic and Amazon RDS traffic used for monitoring and replicationNetworkTransmitThroughput
: Outbound network traffic on the DB instance that includes both customer database traffic and Amazon RDS traffic used for monitoring and replicationReadIOPS
: Average number of disk I/O operations per secondReadLatency
: Average amount of time taken per disk I/O operationReadThroughput
: Average number of bytes read from disk per secondReplicaLag
: Amount of time a Read Replica DB instance lags behind the source DB instance. Applies to MySQL, MariaDB, and PostgreSQL Read ReplicasSwapUsage
: Amount of swap space used on the DB instanceWriteIOPS
: Average number of disk I/O operations per secondWriteLatency
: Average amount of time taken per disk I/O operationWriteThroughput
: Average number of bytes written to disk per second
Related posts