AWS RDS monitoring integration

Access to this feature depends on your subscription level. Requires Infrastructure Pro.

New Relic Infrastructure's integrations include an integration for reporting your Amazon Web Services RDS data to New Relic products. This document explains how to activate this integration and describes the data that can be reported.

New Relic also offers an integration for enhanced RDS monitoring.

Features

Amazon's Relational Database Service (RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud. It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks.

New Relic Infrastructure's RDS monitoring integration gathers metric and configuration data for the relational databases associated with your Amazon RDS account. Your RDS data is available in pre-built dashboards and you can also create custom queries and charts in New Relic Insights. You can create alert conditions for RDS data, and use the reported data to plan for future RDS capacity.

Activate integration

To enable this integration:

  1. Make sure you have installed the Infrastructure agent before you activate AWS integrations from your Infrastructure account.
  2. Follow standard procedures to Connect AWS services to Infrastructure.

Configuration and polling

You can change the polling frequency and filter data using configuration options.

Default polling information for the AWS RDS integration:

  • New Relic polling interval: 5 minutes
  • Amazon CloudWatch data interval: 1 minute for RDS instances; 5 minutes for RDS clusters

Find and use data

To find your integration data in Infrastructure, go to infrastructure.newrelic.com > Integrations > Amazon Web Services and select one of the RDS integration links.

In New Relic Insights, data is attached to the DatastoreSample event type, with a provider value of RdsDbInstance for DB instances, or RdsDbCluster for Aurora DB clusters.

For more on how to use your data, see Understand and use integration data.

Metric data

This integration collects the following Amazon RDS cluster data:

Name Description
volumeBytesUsed Volume bytes used.
volumeReadIops

Volume read IOPs.

volumeWriteIops Volume write IOPs.

Inventory data

This integration supports the following RDS inventory data. For more about inventory data, see Understand integration data.

Name Description
allocatedStorage The storage space allocated to this instance, in gigabytes.
autoMinorVersionUpgrade Boolean. If true, indicates that minor version patches are applied to this instance automatically.
availabilityZone The RDS availability zone for this instance.
awsRegion The RDS region for this instance.
backupRetentionPeriod Count of the number of days RDS preserves automated backups for this instance.
caCertificateIdentifier The CA certificate for this instance.
dbInstanceClass The DB instance class for this instance.
dbInstancePort Integer representing the port where this instance listens for traffic. If the instance is part of a cluster, this port may not be the port assigned to the overall database cluster.
dbInstanceStatus The DB instance status for this instance.
dbName

The meaning of this configuration option depends on the database engine:

  • Amazon Aurora, MariaDB, MySQL, PostgreSQL, and SQL Server: Indicates the name specified when the instance was created.
  • Oracle: Indicates the Oracle System ID (SID) for this instance.
dbParameterGroups JSON string that lists DB parameter groups for this instance.
dbSecurityGroups JSON string that lists DB security groups for this instance. Only collects data from the DBSecurityGroup.Name and DBSecurityGroup.Status sub-elements.
dbSubnetGroup JSON string that lists details about the instance's DB subnet group, including the name and description for each subnet in the subnet group.
engine The name of the database engine running on this instance.
engineVersion The version identifier for the database engine running on this instance.
licenseModel The license identifier for the database engine running on this instance. For example, general-public-license.
multiAz Boolean. If true, indicates this instance is a multi-availability-zone deployment.
optionGroupMemberships JSON string that lists any option group memberships for this instance.
publiclyAccessible

Boolean. If true, indicates an Internet-facing instance with a publicly resolvable DNS name, which resolves to a public IP address.

If false, indicates an internal instance with a DNS name that resolves to a private IP address.

secondaryAvailabilityZone If present, indicates the name of the secondary availability zone for a multi-availability-zone deployment.
storageEncrypted Boolean. If true, indicates that the database on this instance is encrypted.
storageType Indicates the RDS storage type for this instance.
vpcSecurityGroups JSON string that lists the VPC security groups for this instance.

Instance data

New Relic collects RDS instance common metric, cluster instance, and stand-alone instance data.

RDS instance common metric data

Metric Description
cpuCreditUsage The number of CPU credits consumed during the specified period.
cpuCreditBalance The number of CPU credits that an instance has accumulated.
cpuUtilization

The percentage of CPU used by a DB instance.

databaseConnections

The number of connections to an instance.

diskQueueDepth The number of outstanding read/write requests waiting to access the disk.
freeableMemoryBytes

The amount of available random access memory, in bytes.

maximumUsedTransactionIDs The age of the oldest unvacuumed transaction ID, in transactions.
networkReceiveThroughput The amount of network throughput received from clients by each instance in the Aurora MySQL DB cluster, in bytes per second.
networkTransmitThroughput The amount of network throughput sent to clients by each instance in the Aurora DB cluster, in bytes per second.
readLatency

