Help Docs

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.

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

Was this document helpful?

Shortlink has been copied!