Posted On: Nov 26, 2019
The Amazon Redshift cluster elastic resize operation can now be automated using a scheduler that allows you to automatically resize clusters to accommodate changes in workloads that occur on a regular basis. For example, you can now automatically expand a cluster to accommodate heavier workloads as well as shrink a cluster to accommodate lighter workloads at specific times of day. This will allow you to automate cluster resizing to balance price and performance when using Redshift.
With the ability to schedule elastic resize operations, you can resize your Amazon Redshift cluster in minutes by adding nodes to get better performance for demanding workloads or by removing nodes to save cost. Additional nodes are added or removed in minutes with minimal disruption to on-going read and write queries. By creating your own schedule for these operations, you can further automate the operation and management of your Redshift cluster.
You can schedule resizing your cluster using the AWS Management Console or programmatically using the AWS CLI or API. This capability is included with Redshift release version 1.0.11262 or later. Refer to the AWS Region Table for Amazon Redshift availability.