The average amount of time taken per disk I/O operation, in seconds.

readThroughput

The average number of bytes read from disk per second.

swapUsageBytes

The amount of swap space used on the Aurora PostgreSQL DB instance, in bytes.

transactionLogsDiskUsageBytes

The amount of disk space occupied by transaction logs on the Aurora PostgreSQL DB instance, in bytes.

RDS cluster instance data

Metric Description
activeTransactions

The average number of current transactions executing on an Aurora database instance per second.

auroraReplicaLag

For an Aurora Replica, the amount of lag when replicating updates from the primary instance, in milliseconds.

auroraReplicaLagMaximum

The maximum amount of lag between the primary instance and each Aurora DB instance in the DB cluster, in milliseconds.

auroraReplicaLagMinimum

The minimum amount of lag between the primary instance and each Aurora DB instance in the DB cluster, in milliseconds.

backtrackChangeRecordsCreationRate

The number of backtrack change records created over five minutes for your DB cluster.

backtrackChangeRecordsStored

The actual number of backtrack change records used by your DB cluster.

backtrackWindowActual

The difference between the target backtrack window and the actual backtrack window.

backtrackWindowAlert

The number of times that the actual backtrack window is smaller than the target backtrack window for a given period of time.

blockedTransactions

The average number of transactions in the database that are blocked per second.

bufferCacheHitRatio

The percentage of requests that are served by the buffer cache.

commitLatency

The amount of latency for commit operations, in milliseconds.

commitThroughput

The average number of commit operations per second.

ddlLatency

The amount of latency for data definition language (DDL) requests, in milliseconds—for example, create, alter, and drop requests.

ddlThroughput

The average number of DDL requests per second.

deadlocks

The average number of deadlocks in the database per second.

deleteLatency

The amount of latency for delete queries, in milliseconds.

deleteThroughput

The average number of delete queries per second.

dmlLatency

The amount of latency for inserts, updates, and deletes, in milliseconds.

dmlThroughput

The average number of inserts, updates, and deletes per second.

engineUptime

The amount of time that the instance has been running, in seconds.

failedSqlStatements

This metric, displayed under the SQL category of the latest metrics view in the Amazon RDS console, does not apply to Amazon Aurora.

freeLocalStorageBytes

The amount of storage available for temporary tables and logs, in bytes.

insertLatency

The amount of latency for insert queries, in milliseconds.

insertThroughput

The average number of insert queries per second.

loginFailures

The average number of failed login attempts per second.

networkThroughput The amount of network throughput both received from and transmitted to clients by each instance in the Aurora MySQL DB cluster, in bytes per second.
queries

The average number of queries executed per second.

rdsToAuroraPostgreSQLReplicaLag

The amount of lag in seconds when replicating updates from the primary RDS PostgreSQL instance to other nodes in the cluster.

resultSetCacheHitRatio

The percentage of requests that are served by the Resultset cache.

selectLatency The amount of latency for select queries, in milliseconds.
selectThroughput

The average number of select queries per second.

totalConnections Total number of connections to the database instance.
updateLatency

The amount of latency for update queries, in milliseconds.

updateThroughput The average number of update queries per second.
volumeReadIOPs

The number of billed read I/O operations from a cluster volume, reported at 5-minute intervals.

volumeWriteIOPs The number of write disk I/O operations to the cluster volume, reported at 5-minute intervals.

RDS stand-alone instance data

Metric Description
binLogDiskUsageBytes

The amount of disk space occupied by binary logs on the master, in bytes.

diskQueueDepth

The number of outstanding read/write requests waiting to access the disk.

freeStorageSpaceBytes

The amount of storage available for temporary tables and logs, in bytes.

maximumUsedTransactionIDs The age of the oldest unvacuumed transaction ID, in transactions.
oldestReplicationSlotLag Shows how far behind in seconds the most lagging replica is in terms of WAL data received.
readIops The average number of disk I/O operations per second.
readLatency

The average amount of time taken per disk I/O operation.

readThroughput

The average number of bytes read from disk per second.

replicaLag The amount of lag when replicating updates from the primary instance, in milliseconds.
replicationSlotDiskUsage The amount of disk space occupied by replication slots.
swapUsageBytes

The amount of swap space used on the Aurora PostgreSQL DB instance, in bytes.

transactionLogsDiskUsage

The amount of disk space occupied by transaction logs on the Aurora PostgreSQL DB instance.

transactionLogsGeneration

How much storage is being used for WAL data.

writeIops

The average number of disk I/O operations per second.

writeLatency

The average amount of time taken per disk I/O operation.

writeThroughput

The average number of bytes written to disk per second.

For more help

Recommendations for learning more: