The Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the AWS Cloud. It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks.
A DB instance is an isolated database environment in the AWS Cloud with the following characteristics:
- Can have multiple user-created databases.
- Runs a DB engine. Amazon RDS currently supports the MySQL, MariaDB, PostgreSQL, Oracle, and Microsoft SQL Server DB engines.
- Each DB engine has its own supported features, and each version of a DB engine may include specific features.
- Has a set of parameters in a DB parameter group that controls the behavior of the databases that it manages.
You can do the following:
- Access a DB instance using the same tools and applications used with a standalone database instance.
- Create and change a DB instance by using the AWS Command Line Interface, the Amazon RDS API, or the AWS Management Console.
Use the AWS public cloud integration to discover and collect metrics against the AWS service.
Setup
To set up the AWS integration and discover the AWS service, navigate to AWS Integration Discovery Profile and select RDS.
Event support
CloudTrail event support
- Supported (CreateDBCluster, DeleteDBCluster)
- Configurable in OpsRamp AWS Integration Discovery Profile.
CloudWatch alarm support
- Supported
- Configurable in OpsRamp AWS Integration Discovery Profile.
Supported metrics
| OpsRamp Metric | AWS Metric | Metric Display Name | Unit | Description | Aggregation Type |
|---|---|---|---|---|---|
| cloud.instance.state | n/a | Status/State | n/a | n/a | n/a |
| aws_rds_CPUUtilization | CPUUtilization | CPU utilization | Percent | Percentage of allocated EC2 compute units that are currently in use on the instance. This metric identifies the processing power required to run an application on a selected instance. | Average |
| aws_rds_BinLogDiskUsage | BinLogDiskUsage | BinLogDiskUsage | Bytes | Amount of disk space occupied by binary logs on the master. Applies to MySQL read replicas. | Sum |
| aws_rds_DatabaseConnections | DatabaseConnections | DatabaseConnections | Count | The number of database connections in use. | Average |
| aws_rds_DiskQueueDepth | DiskQueueDepth | DiskQueueDepth | Count | The number of outstanding IOs (read/write requests) waiting to access the disk. | Sum |
| aws_rds_FreeableMemory | FreeableMemory | FreeableMemory | Freeable Memory | Amount of available random access memory. | Average |
| aws_rds_FreeStorageSpace | FreeStorageSpace | FreeStorageSpace | Free Space | Amount of available storage space. | Average |
| aws_rds_SwapUsage | SwapUsage | SwapUsage | Swap Usage | Amount of swap space used on the DB Instance. | Sum |
| aws_rds_NetworkReceiveThroughput | NetworkReceiveThroughput | NetworkReceiveThroughput | Incoming (receive) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication. | Average | |
| aws_rds_NetworkTransmitThroughput | NetworkTransmitThroughput | NetworkTransmitThroughput | Outgoing (transmit) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication. | Average | |
| aws_rds_ReadThroughput | ReadThroughput | ReadThroughput | Average number of bytes read from disk per second. | Average | |
| aws_rds_WriteThroughput | WriteThroughput | WriteThroughput | Average number of bytes written to disk per second. | Average | |
| aws_rds_ReadIOPS | ReadIOPS | ReadIOPS | Count/Sec | The average number of disk read operations per second. | Average |
| aws_rds_WriteIOPS | WriteIOPS | WriteIOPS | Count/Sec | The average number of write operations per second. | Average |
| aws_rds_ReadLatency | ReadLatency | ReadLatency | Seconds | The average amount of time taken for disk read I/O operations. | Average |
| aws_rds_WriteLatency | WriteLatency | WriteLatency | Seconds | The average amount of time taken for disk write I/O operations. | Average |
| aws_rds_ReplicaLag | ReplicaLag | ReplicaLag | Seconds | Amount of time a Read Replica DB Instance lags behind the source DB Instance. Applies to MySQL read replicas. | Average |
| aws_rds_CPUCreditBalance | CPUCreditBalance | CPUCreditBalance | Count | [T2 instances] Number of CPU credits available for the instance to burst beyond its base CPU utilization. Credits are stored in the credit balance after they are earned and removed from the credit balance after they expire. Credits expire 24 hours after they are earned. CPU credit metrics are available only at a 5-minute frequency. | Average |
| aws_rds_CPUCreditUsage | CPUCreditUsage | CPUCreditUsage | Count | [T2 instances] Number of CPU credits available for the instance to burst beyond its base CPU utilization. Credits are stored in the credit balance after they are earned and removed from the credit balance after they expire. Credits expire 24 hours after they are earned. CPU credit metrics are available only at a 5-minute frequency. | Average |
| aws_rds_BurstBalance | BurstBalance | BurstBalance | Percent | Used with General Purpose SSD (gp2), Throughput Optimized HDD (st1), and Cold HDD (sc1) volumes only. Provides information about the Percentage of I/O credits (for gp2) or throughput credits (for st1 and sc1) remaining in the burst bucket. Data is reported to CloudWatch only when the volume is active. If the volume is not attached, no data is reported. | Average |
| aws_rds_AuroraGlobalDBReplicatedWriteIO | AuroraGlobalDBReplicatedWriteIO | AuroraGlobalDBReplicatedWriteIO | Count | Indicates the number of write I/O operations replicated in the Aurora Global database. | Sum |
| aws_rds_AuroraGlobalDBDataTransferBytes | AuroraGlobalDBDataTransferBytes | AuroraGlobalDBDataTransferBytes | Count | Indicates the data transferred in bytes in the Aurora Global database. | Sum |
| aws_rds_AuroraGlobalDBReplicationLag | AuroraGlobalDBReplicationLag | AuroraGlobalDBReplicationLag | Milliseconds | Indicates the amount of lag replicated in the Aurora Global database. | Sum |
| aws_rds_MaximumUsedTransactionIDs | MaximumUsedTransactionIDs | MaximumUsedTransactionIDs | Count | Maximum transaction ID used. Applies to PostgreSQL. | Average |
| aws_rds_OldestReplicationSlotLag | OldestReplicationSlotLag | OldestReplicationSlotLag | Megabytes | The size of the replica lagged the most in terms of WAL data received. Applies to PostgreSQL. | Sum |
| aws_rds_ReplicationSlotDiskUsage | ReplicationSlotDiskUsage | ReplicationSlotDiskUsage | Megabytes | Disk space used by replication slot files. Applies to PostgreSQL. | Sum |
| aws_rds_TransactionLogsDiskUsage | TransactionLogsDiskUsage | TransactionLogsDiskUsage | Megabytes | Disk space used by transaction logs applies to PostgreSQL. | Sum |
| aws_rds_TransactionLogsGeneration | TransactionLogsGeneration | TransactionLogsGeneration | Megabytes | The size of transaction logs generated per second applies to PostgreSQL. | Average |
| aws_rds_ActiveTransactions | ActiveTransactions | Active Transactions | Count | The average number of current transactions executing on a database instance per second. | Average |
| aws_rds_BlockedTransactions | BlockedTransactions | Blocked Transactions | Count | The average number of blocked transactions on a database. | Average |
| aws_rds_BufferCacheHitRatio | BufferCacheHitRatio | Buffer Cache Hit Ratio | Percent | The percentage of requests that are served by the buffer cache. | Average |
| aws_rds_CommitThroughput | CommitThroughput | Commit Throughput | Count/Second | The average number of commit operations per second. | Average |
| aws_rds_CommitLatency | CommitLatency | Commit Latency | Milliseconds | Gets the cumulative commit latency in milliseconds for Aurora PostgreSQL databases. | Average |
| aws_rds_DDLLatency | DDLLatency | DDL Latency | Milliseconds | The average duration of requests in milliseconds. | Average |
| aws_rds_Deadlocks | Deadlocks | Deadlocks | Count | The average count of deadlocks in the database. | Average |
| aws_rds_DMLThroughput | DMLThroughput | DML Throughput | Count/Second | The average number of inserts, updates, and deletes per second. | Average |
| aws_rds_DMLLatency | DMLLatency | DML Latency | Milliseconds | The average count of DML latency in milliseconds. | Average |
| aws_rds_LoginFailures | LoginFailures | Login Failures | Count | Provides failed login counts of a database. | Average |
| aws_rds_ResultSetCacheHitRatio | ResultSetCacheHitRatio | Result Set Cache Hit Ratio | Percent | The percentage of requests that are served by the Resultset cache. | Average |
| aws_rds_ReplicaLagMaximum | ReplicaLagMaximum | Replica Lag Maximum | Milliseconds | The maximum amount of lag between the primary instance and any of the DB instances in the DB cluster. | Average |
| aws_rds_AuroraReplicaLagMaximum | AuroraReplicaLagMaximum | Aurora Replica Lag Maximum | Milliseconds | The maximum amount of lag between the primary instance and any of the Aurora DB instances in the DB cluster. | Maximum |
| aws_rds_AuroraReplicaLagMinimum | AuroraReplicaLagMinimum | Aurora Replica Lag Minimum | Milliseconds | The minimum amount of lag between the primary instance and any of the Aurora DB instances in the DB cluster. | Minimum |
| aws_rds_SelectThroughput | SelectThroughput | Select Throughput | Count/Second | The average number of select queries per second. | Average |
| aws_rds_SelectLatency | SelectLatency | Select Latency | Milliseconds | The average amount of time for select operations. | Average |
| aws_rds_VolumeReadIOPs | VolumeReadIOPS | Volume Read IOPS | Count | The number of billed read I/O operations from a cluster volume. | Sum |
| aws_rds_VolumeWriteIOPs | VolumeWriteIOPs | Volume Write IOPs | Count | The number of billed write I/O operations from a cluster volume. | Sum |
| aws_rds_Queries | Queries | Queries | Count/Second | The average count of queries in a database. | Average |
| aws_rds_AuroraBinlogReplicaLag | AuroraBinlogReplicaLag | Aurora Binlog Replica Lag | Seconds | The amount of time a binary log replica DB cluster runs on Aurora MySQL-Compatible Edition lags. | Sum |
| aws_rds_EngineUptime | EngineUptime | Engine Uptime | Seconds | The amount of time that the instance has been running. | Sum |
| aws_rds_InsertLatency | InsertLatency | Insert Latency | Milliseconds | The average duration of insert operations. | Average |
| aws_rds_InsertThroughput | InsertThroughput | Insert Throughput | Count/Second | The average number of insert operations per second. | Average |
| aws_rds_UpdateLatency | UpdateLatency | Update Latency | Milliseconds | The average amount of time taken for update operations. | Average |
| aws_rds_UpdateThroughput | UpdateThroughput | Update Throughput | Count/Second | The average number of update operations per second. | Average |
| aws_rds_DeleteLatency | DeleteLatency | Delete Latency | Milliseconds | The average duration of delete operations. | Average |
| aws_rds_DeleteThroughput | DeleteThroughput | Delete Throughput | Count/Second | The average number of delete operations per second. | Average |
| aws_rds_NetworkThroughput | NetworkThroughput | Network Throughput | Bytes/Second | The network traffic on the DB instance. | Average |
| aws_rds_BacktrackChangeRecordsCreationRate | BacktrackChangeRecordsCreationRate | Backtrack Change Records Creation Rate | Count | Shows the number of backtrack change records created for your DB cluster. | Sum |
| aws_rds_BacktrackChangeRecordsStored | BacktrackChangeRecordsStored | Backtrack Change Records Stored | Count | The actual number of backtrack change records used by your DB cluster. | Sum |
| aws_rds_BacktrackWindowAlert | BacktrackWindowAlert | Backtrack Window Alert | Count | The number of times the actual backtrack window is smaller than the target backtrack window for a given period. | Sum |
| aws_rds_ServerlessDatabaseCapacity | ServerlessDatabaseCapacity | ServerlessDatabaseCapacity | Count | Reports the number of ACUs represented by the current DB instance capacity. | Sum |
| aws_rds_FailedSQLServerAgentJobsCount | FailedSQLServerAgentJobsCount | FailedSQLServerAgentJobsCount | Count | The number of failed Microsoft SQL Server Agent jobs. | Sum |
| aws_rds_DBLoad | DBLoad | DB Load | None | The number of active sessions for the DB engine. This shows the data for the average number of active sessions. In Performance Insights, this data is queried as db.load.avg. | Average |
| aws_rds_DBLoadCPU | DBLoadCPU | DB Load CPU | None | The number of active sessions where the wait event type is CPU. In Performance Insights, this data is queried as db.load.avg, filtered by the wait event type CPU. | Average |
| aws_rds_DBLoadNonCPU | DBLoadNonCPU | DB Load Non CPU | None | The number of active sessions where the wait event type is not CPU. | Average |