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.

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 MetricMetric Display NameUnitAggregation Type
cloud.instance.state

n/a
Status/Staten/an/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 upon a selected instance.
CPU utilizationPercentMaximum
aws_rds_BinLogDiskUsage

Amount of disk space occupied by binary logs on the master. Applies to MySQL read replicas.
BinLogDiskUsageBytesAverage
aws_rds_DatabaseConnections

Number of database connections in use.
DatabaseConnectionsCountAverage
aws_rds_DiskQueueDepth

Number of outstanding IOs (read/write requests) waiting to access the disk.
DiskQueueDepthCountAverage
aws_rds_FreeableMemory

Amount of available random access memory.
FreeableMemoryFreeable MemoryAverage
aws_rds_FreeStorageSpace

Amount of available storage space.
FreeStorageSpaceFree SpaceAverage
aws_rds_SwapUsage

Amount of swap space used on the DB Instance.
SwapUsageSwap UsageAverage
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.
NetworkReceiveThroughputAverage
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.
NetworkTransmitThroughputAverage
aws_rds_ReadThroughput

Average number of bytes read from disk per second.
ReadThroughputAverage
aws_rds_WriteThroughput

Average number of bytes written to disk per second.
WriteThroughputAverage
aws_rds_ReadIOPS

Average number of disk read operations per second
ReadIOPSCount/SecAverage
aws_rds_WriteIOPS

Average number of write operations per second.
WriteIOPSCount/SecAverage
aws_rds_ReadLatency

Average amount of time taken for disk read I/O operations.
ReadLatencySecondsAverage
aws_rds_WriteLatency

Average amount of time taken for disk write I/O operations.
WriteLatencySecondsAverage
aws_rds_ReplicaLag

Amount of time a Read Replica DB Instance lags behind the source DB Instance. Applies to MySQL read replicas.
ReplicaLagSecondsAverage
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.
CPUCreditBalanceCountAverage
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.
CPUCreditUsageCountAverage
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.
BurstBalancePercentAverage
aws_rds_AuroraGlobalDBReplicatedWriteIO

Aurora Global DB Replicated WriteIO
AuroraGlobalDBReplicatedWriteIOCountAverage
aws_rds_AuroraGlobalDBDataTransferBytes

Aurora Global DB Data Transfer Bytes
AuroraGlobalDBDataTransferBytesCountAverage
aws_rds_AuroraGlobalDBReplicationLag

Aurora Global DB Replication Lag
AuroraGlobalDBReplicationLagMillisecondsAverage
aws_rds_MaximumUsedTransactionIDs

Maximum transaction ID that has been used. Applies to PostgreSQL.
MaximumUsedTransactionIDsCountAverage
aws_rds_OldestReplicationSlotLag

The lagging size of the replica lagging the most in terms of WAL data received. Applies to PostgreSQL.
OldestReplicationSlotLagMegabytesAverage
aws_rds_ReplicationSlotDiskUsage

Disk space used by replication slot files. Applies to PostgreSQL.
ReplicationSlotDiskUsageMegabytesAverage
aws_rds_TransactionLogsDiskUsage

Disk space used by transaction logs. Applies to PostgreSQL.
TransactionLogsDiskUsageMegabytesAverage
aws_rds_TransactionLogsGeneration

Size of transaction logs generated per second. Applies to PostgreSQL
TransactionLogsGenerationMegabytesAverage
aws_rds_ActiveTransactions

Active Transactions
Active TransactionsCountAverage
aws_rds_BlockedTransactions

Blocked Transactions
Blocked TransactionsCountAverage
aws_rds_BufferCacheHitRatio

Buffer Cache Hit Ratio
Buffer Cache Hit RatioPercentAverage
aws_rds_CommitThroughput

Commit Throughput
Commit ThroughputCount/SecondAverage
aws_rds_CommitLatency

Commit Latency
Commit LatencyMillisecondsAverage
aws_rds_DDLLatency

DDL Latency
DDL LatencyMillisecondsAverage
aws_rds_Deadlocks

Deadlocks
DeadlocksCountAverage
aws_rds_DMLThroughput

DML Throughput
DML ThroughputCount/SecondAverage
aws_rds_DMLLatency

DML Latency
DML LatencyMillisecondsAverage
aws_rds_LoginFailures

Login Failures
Login FailuresCountAverage
aws_rds_ResultSetCacheHitRatio

Result Set Cache Hit Ratio
Result Set Cache Hit RatioPercentAverage
aws_rds_ReplicaLagMaximum

Replica Lag Maximum
Replica Lag MaximumMillisecondsAverage
aws_rds_AuroraReplicaLagMaximum

Aurora Replica Lag Maximum
Aurora Replica Lag MaximumMillisecondsAverage
aws_rds_AuroraReplicaLagMinimum

Aurora Replica Lag Minimum
Aurora Replica Lag MinimumMillisecondsAverage
aws_rds_SelectThroughput

Select Throughput
Select ThroughputCount/SecondAverage
aws_rds_SelectLatency

Select Latency
Select LatencyMillisecondsAverage
aws_rds_VolumeReadIOPs

Volume Read IOPS
Volume Read IOPSCountAverage
aws_rds_VolumeWriteIOPs

Volume Write IOPs
Volume Write IOPsCountAverage
aws_rds_Queries

Queries
QueriesCount/SecondAverage
aws_rds_AuroraBinlogReplicaLag

Aurora Binlog Replica Lag
Aurora Binlog Replica LagSecondsAverage
aws_rds_EngineUptime

Engine Uptime
Engine UptimeSecondsAverage
aws_rds_InsertLatency

Insert Latency
Insert LatencyMillisecondsAverage
aws_rds_InsertThroughput

Insert Throughput
Insert ThroughputCount/SecondAverage
aws_rds_UpdateLatency

Update Latency
Update LatencyMillisecondsAverage
aws_rds_UpdateThroughput

Update Throughput
Update ThroughputCount/SecondAverage
aws_rds_DeleteLatency

Delete Latency
Delete LatencyMillisecondsAverage
aws_rds_DeleteThroughput

Delete Throughput
Delete ThroughputCount/SecondAverage
aws_rds_NetworkThroughput

Network Throughput
Network ThroughputBytes/SecondAverage
aws_rds_BacktrackChangeRecordsCreationRate

Backtrack Change Records Creation Rate
Backtrack Change Records Creation RateCountAverage
aws_rds_BacktrackChangeRecordsStored

Backtrack Change Records Stored
Backtrack Change Records StoredCountAverage
aws_rds_BacktrackWindowAlert

Backtrack Window Alert
Backtrack Window AlertCountAverage
aws_rds_ServerlessDatabaseCapacity

Serverless Database Capacity
ServerlessDatabaseCapacityCountAverage
aws_rds_FailedSQLServerAgentJobsCount

Number of failed SQL Server Agent jobs during the last minute.
FailedSQLServerAgentJobsCountCountAverage

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.

External reference