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.

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 TypeDescription
cloud.instance.stateStatus/Staten/an/an/a
aws_rds_CPUUtilizationCPU utilizationPercentMAXPercentage 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_BinLogDiskUsageBinLogDiskUsageBytesAVERAGEAmount of disk space occupied by binary logs on the master. Applies to MySQL read replicas.
aws_rds_DatabaseConnectionsDatabaseConnectionsCountAVERAGENumber of database connections in use.
aws_rds_DiskQueueDepthDiskQueueDepthCountAVERAGENumber of outstanding IOs (read/write requests) waiting to access the disk.
aws_rds_FreeableMemoryFreeableMemoryFreeable MemoryAVERAGEAmount of available random access memory.
aws_rds_FreeStorageSpaceFreeStorageSpaceFree SpaceAVERAGEAmount of available storage space.
aws_rds_SwapUsageSwapUsageSwap UsageAVERAGEAmount of swap space used on the DB Instance.
aws_rds_NetworkReceiveThroughputNetworkReceiveThroughputAVERAGEIncoming (receive) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication.
aws_rds_NetworkTransmitThroughputNetworkTransmitThroughputAVERAGEOutgoing (transmit) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication.
aws_rds_ReadThroughputReadThroughputAVERAGEAverage number of bytes read from disk per second.
aws_rds_WriteThroughputWriteThroughputAVERAGEAverage number of bytes written to disk per second.
aws_rds_ReadIOPSReadIOPSCount/SecAVERAGEAverage number of disk read operations per second
aws_rds_WriteIOPSWriteIOPSCount/SecAVERAGEAverage number of write operations per second.
aws_rds_ReadLatencyReadLatencySecsAVERAGEAverage amount of time taken for disk read I/O operations.
aws_rds_WriteLatencyWriteLatencySecsAVERAGEAverage amount of time taken for disk write I/O operations.
aws_rds_ReplicaLagReplicaLagSecsAVERAGEAmount of time a Read Replica DB Instance lags behind the source DB Instance. Applies to MySQL read replicas.
aws_rds_CPUCreditBalanceCPUCreditBalanceCountAVERAGE[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_CPUCreditUsageCPUCreditUsageCountAVERAGE[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_BurstBalanceBurstBalancePercentAverageUsed 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_AuroraGlobalDBReplicatedWriteIOAuroraGlobalDBReplicatedWriteIOCountAverageAurora Global DB Replicated WriteIO
aws_rds_AuroraGlobalDBDataTransferBytesAuroraGlobalDBDataTransferBytesCountAverageAurora Global DB Data Transfer Bytes
aws_rds_AuroraGlobalDBReplicationLagAuroraGlobalDBReplicationLagMillisecondsAverageAurora Global DB Replication Lag
aws_rds_MaximumUsedTransactionIDsMaximumUsedTransactionIDsCountAverageMaximum transaction ID that has been used. Applies to PostgreSQL.
aws_rds_OldestReplicationSlotLagOldestReplicationSlotLagMegabytesAverageThe lagging size of the replica lagging the most in terms of WAL data received. Applies to PostgreSQL.
aws_rds_ReplicationSlotDiskUsageReplicationSlotDiskUsageMegabytesAverageDisk space used by replication slot files. Applies to PostgreSQL.
aws_rds_TransactionLogsDiskUsageTransactionLogsDiskUsageMegabytesAverageDisk space used by transaction logs. Applies to PostgreSQL.
aws_rds_TransactionLogsGenerationTransactionLogsGenerationMegabytesAverageSize of transaction logs generated per second. Applies to PostgreSQL
aws_rds_ActiveTransactionsActive TransactionsCountAverageActive Transactions
aws_rds_BlockedTransactionsBlocked TransactionsCountAverageBlocked Transactions
aws_rds_BufferCacheHitRatioBuffer Cache Hit RatioPercentAverageBuffer Cache Hit Ratio
aws_rds_CommitThroughputCommit ThroughputCount/SecondAverageCommit Throughput
aws_rds_CommitLatencyCommit LatencyMillisecondsAverageCommit Latency
aws_rds_DDLLatencyDDL LatencyMillisecondsAverageDDL Latency
aws_rds_DeadlocksDeadlocksCountAverageDeadlocks
aws_rds_DMLThroughputDML ThroughputCount/SecondAverageDML Throughput
aws_rds_DMLLatencyDML LatencyMillisecondsAverageDML Latency
aws_rds_LoginFailuresLogin FailuresCountAverageLogin Failures
aws_rds_ResultSetCacheHitRatioResult Set Cache Hit RatioPercentAverageResult Set Cache Hit Ratio
aws_rds_ReplicaLagMaximumReplica Lag MaximumMillisecondsAverageReplica Lag Maximum
aws_rds_AuroraReplicaLagMaximumAurora Replica Lag MaximumMillisecondsAverageAurora Replica Lag Maximum
aws_rds_AuroraReplicaLagMinimumAurora Replica Lag MinimumMillisecondsAverageAurora Replica Lag Minimum
aws_rds_SelectThroughputSelect ThroughputCount/SecondAverageSelect Throughput
aws_rds_SelectLatencySelect LatencyMillisecondsAverageSelect Latency
aws_rds_VolumeReadIOPsVolume Read IOPSCountAverageVolume Read IOPS
aws_rds_VolumeWriteIOPsVolume Write IOPsCountAverageVolume Write IOPs
aws_rds_QueriesQueriesCount/SecondAverageQueries
aws_rds_AuroraBinlogReplicaLagAurora Binlog Replica LagSecondsAverageAurora Binlog Replica Lag
aws_rds_EngineUptimeEngine UptimeSecondsAverageEngine Uptime
aws_rds_InsertLatencyInsert LatencyMillisecondsAverageInsert Latency
aws_rds_InsertThroughputInsert ThroughputCount/SecondAverageInsert Throughput
aws_rds_UpdateLatencyUpdate LatencyMillisecondsAverageUpdate Latency
aws_rds_UpdateThroughputUpdate ThroughputCount/SecondAverageUpdate Throughput
aws_rds_DeleteLatencyDelete LatencyMillisecondsAverageDelete Latency
aws_rds_DeleteThroughputDelete ThroughputCount/SecondAverageDelete Throughput
aws_rds_NetworkThroughputNetwork ThroughputBytes/SecondAverageNetwork Throughput
aws_rds_BacktrackChangeRecordsCreationRateBacktrack Change Records Creation RateCountAverageBacktrack Change Records Creation Rate
aws_rds_BacktrackChangeRecordsStoredBacktrack Change Records StoredCountAverageBacktrack Change Records Stored
aws_rds_BacktrackWindowAlertBacktrack Window AlertCountAverageBacktrack Window Alert
aws_rds_ServerlessDatabaseCapacityServerlessDatabaseCapacityCountAverageServerless Database Capacity
aws_rds_FailedSQLServerAgentJobsCountFailedSQLServerAgentJobsCountCountAverageNumber 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.

External reference