AWS RDS Monitoring & Notification
RDS integrates into CloudWatch and provides metrics to monitor
CloudWatch alarms can all be created using a single metric. The SNS message is sent when the alarm’s state changes.
RDS also provides SNS notifications whenever an RDS event occurs RDS CloudWatch Monitor
CloudWatch can monitor RDS DB instances. It collects and processes raw data to create readable metrics that are near real time.
Statistics are kept for two weeks so you can view historical information and get a better understanding of the service’s performance.
CloudWatch automatically receives RDS metric data in 1-minute intervals by default
CloudWatch RDS MetricsBinLogDiskUsage – Amount of disk space occupied by binary logs on the master. This applies to MySQL read replicas.
CPUUtilization: Percentage of CPU usage
DatabaseConnections – Number of databases connected to the system.
DiskQueueDepth – The number of outstanding IOs waiting to be accessed the disk.
FreeableMemory is a measure of the amount of random access memory that is available.
FreeStorageSpace – The amount of storage space that is available.
ReplicaLag – The amount of time a Read Replica DB instance takes to catch up to the source DB instance.
SwapUsage – The amount of swap space used by the DB instance.
ReadIOPS – Average number disk I/O operations per second
WriteIOPS – Average number of disk I/O operations per minute
ReadLatency – Average time taken for each disk I/O operation.
WriteLatency – Average time it takes to perform a disk I/O operation.
ReadThroughput – Average number per second of bytes downloaded from the disk.
WriteThroughput – Average number of bytes written per second to the disk
NetworkReceiveThroughput – Incoming (Receive) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication.
NetworkTransmitThroughput – Outgoing (Transmit) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication.RDS Enhanced Monitoring
RDS provides metrics in real-time for the operating system (OS), on which the DB instance runs.
CloudWatch vs Enhanced monitoring Metrics
CloudWatch collects CPU utilization metrics from a hypervisor for a DB instances, while Enhanced Monitoring gathers them from an agent on the instance.
Enhanced Monitoring metrics can be used to analyze how different threads or processes use the CPU in a DB instance.
Because the hypervisor layer does a small amount, there might be some differences in the measurements. The differences could be more pronounced if the DB instances have smaller instance classes. This is because there are likely to be more virtual machines (VMs), which are managed by the hypervisor layers on a single physical instance. RDS Performance Insights
Performance Insights, a database performance tuning feature that monitors and analyzes the database’s performance, is a performance monitoring and tuning feature that helps to visualize the database’s performance.
Performance Insights Dashboard allows you to visualize the database load and filter it by waits, SQL statements or hosts.
CloudTrail keeps track of all actions taken by users, roles, and AWS services in RDS.
CloudTrail records all API calls for RDS in events. This includes calls from the console as well as code calls to RDS API operations.
CloudTrail can be used to determine the request made to RDS. It will also identify the IP address from where the request was made and the person who made it.
RDS offers automated recommendations for database resource resources.
These recommendations provide best practice guidance through analyzing DB instance configuration, usage and performance data.
RDS uses the SNS for notifica