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:
- An DB instance can have multiple user-created databases.
- An DB instance 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.
- Each DB engine has a set of parameters in a DB parameter group that control the behavior of the databases that it manages.
You can do the following:
- Access a DB instance by using the same tools and applications that are 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.
External reference
Setup
To set up the AWS integration and discover the AWS service, go 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 | Metric Display Name | Unit | Aggregation Type |
|---|---|---|---|
| cloud.instance.state n/a | Status/State | n/a | n/a |
| aws_rds_CPUUtilization 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. | CPU utilization | Percent | Maximum |
| aws_rds_BinLogDiskUsage Amount of disk space occupied by binary logs on the master. Applies to MySQL read replicas. | BinLogDiskUsage | Bytes | Average |
| aws_rds_DatabaseConnections Number of database connections in use. | DatabaseConnections | Count | Average |
| aws_rds_DiskQueueDepth Number of outstanding IOs (read/write requests) waiting to access the disk. | DiskQueueDepth | Count | Average |
| aws_rds_FreeableMemory Amount of available random access memory. | FreeableMemory | Freeable Memory | Average |
| aws_rds_FreeStorageSpace Amount of available storage space. | FreeStorageSpace | Free Space | Average |
| aws_rds_SwapUsage Amount of swap space used on the DB Instance. | SwapUsage | Swap Usage | Average |
| aws_rds_NetworkReceiveThroughput Incoming (receive) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication. | NetworkReceiveThroughput | Average | |
| aws_rds_NetworkTransmitThroughput Outgoing (transmit) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication. | NetworkTransmitThroughput | Average | |
| aws_rds_ReadThroughput Average number of bytes read from disk per second. | ReadThroughput | Average | |
| aws_rds_WriteThroughput Average number of bytes written to disk per second. | WriteThroughput | Average | |
| aws_rds_ReadIOPS Average number of disk read operations per second | ReadIOPS | Count/Sec | Average |
| aws_rds_WriteIOPS Average number of write operations per second. | WriteIOPS | Count/Sec | Average |
| aws_rds_ReadLatency Average amount of time taken for disk read I/O operations. | ReadLatency | Seconds | Average |
| aws_rds_WriteLatency Average amount of time taken for disk write I/O operations. | WriteLatency | Seconds | Average |
| aws_rds_ReplicaLag Amount of time a Read Replica DB Instance lags behind the source DB Instance. Applies to MySQL read replicas. | ReplicaLag | Seconds | Average |
| aws_rds_CPUCreditBalance [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. | CPUCreditBalance | Count | Average |
| aws_rds_CPUCreditUsage [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. | CPUCreditUsage | Count | Average |
| aws_rds_BurstBalance Used with General Purpose SSD (gp2), Throughput Optimized HDD (st1), and Cold HDD (sc1) volumes only. Provides information about 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. | BurstBalance | Percent | Average |
| aws_rds_AuroraGlobalDBReplicatedWriteIO Aurora Global DB Replicated WriteIO | AuroraGlobalDBReplicatedWriteIO | Count | Average |
| aws_rds_AuroraGlobalDBDataTransferBytes Aurora Global DB Data Transfer Bytes | AuroraGlobalDBDataTransferBytes | Count | Average |
| aws_rds_AuroraGlobalDBReplicationLag Aurora Global DB Replication Lag | AuroraGlobalDBReplicationLag | Milliseconds | Average |
| aws_rds_MaximumUsedTransactionIDs Maximum transaction ID used. Applies to PostgreSQL. | MaximumUsedTransactionIDs | Count | Average |
| aws_rds_OldestReplicationSlotLag The lagging size of the replica lagging the most in terms of WAL data received. Applies to PostgreSQL. | OldestReplicationSlotLag | Megabytes | Average |
| aws_rds_ReplicationSlotDiskUsage Disk space used by replication slot files. Applies to PostgreSQL. | ReplicationSlotDiskUsage | Megabytes | Average |
| aws_rds_TransactionLogsDiskUsage Disk space used by transaction logs. Applies to PostgreSQL. | TransactionLogsDiskUsage | Megabytes | Average |
| aws_rds_TransactionLogsGeneration Size of transaction logs generated per second. Applies to PostgreSQL | TransactionLogsGeneration | Megabytes | Average |
| aws_rds_ActiveTransactions Active Transactions | Active Transactions | Count | Average |
| aws_rds_BlockedTransactions Blocked Transactions | Blocked Transactions | Count | Average |
| aws_rds_BufferCacheHitRatio Buffer Cache Hit Ratio | Buffer Cache Hit Ratio | Percent | Average |
| aws_rds_CommitThroughput Commit Throughput | Commit Throughput | Count/Second | Average |
| aws_rds_CommitLatency Commit Latency | Commit Latency | Milliseconds | Average |
| aws_rds_DDLLatency DDL Latency | DDL Latency | Milliseconds | Average |
| aws_rds_Deadlocks Deadlocks | Deadlocks | Count | Average |
| aws_rds_DMLThroughput DML Throughput | DML Throughput | Count/Second | Average |
| aws_rds_DMLLatency DML Latency | DML Latency | Milliseconds | Average |
| aws_rds_LoginFailures Login Failures | Login Failures | Count | Average |
| aws_rds_ResultSetCacheHitRatio Result Set Cache Hit Ratio | Result Set Cache Hit Ratio | Percent | Average |
| aws_rds_ReplicaLagMaximum Replica Lag Maximum | Replica Lag Maximum | Milliseconds | Average |
| aws_rds_AuroraReplicaLagMaximum Aurora Replica Lag Maximum | Aurora Replica Lag Maximum | Milliseconds | Average |
| aws_rds_AuroraReplicaLagMinimum Aurora Replica Lag Minimum | Aurora Replica Lag Minimum | Milliseconds | Average |
| aws_rds_SelectThroughput Select Throughput | Select Throughput | Count/Second | Average |
| aws_rds_SelectLatency Select Latency | Select Latency | Milliseconds | Average |
| aws_rds_VolumeReadIOPs Volume Read IOPS | Volume Read IOPS | Count | Average |
| aws_rds_VolumeWriteIOPs Volume Write IOPs | Volume Write IOPs | Count | Average |
| aws_rds_Queries Queries | Queries | Count/Second | Average |
| aws_rds_AuroraBinlogReplicaLag Aurora Binlog Replica Lag | Aurora Binlog Replica Lag | Seconds | Average |
| aws_rds_EngineUptime Engine Uptime | Engine Uptime | Seconds | Average |
| aws_rds_InsertLatency Insert Latency | Insert Latency | Milliseconds | Average |
| aws_rds_InsertThroughput Insert Throughput | Insert Throughput | Count/Second | Average |
| aws_rds_UpdateLatency Update Latency | Update Latency | Milliseconds | Average |
| aws_rds_UpdateThroughput Update Throughput | Update Throughput | Count/Second | Average |
| aws_rds_DeleteLatency Delete Latency | Delete Latency | Milliseconds | Average |
| aws_rds_DeleteThroughput Delete Throughput | Delete Throughput | Count/Second | Average |
| aws_rds_NetworkThroughput Network Throughput | Network Throughput | Bytes/Second | Average |
| aws_rds_BacktrackChangeRecordsCreationRate Backtrack Change Records Creation Rate | Backtrack Change Records Creation Rate | Count | Average |
| aws_rds_BacktrackChangeRecordsStored Backtrack Change Records Stored | Backtrack Change Records Stored | Count | Average |
| aws_rds_BacktrackWindowAlert Backtrack Window Alert | Backtrack Window Alert | Count | Average |
| aws_rds_ServerlessDatabaseCapacity Serverless Database Capacity | ServerlessDatabaseCapacity | Count | Average |
| aws_rds_FailedSQLServerAgentJobsCount Number of failed SQL Server Agent jobs during the last minute. | FailedSQLServerAgentJobsCount | Count | Average |