You are here

Integrations

AWS - RDS CloudWatch

Download version    6.0    5.x

Included in Opsview Monitor 5.x
Included in Opsview Monitor 6.0
check_circle
Opsview Supported

AWS - RDS CloudWatch Opspack

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 cloud. It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks in AWS.

What Can You Monitor

Opsview Monitor's AWS RDS Opspack provides all the latest metrics to track RDS performance. Service checks included in the Opspack help you identify problem areas in the database such as storage space, IO, throughput and latency issues. Utilize this performance data to correlate information across your AWS environment and build dashboards to share with the team.

Service Checks

Service Check Description
AWS/RDS.BinLogDiskUsage The amount of disk space occupied by binary logs on the master
AWS/RDS.CPUUtilization The percentage of CPU utilization
AWS/RDS.CPUCreditUsage Must be T2 instance. The number of CPU credits consumed by the instance
AWS/RDS.CPUCreditBalance Must be T2 instance. The number of CPU credits available for the instance to burst beyond its base CPU utilization
AWS/RDS.DatabaseConnections The number of database connections in use
AWS/RDS.DiskQueueDepth The number of outstanding IOs (read/write requests) waiting to access the disk
AWS/RDS.FreeableMemory The amount of available random access memory
AWS/RDS.FreeStorageSpace The amount of available storage space
AWS/RDS.ReplicaLag The amount of time a Read Replica DB instance lags behind the source DB instance
AWS/RDS.SwapUsage The amount of swap space used on the DB instance
AWS/RDS.ReadIOPS The average number of disk I/O operations per second
AWS/RDS.WriteIOPS The average number of disk I/O operations per second
AWS/RDS.ReadLatency The average amount of time taken per disk I/O operation
AWS/RDS.WriteLatency The average amount of time taken per disk I/O operation
AWS/RDS.ReadThroughput The average number of bytes read from disk per second
AWS/RDS.WriteThroughput The average number of bytes written to disk per second
AWS/RDS.NetworkReceiveThroughput The 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 The outgoing (Transmit) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication

AWS - RDS CloudWatch Opspack

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 cloud. It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks in AWS.

What Can You Monitor

Opsview Monitor's AWS RDS Opspack provides all the latest metrics to track RDS performance. Service checks included in the Opspack help you identify problem areas in the database such as storage space, IO, throughput and latency issues. Utilize this performance data to correlate information across your AWS environment and build dashboards to share with the team.

Note: This Opspack knows when it was last run, so when testing the results in the troubleshoot section, you will need to wait a couple minutes each time you recheck the results. The time frame that is searched for is based around the last time the Opspack ran, so running it too quickly will result in no data being found and the service check going into an unknown

Service Checks

Service Check Description
AWS/RDS.BinLogDiskUsage The amount of disk space occupied by binary logs on the master
AWS/RDS.CPUUtilization The percentage of CPU utilization
AWS/RDS.CPUCreditUsage Must be T2 instance. The number of CPU credits consumed by the instance
AWS/RDS.CPUCreditBalance Must be T2 instance. The number of CPU credits available for the instance to burst beyond its base CPU utilization
AWS/RDS.DatabaseConnections The number of database connections in use
AWS/RDS.DiskQueueDepth The number of outstanding IOs (read/write requests) waiting to access the disk
AWS/RDS.FreeableMemory The amount of available random access memory
AWS/RDS.FreeStorageSpace The amount of available storage space
AWS/RDS.ReplicaLag The amount of time a Read Replica DB instance lags behind the source DB instance
AWS/RDS.SwapUsage The amount of swap space used on the DB instance
AWS/RDS.ReadIOPS The average number of disk I/O operations per second
AWS/RDS.WriteIOPS The average number of disk I/O operations per second
AWS/RDS.ReadLatency The average amount of time taken per disk I/O operation
AWS/RDS.WriteLatency The average amount of time taken per disk I/O operation
AWS/RDS.ReadThroughput The average number of bytes read from disk per second
AWS/RDS.WriteThroughput The average number of bytes written to disk per second
AWS/RDS.NetworkReceiveThroughput The 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 The outgoing (Transmit) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication

Notes

This Opspack knows when it was last run, so when testing the results in the troubleshoot section, you will need to wait a couple minutes each time you recheck the results. The time frame that is searched for is based around the last time the Opspack ran, so running it too quickly will result in no data being found and the service check going into an unknown.

Prerequisites

There are two ways of adding your authentication credentials to the host. We recommend adding the access key and secret key directly using the variable 'AWS_CLOUDWATCH_AUTHENTICATION'. You can also add the access key and secret key to a file (default /usr/local/nagios/etc/aws_credentials.cfg) in the following format:

[default]
aws_access_key_id = "Your Access Key Id"
aws_secret_access_key = "Your Secret Key Id"

Setup and Configuration

Step 1: Add the host template and the 'Cloud - AWS - RDS CloudWatch' Opspack to the host running the RDS software.

Add host template

Step 2: Add and configure the host Variables tab, add in 'AWS_CLOUDWATCH_AUTHENTICATION' with either the file location or the access key and secret key depending on your preferred way of supplying the access credential. Add the region you hosted in. Then add and configure the 'AWS_RDS_DB_INSTANCE_IDENTIFIER' by adding the instance name.

Add variable

Step 3: Reload and view the RDS statistics

View output

Prerequisites

To be able to monitor AWS CloudWatch services you need to add your AWS credentials to your Opsview Monitor server.

We recommend adding your AWS Access Key ID and AWS Secret Key ID to the default location:

/opt/opsview/monitoringscripts/etc/plugins/cloud-aws/aws_credentials.cfg

This credentials file should be in the following format:

[default]
aws_access_key_id = "Your Access Key Id"
aws_secret_access_key = "Your Secret Key Id"

If you are not using the default path, you will then need to assign your path to the variable: AWS_CLOUDWATCH_AUTHENTICATION.

Setup and Configuration

To configure and utilize this Opspack, you need to add the 'Cloud - AWS - RDS CloudWatch' Opspack to your Opsview Monitor system

Step 1: Add the host template

Add host template

Step 2: Add and configure the variables for the host

  • AWS_CLOUDWATCH_AUTHENTICATION - Contains either the file location created earlier (recommended method) or add the Access Key and Secret Key directly to this variable's values.

  • Override the Region value if you are not using the default

Add credentials variable

  • AWS_RDS_DB_INSTANCE_IDENTIFIER - RDS Instance name from AWS

Add RDS DB variable

Step 3: Reload and view the RDS statistics

View output

v1.0-opsview-5

ODI-309 - AWS Cloudwatch Opspacks

Initial release for AWS Cloudwatch Opspacks

v2.0-opsview-6

ODI-1154 Release Opspacks for Opsview Monitor 6.0

Initial release of Opspack to work with Opsview Monitor 6.0