Description: 

Amazon Redshift is a data warehouse service. It is a collection of computing resources called nodes, organized into a cluster called a cluster that gives information about connections and user activities in your database. The logs are stored in Amazon S3 buckets.

Rationale:

Amazon Redshift periodically performs maintenance to apply upgrades to your cluster. During these updates, your Amazon Redshift cluster isn't available for normal operations. Amazon Redshift assigns a 30-minute maintenance window at random from an 8-hour block of time per AWS Region, occurring on a random day of the week (Monday through Sunday, inclusive).

Impact:

If a maintenance event is scheduled for a given week, it starts during the assigned 30-minute maintenance window. While Amazon Redshift is performing maintenance, it terminates any queries or other operations that are in progress.

Default Value:

Amazon Redshift periodically performs maintenance Allow upgrade version is yes. 

Pre-requisites:

A Cluster should be available.


Remediation:

Test Plan

  1. Sign in to the Amazon Management Console

  2. Go to the Redshift dashboard at https://console.aws.amazon.com/redshiftv2/

  3. Click on Clusters, In the left navigation pane

  4. Select the Cluster.

  5.  Select the Maintenance Tab, by default the maintenance, it will Allow the version upgrade 

  6. We can check the maintenance details when it takes a version upgrade 

  7. If you need to reschedule your cluster’s maintenance window. 



Using AWS CLI:

To know about the redshift cluster maintenance if the allow version is enabled it will show as true

aws redshift describe-clusters


Implementation steps:

  1. Sign in to the Amazon Management Console

  2. Go to the Redshift dashboard at https://console.aws.amazon.com/redshiftv2/

  3. Click on Clusters, In the left navigation pane

  4. Select the Cluster.

  5.  Select the Maintenance Tab, and click on Edit on the right side 

  6. In the next window, change the date and time 


  • Current – Use the most current approved cluster version.

  • Trailing – Use the cluster version before the current version.

  • Preview – Use the cluster version that contains new features available for preview


7. Finally, click Save Changes 


Using AWS CLI:

To allow the version upgrade

aws redshift modify-cluster
--cluster-identifier <value>
--allow-version-upgrade

Backout plan:

  1. Sign in to the Amazon Management Console

  2. Go to the Redshift dashboard at https://console.aws.amazon.com/redshiftv2/

  3. Click on Clusters, In the left navigation pane 

  4. Select the Cluster.

  5. Select the Maintenance Tab, and click on Edit on the right side

  6. In the next window, change the date and time back to normal

  7. Finally, click Save Changes



Using AWS CLI:

To disable the version upgrade