Amazon RDS Monitoring Integration
Amazon RDS
Amazon's Relational Database Service (RDS) is a managed web service that lets you deploy and scale SQL data stores in the cloud with ease. With Site24x7's RDS integration you can monitor metrics like CPU utilization, CPU credit usage, burst balance, read/write IOPS, database connections, network throughput and more for each active relational database instance. All RDS engine types are supported.
Setup and configuration
- If you have't done already, enable Site24x7 access to your AWS account (IAM user or IAM role). Learn more.
- In the Integrate AWS Account page, please select the checkbox next to the RDS listing. Learn more.
Policies and permissions
Please make sure the following read level API actions are present in the policy assigned to the Site24x7 IAM entity. Learn more.
- "rds:ListTagsForResource",
- "rds:DescribeDBInstances",
- "rds:DescribeDBLogFiles",
- "rds:DescribeAccountAttributes",
- "rds:DescribeDBClusters",
- "rds:DescribeEvents"
Polling frequency
Site24x7 queries the CloudWatch API as per the poll frequency set (1 minute to a day), to collect performance metrics for your RDS resource. Learn more.
IT Automations
You can add automations for the AWS services supported by Site24x7. Log in to Site24x7 and go to Admin > IT Automation Templates (+) > Add Automation Templates. Once automations are added, you can schedule them to be executed one after the other.
You can start, stop, and reboot with failover the DB instances with Amazon RDS automations.
Supported performance metrics
| Attribute | Description | Statistics | Data type |
|---|---|---|---|
| Bin log disk usage | Measures the amount of disk space occupied by binary logs. Applicable only for MySQL read replicas. | Average | Bytes |
| Buffer cache hit ratio | Measures the percentage of requests served by buffer cache. | Average | Percentage |
| Burst balance | Measures the percentage of available GP2 burst-bucket I/O credits. | Average | Percentage |
| CPU utilization | Measures the percentage of CPU used. | Average | Percentage |
| CPU credit usage | Measures the number of credits spent by the DB instance. | Average | Count |
| CPU credit balance | Measures the number of earned CPU credits that have been accrued. | Average | Count |
| CPU surplus credit balance | Measures the number of surplus credits that have been spent. Only applicable for T2 unlimited instance. | Average | Count |
| Database connections | Measures the number of database connections in use. | Average, sum, maximum | Count |
| Database connections real count | Measures the number of active/open connections. | Average | Count |
| CPU surplus credits charged | Measures the number of spent surplus credits that are not paid down by earned CPU credits. Only applicable for T2 unlimited instance. | Average | Count |
| Disk queue depth | Measures the number of outstanding I/O requests (read/write). | Average | Count |
| Freeable memory | Measures the amount of available RAM. | Average | Bytes |
| Free storage space | Measures the amount of available storage space. | Average | Bytes |
| Maximum used transaction IDs | The maximum transaction ID that has been used. Applicable to only PostgreSQL. | Average | Count |
| Network receive throughput | Measures the incoming (Receive) network traffic on the DB instance, includes both customer and Amazon RDS traffic. | Average | MB/sec |
| Network transmit throughput | Measures the outgoing(transmit) network traffic on the DB instance, includes both customer and Amazon RDS traffic. | Average | MB/sec |
| Oldest replication slot lag | Measures the size of the replica lagging the most in terms of WAL data received. | Average | Count |
| Read IOPS | Measures the number of disk I/O operations per second . | Average | Count/sec |
| Read latency | Measures the amount of time taken per disk I/O operation. | Average | Seconds |
| Read throughput | Measures the number of bytes read from disk per second. | Average | Bytes/sec |
| Replica lag | Measures the amount of time a Read Replica DB instance lags behind the source DB instance. | Average | Seconds |
| Swap usage | Measures the amount of swap space used. | Average | Bytes |
| Transaction logs disk usage | Measures the disk space used by transaction logs. Applicable to only PostgreSQL. | Average | MB |
| Transaction logs generation | Measures the size of transaction logs generated per second. Applicable to only PostgreSQL. | Average | Count |
| Write IOPS | Measures the average number of disk I/O operations. | Average | Count/sec |
| Write latency | Measures the average amount of time taken per disk I/O operation. | Average | Seconds |
| Write throughput | Measures the average number of bytes written to disk per second. | Average | Bytes/sec |
| EBS IO balance percentage | The percentage of I/O credits remaining in the burst bucket of your RDS database. | Average | Percentage |
| EBS byte balance percentage | The percentage of throughput credits remaining in the burst bucket of your RDS database. | Average | Percentage |
| Maximum used storage percentage | The percentage of maximum storage used out of the total allocated storage. | Average | Percentage |
Supported Amazon Aurora metrics
| Attribute | Description | Statistics | Data type |
|---|---|---|---|
| Active transactions | Measures the number of current transactions executing on an Aurora database instance. | Sum | Count |
| Aurora Binlog replica lag | Measures the amount of time a replica DB cluster running on Aurora with MySQL lags behind the source DB cluster. | Average | Milliseonds |
| Aurora replica lag | Measures the amount of lag when replicating updates. | Average | Millisecond |
| Aurora replica lag maximum | Measures the maximum amount of lag between the primary instance and each Aurora DB instance. | Average | Milliseconds |
| Aurora replica lag minimum | Measures the minimum amount of lag between the primary instance and each Aurora DB instance. | Average | Milliseconds |
| Blocked transactions | Measures the number of blocked transactions. | Sum | Count |
| Commit latency | Measures the latency for commit operations. | Average | Milliseconds |
| Commit throughput | Measures the number of commit operations per second. | Average | Count per second |
| DDL latency | Measures the latency for data definition language (DDL) requests. | Sum | Milliseconds |
| DDL throughput | Measures the number of DDL requests. | Sum | Count per second |
| Deadlocks | Measures the number of deadlocks in the database. | Sum | Count |
| Delete latency | Measures the of latency for delete queries. | Average | Milliseconds |
| Delete throughput | Measures the number of delete queries per second. | Average | Count per second |
| DML latency | Measures the amount of latency for inserts, updates, and deletes. | Average | Milliseconds |
| DML throughput | Measures the average number of inserts, updates, and deletes. | Average | Count per second |
| Engine uptime | Measures the amount of time that the instance has been running. | Average | Seconds |
| Free local storage | Measures the amount of storage available for temporary tables and logs. | Average | MB |
| Insert latency | Measures the amount of latency for insert queries. | Average | Milliseconds |
| Insert throughput | Measures the average number of insert queries. | Average | Count per second |
| Login failures | Measures the number of failed login attempts. | Sum | Count |
| Network throughput | Measures the amount of bytes both received from and transmitted to clients by each instance. | Average | Count per second |
| Queries | Measures the number of queries executed. | Average | Count per second |
| Result set cache hit ratio | Measures the number of requests that are served by the Resultset cache. | Average | Percentage |
| Select latency | Measures the amount of latency for select queries. | Average | Milliseconds |
| Select throughput | Measures the average number of select queries. | Average | Count per second |
| Update latency | Measures the amount of latency for update queries. | Average | Milliseconds |
| Update throughput | Measures the average number of update queries. | Average | Count per second |
| Volume bytes used | Measures the amount of storage used by your Aurora DB instance. | Average | MB |
| Volume read IOPs | Measures the number of billed read I/O operations from a cluster volume. | Sum | Count |
| Volume write IOPs | Measures the number of billed write I/O operations to a cluster volume. | Sum | Count |
| Serverless database capacity | Measures the Serverless Aurora database instance capacity. | Average | Count |
| Total backup storage billed | The total amount of billed backup storage. | Maximum | GB, Bytes |
| Snapshot storage used | Measures the amount of billed backup storage consumed snapshots. | Maximum | GB, Bytes |
| Backup retention period storage used | Measures the amount of billed backup storage used to support the point-in-time restore feature within backup retention window. | Maximum | GB, Bytes |
| Backtrack change records creation rate | Measures the number of backtrack change records created over time. | Average | Count |
| Backtrack change records stored | Measures the actual number of backtrack change records. | Average | Count |
| Backtrack window actual | Measures the difference between the target backtrack window and the actual backtrack window. | Average | Minutes |
| Backtrack window alert | Measures the number of times that the actual backtrack window is smaller than the target backtrack window. | Average | Count |
| Rollback segment history list length | The undo logs that record committed transactions with delete-marked records. These records are scheduled to be processed by the InnoDB purge operation. | Maximum | Count |
| Row lock time | The total time spent acquiring row locks for InnoDB tables. | Average | Milliseconds |
Configuration details
| Attribute | Description |
|---|---|
| Instance identifier | Shows the unique identifier of the DB instance. |
| Instance class | Shows the RDS DB instance class. |
| vCPUs | Displays the number of virtual cores for the DB instance type. |
| Memory | Displays the memory capacity of the RDS instance type. |
| Allocated storage space | Displays the allocated storage capacity for your instance type. |
| Creation time | Shows the time when the DB instance was created. |
| Engine name | Shows the name of the DB engine. |
| Engine version | Shows the default version of the specified Db engine. |
| Master username | Shows the RDS database master username. |
| Database name | Shows the name of the default database. |
| Region | The region where the DB instance is deployed. |
| Availability zone | The Availability zone where the replicas are deployed. |
| VPC ID | The ID of the Virtual Private Cloud where the DB instance is deployed. |
| Security groups | Displays the name of the security groups assigned to the DB instance. |
| Endpoint address | Shows the connection endpoint for the database. |
| Endpoint port | shows the port number on which the database accepts connections. |
| Multiple deployment | Shows whether the DB instacne is part of a multi AZ deployment or not. |
| Preferred back up window | Displays the prefered back up windows configured during DB instance creation. |
| Latest restorable time | Shows the latest restorable time of the DB instance. |
| Back up retention period | Displays the backup retention period for the DB instance. |
| Preferred maintenance window | Displays the prefered maintenance window for the DB cluster. |
See how you can configure a threshold profile for your monitored RDS instances.
Forecast
Estimate future values of the following performance metrics and make informed decisions about adding capacity or scaling your AWS infrastructure.
- CPU Utilization
- Free Storage Space
- Freeable Memory
- Swap Usage
- Bin Log Disk Usage
- Burst Balance
- Disk Queue Depth
- Transaction Logs Disk Usage
- CPU Credit Usage
- CPU Credit Balance
- CPU Surplus Usage
- CPU Surplus Balance
- Aurora Bin Log
- Free Local Storage
- Volume Read IOPs
- Volume Write IOPs