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.
RDS Instance/Cluster Resource Information:
- Type of Resource: Generic monitorable resource
- Discovery type: AWS SDK discovery type
- Discovery profile selection: Resource can be discovered by “RDS” in the profiler
- ResourceTag: RDS
- Resource Unique Identification:
- Instance: dbiResourceId+"-"+regionName (dbInstance.dbiResourceId()+"-"+region)
- Cluster: dbClusterResourceId+"-"+regionName (dbCluster.dbClusterResourceId()+"-"+region)
- Dependencies: RDS instances may depend on DB subnet groups, parameter groups, and security groups for configuration and connectivity
DB Subnet Group Resource Information:
- Type of Resource: Generic non-monitorable resource
- Discovery type: AWS SDK discovery type
- Discovery profile selection: Resource can be discovered by “DB Subnet Group” in the profiler
- ResourceTag: AWS_RDS_SUBNET_GRP
- Resource Unique Identification: dbSubnetGroupArn (subnetGrp.dbSubnetGroupArn())
- Dependencies: DB Subnet Group may be used by RDS instances for VPC connectivity
DB Snapshot Resource Information:
- Type of Resource: Generic non-monitorable resource
- Discovery type: AWS SDK discovery type
- Discovery profile selection: Resource can be discovered by “DB Snapshot” in the profiler
- ResourceTag: AWS_RDS_SNAPSHOT
- Resource Unique Identification: dbSnapshotArn (snapshot.dbSnapshotArn())
- Dependencies: DB Snapshot may be created from RDS instances for backup and recovery
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 | Aggregation Type | Description |
|---|---|---|---|---|---|
| aws_rds_AuroraGlobalDBDataTransferBytes | AuroraGlobalDBDataTransferBytes | Aurora Global DB Data Transfer Bytes | Bytes | Average | In an Aurora Global Database, the amount of redo log data transferred from the source AWS Region to a secondary AWS Region. |
| aws_rds_AuroraGlobalDBProgressLag | AuroraGlobalDBProgressLag | Aurora Global DB Progress Lag | Milliseconds | Average | In an Aurora Global Database, the measure of how far the secondary cluster is behind the primary cluster for both user transactions and system transactions. |
| aws_rds_AuroraGlobalDBReplicatedWriteIO | AuroraGlobalDBReplicatedWriteIO | Aurora Global DB Replicated Write IO | Count | Average | In an Aurora Global Database, the number of write I/O operations replicated from the primary AWS Region to the cluster volume in a secondary AWS Region. |
| aws_rds_AuroraGlobalDBReplicationLag | AuroraGlobalDBReplicationLag | Aurora Global DB Replication Lag | Milliseconds | Average | For an Aurora Global Database, the amount of lag when replicating updates from the primary AWS Region. |
| aws_rds_AuroraGlobalDBRPOLag | AuroraGlobalDBRPOLag | Aurora Global DBRPO Lag | Milliseconds | Average | In an Aurora Global Database, the recovery point objective (RPO) lag time. |
| aws_rds_AuroraVolumeBytesLeftTotal | AuroraVolumeBytesLeftTotal | Aurora Volume Bytes Left Total | Bytes | Average | The remaining available space for the cluster volume. |
| aws_rds_BacktrackChangeRecordsCreationRate | BacktrackChangeRecordsCreationRate | Backtrack Change Records Creation Rate | Count | Average | The number of backtrack change records created over 5 minutes for your DB cluster. |
| aws_rds_BacktrackChangeRecordsStored | BacktrackChangeRecordsStored | Backtrack Change Records Stored | Count | Average | The number of backtrack change records used by your DB cluster. |
| aws_rds_BackupRetentionPeriodStorageUsed | BackupRetentionPeriodStorageUsed | Backup Retention Period Storage Used | Bytes | Average | The total amount of backup storage used to support the point-in-time restore feature within the Aurora DB cluster''s backup retention window. |
| aws_rds_ServerlessDatabaseCapacity | ServerlessDatabaseCapacity | Serverless Database Capacity | Count | Average | The current capacity of an Aurora Serverless DB cluster. |
| aws_rds_SnapshotStorageUsed | SnapshotStorageUsed | Snapshot Storage Used | Bytes | Average | The total amount of backup storage consumed by all Aurora snapshots for an Aurora DB cluster outside its backup retention window. |
| aws_rds_TotalBackupStorageBilled | TotalBackupStorageBilled | Total Backup Storage Billed | Bytes | Average | The total amount of backup storage in bytes for which you are billed for a given Aurora DB cluster. |
| aws_rds_VolumeBytesUsed | VolumeBytesUsed | Volume Bytes Used | Bytes | Average | The amount of storage used by your Aurora DB cluster. |
| aws_rds_VolumeReadIOPs | VolumeReadIOPs | Volume Read IO Ps | Count | Average | The number of billed read I/O operations from a cluster volume within a 5-minute interval. |
| aws_rds_VolumeWriteIOPs | VolumeWriteIOPs | Volume Write IO Ps | Count | Average | The number of write disk I/O operations to the cluster volume, reported at 5-minute intervals. |
| aws_rds_AbortedClients | AbortedClients | Aborted Clients | Count | Average | The number of client connections that have not been closed properly. |
| aws_rds_ActiveTransactions | ActiveTransactions | Active Transactions | Count/Second | Average | The average number of current transactions executing on an Aurora database instance per second. |
| aws_rds_ACUUtilization | ACUUtilization | ACU Utilization | Percent | Average | The value of the ServerlessDatabaseCapacity metric divided by the maximum ACU value of the DB cluster. |
| aws_rds_AuroraBinlogReplicaLag | AuroraBinlogReplicaLag | Aurora Binlog Replica Lag | Seconds | Average | The amount of time that a binary log replica DB cluster running on Aurora MySQL lags behind the binary log replication source. |
| aws_rds_AuroraDMLRejectedMasterFull | AuroraDMLRejectedMasterFull | Aurora DML Rejected Master Full | Count | Average | The number of forwarded queries that are rejected because the session is full on the writer DB instance. |
| aws_rds_AuroraDMLRejectedWriterFull | AuroraDMLRejectedWriterFull | Aurora DML Rejected Writer Full | Count | Average | The number of forwarded queries that are rejected because the session is full on the writer DB instance. |
| aws_rds_AuroraEstimatedSharedMemoryBytes | AuroraEstimatedSharedMemoryBytes | Aurora Estimated Shared Memory Bytes | Bytes | Average | The estimated amount of shared buffer or buffer pool memory which was actively used during the last configured polling interval. |
| aws_rds_AuroraMemoryHealthState | AuroraMemoryHealthState | Aurora Memory Health State | None | Average | Indicates the memory health state. A value of 0 equals NORMAL. A value of 10 equals RESERVED, which means that the server is approaching a critical level of memory usage. |
| aws_rds_AuroraMemoryNumDeclinedSqlTotal | AuroraMemoryNumDeclinedSqlTotal | Aurora Memory Num Declined Sql Total | Count | Average | The incremental number of queries declined as part of out-of-memory (OOM) avoidance. |
| aws_rds_AuroraMemoryNumKillConnTotal | AuroraMemoryNumKillConnTotal | Aurora Memory Num Kill Conn Total | Count | Average | The incremental number of connections closed as part of OOM avoidance. |
| aws_rds_AuroraMemoryNumKillQueryTotal | AuroraMemoryNumKillQueryTotal | Aurora Memory Num Kill Query Total | Count | Average | The incremental number of queries ended as part of OOM avoidance. |
| aws_rds_AuroraMillisecondsSpentInOomRecovery | AuroraMillisecondsSpentInOomRecovery | Aurora Milliseconds Spent In Oom Recovery | Milliseconds | Average | The amount of time since the memory health dropped below the normal state. |
| aws_rds_AuroraNumOomRecoverySuccessful | AuroraNumOomRecoverySuccessful | Aurora Num Oom Recovery Successful | Count | Average | The number of times that the memory health was restored to the normal state. |
| aws_rds_AuroraNumOomRecoveryTriggered | AuroraNumOomRecoveryTriggered | Aurora Num Oom Recovery Triggered | Count | Average | The number of times that the memory health dropped below the normal state. |
| aws_rds_AuroraOptimizedReadsCacheHitRatio | AuroraOptimizedReadsCacheHitRatio | Aurora Optimized Reads Cache Hit Ratio | Percent | Average | The percentage of requests that are served by the Optimized Reads cache. |
| aws_rds_AuroraReplicaLag | AuroraReplicaLag | Aurora Replica Lag | Milliseconds | Average | For an Aurora replica, the amount of lag when replicating updates from the primary instance. |
| aws_rds_AuroraReplicaLagMaximum | AuroraReplicaLagMaximum | Aurora Replica Lag Maximum | Milliseconds | Average | The maximum amount of lag between the primary instance and any of the Aurora DB instance in the DB cluster. |
| aws_rds_AuroraReplicaLagMinimum | AuroraReplicaLagMinimum | Aurora Replica Lag Minimum | Milliseconds | Average | The minimum amount of lag between the primary instance and any of the Aurora DB instance in the DB cluster. |
| aws_rds_AuroraSlowConnectionHandleCount | AuroraSlowConnectionHandleCount | Aurora Slow Connection Handle Count | Count | Average | The number of connections that have waited two seconds or longer to start the handshake. |
| aws_rds_AuroraSlowHandshakeCount | AuroraSlowHandshakeCount | Aurora Slow Handshake Count | Count | Average | The number of connections that have taken 50 milliseconds or longer to finish the handshake. |
| aws_rds_BacktrackWindowActual | BacktrackWindowActual | Backtrack Window Actual | None | Average | The difference between the target backtrack window and the actual backtrack window. |
| aws_rds_BacktrackWindowAlert | BacktrackWindowAlert | Backtrack Window Alert | Count | Average | The number of times that the actual backtrack window is smaller than the target backtrack window for a given period of time. |
| aws_rds_BlockedTransactions | BlockedTransactions | Blocked Transactions | Count/Second | Average | The average number of transactions in the database that are blocked per second. |
| aws_rds_BufferCacheHitRatio | BufferCacheHitRatio | Buffer Cache Hit Ratio | Percent | Average | The percentage of requests that are served by the buffer cache. |
| aws_rds_CommitLatency | CommitLatency | Commit Latency | Milliseconds | Average | The average duration taken by the engine and storage to complete the commit operations. |
| aws_rds_CommitThroughput | CommitThroughput | Commit Throughput | Count/Second | Average | The average number of commit operations per second. |
| aws_rds_ConnectionAttempts | ConnectionAttempts | Connection Attempts | Count | Average | The number of attempts to connect to an instance, whether successful or not. |
| aws_rds_CPUCreditBalance | CPUCreditBalance | CPU Credit Balance | Count | Average | The number of CPU credits that an instance has accumulated, reported at 5-minute intervals. |
| aws_rds_CPUCreditUsage | CPUCreditUsage | CPU Credit Usage | Count | Average | The number of CPU credits consumed during the specified period, reported at 5-minute intervals. This metric measures the amount of time during which physical CPUs have been used for processing instructions by virtual CPUs allocated to the DB instance. |
| aws_rds_CPUSurplusCreditBalance | CPUSurplusCreditBalance | CPU Surplus Credit Balance | None | Average | The number of surplus credits that have been spent by an unlimited instance when its CPUCreditBalance value is zero. |
| aws_rds_CPUSurplusCreditsCharged | CPUSurplusCreditsCharged | CPU Surplus Credits Charged | None | Average | The number of spent surplus credits that are not paid down by earned CPU credits, and which thus incur an additional charge. |
| aws_rds_CPUUtilization | CPUUtilization | CPU Utilization | Percent | Average | The percentage of CPU used by an Aurora DB instance. |
| aws_rds_DatabaseConnections | DatabaseConnections | Database Connections | Count | Average | The number of client network connections to the database instance. |
| aws_rds_DDLLatency | DDLLatency | DDL Latency | Milliseconds | Average | The average duration of requests such as example, create, alter, and drop requests. |
| aws_rds_DDLThroughput | DDLThroughput | DDL Throughput | Count/Second | Average | The average number of DDL requests per second. |
| aws_rds_Deadlocks | Deadlocks | Deadlocks | Count/Second | Average | The average number of deadlocks in the database per second. |
| aws_rds_DeleteLatency | DeleteLatency | Delete Latency | Milliseconds | Average | The average duration of delete operations. |
| aws_rds_DeleteThroughput | DeleteThroughput | Delete Throughput | Count/Second | Average | The average number of delete queries per second. |
| aws_rds_DiskQueueDepth | DiskQueueDepth | Disk Queue Depth | Count | Average | The number of outstanding read/write requests waiting to access the disk. |
| aws_rds_DMLLatency | DMLLatency | DML Latency | Milliseconds | Average | The average duration of inserts, updates, and deletes. |
| aws_rds_DMLThroughput | DMLThroughput | DML Throughput | Count/Second | Average | The average number of inserts, updates, and deletes per second. |
| aws_rds_EngineUptime | EngineUptime | Engine Uptime | Seconds | Average | The amount of time that the instance has been running. |
| aws_rds_FreeableMemory | FreeableMemory | Freeable Memory | Bytes | Average | The amount of available random access memory. |
| aws_rds_FreeEphemeralStorage | FreeEphemeralStorage | Free Ephemeral Storage | Bytes | Average | The amount of available Ephemeral NVMe storage. |
| aws_rds_FreeLocalStorage | FreeLocalStorage | Free Local Storage | Bytes | Average | The amount of local storage available. |
| aws_rds_InsertLatency | InsertLatency | Insert Latency | Milliseconds | Average | The average duration of insert operations. |
| aws_rds_InsertThroughput | InsertThroughput | Insert Throughput | Count/Second | Average | The average number of insert operations per second. |
| aws_rds_LoginFailures | LoginFailures | Login Failures | Count/Second | Average | The average number of failed login attempts per second. |
| aws_rds_MaximumUsedTransactionIDs | MaximumUsedTransactionIDs | Maximum Used Transaction I Ds | Count | Average | The age of the oldest unvacuumed transaction ID, in transactions. |
| aws_rds_NetworkReceiveThroughput | NetworkReceiveThroughput | Network Receive Throughput | Bytes/Second | Average | The amount of network throughput received from clients by each instance in the Aurora DB cluster. |
| aws_rds_NetworkThroughput | NetworkThroughput | Network Throughput | Bytes/Second | Average | The amount of network throughput both received from and transmitted to clients by each instance in the Aurora DB cluster. |
| aws_rds_NetworkTransmitThroughput | NetworkTransmitThroughput | Network Transmit Throughput | Bytes/Second | Average | The amount of network throughput sent to clients by each instance in the Aurora DB cluster. |
| aws_rds_NumBinaryLogFiles | NumBinaryLogFiles | Num Binary Log Files | Count | Average | The number of binlog files generated. |
| aws_rds_OldestReplicationSlotLag | OldestReplicationSlotLag | Oldest Replication Slot Lag | Bytes | Average | The lagging size of the replica lagging the most in terms of write-ahead log (WAL) data received. |
| aws_rds_PurgeBoundary | PurgeBoundary | Purge Boundary | Count | Average | Transaction number up to which InnoDB purging is allowed. |
| aws_rds_PurgeFinishedPoint | PurgeFinishedPoint | Purge Finished Point | Count | Average | Transaction number up to which InnoDB purging is performed. This metric can help you examine how fast InnoDB purging is progressing. |
| aws_rds_Queries | Queries | Queries | Count/Second | Average | The average number of queries executed per second. |
| aws_rds_RDSToAuroraPostgreSQLReplicaLag | RDSToAuroraPostgreSQLReplicaLag | RDS To Aurora Postgre SQL Replica Lag | Seconds | Average | The lag when replicating updates from the primary RDS PostgreSQL instance to other nodes in the cluster. |
| aws_rds_ReadIOPS | ReadIOPS | Read IOPS | Count/Second | Average | The average number of disk I/O operations per second but the reports read and write separately, in 1-minute intervals. |
| aws_rds_ReadIOPSEphemeralStorage | ReadIOPSEphemeralStorage | Read IOPS Ephemeral Storage | Count/Second | Average | The average number of disk read I/O operations to Ephemeral NVMe storage. |
| aws_rds_ReadLatency | ReadLatency | Read Latency | Seconds | Average | The average amount of time taken per disk I/O operation. |
| aws_rds_ReadLatencyEphemeralStorage | ReadLatencyEphemeralStorage | Read Latency Ephemeral Storage | Seconds | Average | The average amount of time taken per disk read I/O operation for Ephemeral NVMe storage. |
| aws_rds_ReadLatencyEphemeralStorage | ReadLatencyEphemeralStorage | Read Latency Ephemeral Storage | Seconds | Average | The average amount of time taken per disk read I/O operation for Ephemeral NVMe storage. |
| aws_rds_ReadThroughput | ReadThroughput | Read Throughput | Bytes/Second | Average | The average number of bytes read from disk per second. |
| aws_rds_ReadThroughputEphemeralStorage | ReadThroughputEphemeralStorage | Read Throughput Ephemeral Storage | Bytes/Second | Average | The average number of bytes read from disk per second for Ephemeral NVMe storage. |
| aws_rds_ReplicationSlotDiskUsage | ReplicationSlotDiskUsage | Replication Slot Disk Usage | Bytes | Average | The amount of disk space consumed by replication slot files. |
| aws_rds_ResultSetCacheHitRatio | ResultSetCacheHitRatio | Result Set Cache Hit Ratio | Percent | Average | The percentage of requests that are served by the Resultset cache. |
| aws_rds_RollbackSegmentHistoryListLength | RollbackSegmentHistoryListLength | Rollback Segment History List Length | Count | Average | The undo logs that record committed transactions with delete-marked records. These records are scheduled to be processed by the InnoDB purge operation. |
| aws_rds_RowLockTime | RowLockTime | Row Lock Time | Milliseconds | Average | The total time spent acquiring row locks for InnoDB tables. |
| aws_rds_SelectLatency | SelectLatency | Select Latency | Milliseconds | Average | The average amount of time for select operations. |
| aws_rds_SelectThroughput | SelectThroughput | Select Throughput | Count/Second | Average | The average number of select queries per second. |
| aws_rds_ServerlessDatabaseCapacity | ServerlessDatabaseCapacity | Serverless Database Capacity | Count | Average | The current capacity of an Aurora Serverless DB cluster. |
| aws_rds_StorageNetworkReceiveThroughput | StorageNetworkReceiveThroughput | Storage Network Receive Throughput | Bytes/Second | Average | The amount of network throughput received from the Aurora storage subsystem by each instance in the DB cluster. |
| aws_rds_StorageNetworkThroughput | StorageNetworkThroughput | Storage Network Throughput | Bytes/Second | Average | The amount of network throughput received from and sent to the Aurora storage subsystem by each instance in the Aurora DB cluster. |
| aws_rds_StorageNetworkTransmitThroughput | StorageNetworkTransmitThroughput | Storage Network Transmit Throughput | Bytes/Second | Average | The amount of network throughput sent to the Aurora storage subsystem by each instance in the Aurora DB cluster. |
| aws_rds_SumBinaryLogSize | SumBinaryLogSize | Sum Binary Log Size | Bytes | Average | The total size of the binlog files. |
| aws_rds_SwapUsage | SwapUsage | Swap Usage | Bytes | Average | The amount of swap space used. |
| aws_rds_TempStorageIOPS | TempStorageIOPS | Temp Storage IOPS | Count/Second | Average | The number of IOPS for both read and writes on local storage attached to the DB instance. This metric represents a count and is measured once per second. |
| aws_rds_TempStorageThroughput | TempStorageThroughput | Temp Storage Throughput | Bytes/Second | Average | The amount of data transferred to and from local storage associated with the DB instance. This metric represents bytes and is measured once per second. |
| aws_rds_TransactionAgeMaximum | TransactionAgeMaximum | Transaction Age Maximum | Seconds | Average | The age of the oldest active running transaction. |
| aws_rds_TransactionLogsDiskUsage | TransactionLogsDiskUsage | Transaction Logs Disk Usage | Bytes | Average | The amount of disk space consumed by transaction logs on the Aurora PostgreSQL DB instance. |
| aws_rds_TruncateFinishedPoint | TruncateFinishedPoint | Truncate Finished Point | Count | Average | The transaction identifier up to which undo truncation is performed. |
| aws_rds_UpdateLatency | UpdateLatency | Update Latency | Milliseconds | Average | The average amount of time taken for update operations. |
| aws_rds_UpdateThroughput | UpdateThroughput | Update Throughput | Count/Second | Average | The average number of updates per second. |
| aws_rds_WriteIOPS | WriteIOPS | Write IOPS | Count/Second | Average | The number of Aurora storage write records generated per second. |
| aws_rds_WriteIOPSEphemeralStorage | WriteIOPSEphemeralStorage | Write IOPS Ephemeral Storage | Count/Second | Average | The average number of disk write I/O operations to Ephemeral NVMe storage. |
| aws_rds_WriteLatency | WriteLatency | Write Latency | Seconds | Average | The average amount of time taken per disk I/O operation. |
| aws_rds_WriteLatencyEphemeralStorage | WriteLatencyEphemeralStorage | Write Latency Ephemeral Storage | Seconds | Average | The average amount of time taken per disk write I/O operation for Ephemeral NVMe storage. |
| aws_rds_WriteThroughput | WriteThroughput | Write Throughput | Bytes/Second | Average | The average number of bytes written to persistent storage every second. |
| aws_rds_WriteThroughputEphemeralStorage | WriteThroughputEphemeralStorage | Write Throughput Ephemeral Storage | Bytes/Second | Average | The average number of bytes written to disk per second for Ephemeral NVMe storage. |