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:DescribeClusters",
- "redshift:DescribeClusterParameters",
- "redshift:DescribeLoggingStatus",
- "redshift:DescribeEvents",
- "redshift:DescribeStorage"
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:
| Attribute | Description | Statistic | Data 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:
| Attribute | Description | Statistic | Data 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:
| Attribute | Description | Statistic | Data 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:
| Attribute | Description | Statistic | Data 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:
| Attribute | Description |
|---|---|
| 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. |