Introduction
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.
DB instances
A DB instance is an isolated database environment in the AWS Cloud with the following characteristics:
- An DB instance can contain 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 modify a DB instance by using the AWS Command Line Interface, the Amazon RDS API, or the AWS Management Console.
Note
Use the OpsRamp AWS public cloud integration to discover and collect metrics against the AWS service.Setup
To set up the OpsRamp AWS integration and discover the AWS service,
go to AWS Integration Discovery Profile and select RDS.
Metrics
| OpsRamp Metric | Metric Display Name | Unit | Aggregation Type | Description |
|---|---|---|---|---|
| cloud.instance.state | Status/State | n/a | n/a | n/a |
| aws_rds_CPUUtilization | CPU utilization | Percent | MAX | 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 upon a selected instance. |
| aws_rds_BinLogDiskUsage | BinLogDiskUsage | Bytes | AVERAGE | Amount of disk space occupied by binary logs on the master. Applies to MySQL read replicas. |
| aws_rds_DatabaseConnections | DatabaseConnections | Count | AVERAGE | Number of database connections in use. |
| aws_rds_DiskQueueDepth | DiskQueueDepth | Count | AVERAGE | Number of outstanding IOs (read/write requests) waiting to access the disk. |
| aws_rds_FreeableMemory | FreeableMemory | Freeable Memory | AVERAGE | Amount of available random access memory. |
| aws_rds_FreeStorageSpace | FreeStorageSpace | Free Space | AVERAGE | Amount of available storage space. |
| aws_rds_SwapUsage | SwapUsage | Swap Usage | AVERAGE | Amount of swap space used on the DB Instance. |
| aws_rds_NetworkReceiveThroughput | NetworkReceiveThroughput | AVERAGE | Incoming (receive) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication. | |
| aws_rds_NetworkTransmitThroughput | NetworkTransmitThroughput | AVERAGE | Outgoing (transmit) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication. | |
| aws_rds_ReadThroughput | ReadThroughput | AVERAGE | Average number of bytes read from disk per second. | |
| aws_rds_WriteThroughput | WriteThroughput | AVERAGE | Average number of bytes written to disk per second. | |
| aws_rds_ReadIOPS | ReadIOPS | Count/Sec | AVERAGE | Average number of disk read operations per second |
| aws_rds_WriteIOPS | WriteIOPS | Count/Sec | AVERAGE | Average number of write operations per second. |
| aws_rds_ReadLatency | ReadLatency | Secs | AVERAGE | Average amount of time taken for disk read I/O operations. |
| aws_rds_WriteLatency | WriteLatency | Secs | AVERAGE | Average amount of time taken for disk write I/O operations. |
| aws_rds_ReplicaLag | ReplicaLag | Secs | AVERAGE | Amount of time a Read Replica DB Instance lags behind the source DB Instance. Applies to MySQL read replicas. |
| aws_rds_CPUCreditBalance | CPUCreditBalance | Count | AVERAGE | [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. |
| aws_rds_CPUCreditUsage | CPUCreditUsage | Count | AVERAGE | [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. |
| aws_rds_BurstBalance | BurstBalance | Percent | Average | 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. |
| aws_rds_AuroraGlobalDBReplicatedWriteIO | AuroraGlobalDBReplicatedWriteIO | Count | Average | Aurora Global DB Replicated WriteIO |
| aws_rds_AuroraGlobalDBDataTransferBytes | AuroraGlobalDBDataTransferBytes | Count | Average | Aurora Global DB Data Transfer Bytes |
| aws_rds_AuroraGlobalDBReplicationLag | AuroraGlobalDBReplicationLag | Milliseconds | Average | Aurora Global DB Replication Lag |
| aws_rds_MaximumUsedTransactionIDs | MaximumUsedTransactionIDs | Count | Average | Maximum transaction ID that has been used. Applies to PostgreSQL. |
| aws_rds_OldestReplicationSlotLag | OldestReplicationSlotLag | Megabytes | Average | The lagging size of the replica lagging the most in terms of WAL data received. Applies to PostgreSQL. |
| aws_rds_ReplicationSlotDiskUsage | ReplicationSlotDiskUsage | Megabytes | Average | Disk space used by replication slot files. Applies to PostgreSQL. |
| aws_rds_TransactionLogsDiskUsage | TransactionLogsDiskUsage | Megabytes | Average | Disk space used by transaction logs. Applies to PostgreSQL. |
| aws_rds_TransactionLogsGeneration | TransactionLogsGeneration | Megabytes | Average | Size of transaction logs generated per second. Applies to PostgreSQL |
| aws_rds_ActiveTransactions | Active Transactions | Count | Average | Active Transactions |
| aws_rds_BlockedTransactions | Blocked Transactions | Count | Average | Blocked Transactions |
| aws_rds_BufferCacheHitRatio | Buffer Cache Hit Ratio | Percent | Average | Buffer Cache Hit Ratio |
| aws_rds_CommitThroughput | Commit Throughput | Count/Second | Average | Commit Throughput |
| aws_rds_CommitLatency | Commit Latency | Milliseconds | Average | Commit Latency |
| aws_rds_DDLLatency | DDL Latency | Milliseconds | Average | DDL Latency |
| aws_rds_Deadlocks | Deadlocks | Count | Average | Deadlocks |
| aws_rds_DMLThroughput | DML Throughput | Count/Second | Average | DML Throughput |
| aws_rds_DMLLatency | DML Latency | Milliseconds | Average | DML Latency |
| aws_rds_LoginFailures | Login Failures | Count | Average | Login Failures |
| aws_rds_ResultSetCacheHitRatio | Result Set Cache Hit Ratio | Percent | Average | Result Set Cache Hit Ratio |
| aws_rds_ReplicaLagMaximum | Replica Lag Maximum | Milliseconds | Average | Replica Lag Maximum |
| aws_rds_AuroraReplicaLagMaximum | Aurora Replica Lag Maximum | Milliseconds | Average | Aurora Replica Lag Maximum |
| aws_rds_AuroraReplicaLagMinimum | Aurora Replica Lag Minimum | Milliseconds | Average | Aurora Replica Lag Minimum |
| aws_rds_SelectThroughput | Select Throughput | Count/Second | Average | Select Throughput |
| aws_rds_SelectLatency | Select Latency | Milliseconds | Average | Select Latency |
| aws_rds_VolumeReadIOPs | Volume Read IOPS | Count | Average | Volume Read IOPS |
| aws_rds_VolumeWriteIOPs | Volume Write IOPs | Count | Average | Volume Write IOPs |
| aws_rds_Queries | Queries | Count/Second | Average | Queries |
| aws_rds_AuroraBinlogReplicaLag | Aurora Binlog Replica Lag | Seconds | Average | Aurora Binlog Replica Lag |
| aws_rds_EngineUptime | Engine Uptime | Seconds | Average | Engine Uptime |
| aws_rds_InsertLatency | Insert Latency | Milliseconds | Average | Insert Latency |
| aws_rds_InsertThroughput | Insert Throughput | Count/Second | Average | Insert Throughput |
| aws_rds_UpdateLatency | Update Latency | Milliseconds | Average | Update Latency |
| aws_rds_UpdateThroughput | Update Throughput | Count/Second | Average | Update Throughput |
| aws_rds_DeleteLatency | Delete Latency | Milliseconds | Average | Delete Latency |
| aws_rds_DeleteThroughput | Delete Throughput | Count/Second | Average | Delete Throughput |
| aws_rds_NetworkThroughput | Network Throughput | Bytes/Second | Average | Network Throughput |
| aws_rds_BacktrackChangeRecordsCreationRate | Backtrack Change Records Creation Rate | Count | Average | Backtrack Change Records Creation Rate |
| aws_rds_BacktrackChangeRecordsStored | Backtrack Change Records Stored | Count | Average | Backtrack Change Records Stored |
| aws_rds_BacktrackWindowAlert | Backtrack Window Alert | Count | Average | Backtrack Window Alert |
| aws_rds_ServerlessDatabaseCapacity | ServerlessDatabaseCapacity | Count | Average | Serverless Database Capacity |
| aws_rds_FailedSQLServerAgentJobsCount | FailedSQLServerAgentJobsCount | Count | Average | Number of failed SQL Server Agent jobs during the last minute. |
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.