Amazon Redshift Monitoring Integration

Amazon redshift is a fully managed data warehouse in the AWS cloud that lets you run complex queries using SQL on large data sets. Using Site24x7's integration users can monitor and alert on their cluster's health and performance.

Setup and configuration

  • If you haven't done it already, please enable Site24x7 programmatic access to your AWS resources either by creating Site24x7 as an IAM user or by creating a cross-account IAM role between your AWS account and Site24x7's AWS account. Learn more
  • In the Integrate AWS Account page, ensure that the Redshift listing is checked under the Services to be discovered field. Learn more.

Policies and permission

To allow Site24x7 to access Redshift clusters and collect metric data, please assign the AWS managed policy ReadOnlyAccess to the Site24x7 entity or make sure the following read-level action is present in the custom IAM policy assigned to the Site24x7 entity(IAM user or IAM Role). Learn more.

  • redshift:Describe*: Lists all Redshift clusters and returns various cluster and database properties.

Polling interval

Site24x7 collects metric data as per the poll frequency set (1 minute to a day). Learn more.

IT Automations

You can add automations for the AWS services supported by Site24x7. Log in to Site24x7 and go to Admin > IT Automation Templates (+) > Add Automation Templates. Once automations are added, you can schedule them to be executed one after the other.

You can now reboot Redshift clusters using Amazon Redshift automations.

Licensing

  • Each Redshift cluster is considered a basic monitor.
  • Each compute node provisioned in your cluster is considered a basic monitor.

Supported Metrics

Cluster

The following metrics are collected at a cluster level:

AttributeDescriptionStatisticData type
CPU utilization Measures the aggregate CPU usage across all nodes in a cluster. Average Percent
Database connections Measures the number of database connections to a cluster. Sum Count
Maintenance mode Indicates whether the cluster is in maintenance mode. Possible values are 0 and 1.  - Boolean

Node

The following metrics are collected on a per node basis:

AttributeDescriptionStatisticData type
Read IOPS Measures the number of disk read operations per second. Average Count/second
Read Latency Measures the amount of time taken for disk read I/O operations. Average Seconds
Read throughput Measures the average number of bytes read from disk per second. Average MB/s
Write IOPS Measures the average number of disk write operations per second. Average Count/second
Write latency Measures the amount of time taken for disk write I/O operations. Average Seconds
Write throughput Measures number of bytes written to disk per second Average MB/s

Cluster and Node

The following metrics are collected both at a cluster and node level:

AttributeDescriptionStatisticData type
Network receive throughput Measures the rate at which the node or cluster receives data. Average MB/s
Network transmit throughput Measures the rate at which the node or cluster writes data. Average MB/s
Percentage disk space used Measures the percent of disk space used. Average Percent

Database

The following metrics are collected at a database level:

AttributeDescriptionStatisticData type
Query completed per second Measures the number of queries completed per second.(reported as a 5 minute aggregate) Average Count/second
Query duration Measures the amount of time taken to complete a query. Average Seconds
Query runtime breakdown Measures the amount of time active queries have spent in various stages of execution. Average Seconds

To view data

  • Sign in to the Site24x7 console. Select AWS from the left navigation pane. Choose the monitored AWS account.
  • Choose Redshift Cluster (or) Redshift Node from the menu dropdown.
  • From the list of monitored clusters or nodes, choose the Redshift component for which you want to view metrics for.

Metadata

The following information about the cluster's state and configuration are collected:

AttributeDescription
Cluster Name The unique identifier of the cluster. 
Number of Nodes The pending or in-progress change of the number of nodes in the cluster. 
Availability Zone The name of the Availability Zone in which the cluster is located. 
Create Time The date and time the cluster was created. 
Cluster Version The pending or in-progress change of the service version. 
VPC ID The indentifer of the VPC the cluster is in.  
Cluster Subnet Group The name of the subnet group that is associated with the cluster. 
Cluster Parameter Groups The list of cluster parameter groups that are associated with the cluster. 
Parameter Group Apply Status The status of the parameter that indicates whether the parameter is in sync.
Enhanced VPC Routing The option specifies whether enhanced VPC routing is enabled or not. Possible values: true or false.
IAM Roles A list of AWS IAM roles that can be used by the cluster to access other AWS services. 
VPC security groups A list of Amazon VPC security groups that are associated with the cluster. 
Database Name The name of the initial database that was created when the cluster was created.
Endpoint address A list of Amazon VPC security groups that are associated with the cluster.
Endpoint port The DNS address of the cluster.
Encrypted The encryption type for a cluster. Possible values are KMS and none. 
Publicly Accessible Indicates whether the cluster can be accessed from a public network. Possible values: true or false.
Node type The node type for the nodes in the cluster.
CPU The number of virtual CPUs for each node.
Memory The amount of memory in gibibytes(GiB) for each node.
Storage The capacity and type of storage for each node.
Data Retention Period The number of days the automatic cluster snapshots are retained.
Preferred Maintenance Window The weekly time range during which system maintenance can occur.
Allow Version Upgrade Indicates whether major version upgrades will be applied automatically to the cluster. Possible values: true or false.
Was this document helpful?
Thanks for taking the time to share your feedback. We’ll use your feedback to improve our online help resources.