Amazon Redshift Cluster - Pause and Resume - Series 9

Amazon Redshift Cluster - Pause and Resume - Series 8

Amazon Redshift Cluster - Pause and Resume - Series 7

Amazon Redshift Cluster - Pause and Resume - Series 6

 In this series, let us explore on 'Pause on Schedule' 'Resume on Schedule' option

• 'Pause on Schedule' or 'Resume on Schedule' is an option where in we can define 'Pause' & 'Resume' based on a cron schedule. For example, I can set for 'Pause' on end of day Friday or Weekend and set for 'Resume' by early Monday Morning or Beginning of the the week, as per the operational needs

 

 

• This comes handy, when we have non-prodcution clusters which can be set to 'Pause' state until it is needed later

• Quick catch is that, when we define 'Pause on Schedule' and if you have selected a 'Resume' window as well, then there are two different schedules that are created to handle the 'Pause' and 'Resume' each separately

Amazon Redshift Cluster - Pause and Resume - Series 5

Amazon Redshift Cluster - Pause and Resume - Series 4

Amazon Redshift Cluster - Pause and Resume - Series 3

Amazon Redshift Cluster - Pause and Resume - Series 2

 Let us create a Amazon Redshift Cluster and setup 'Pause & Resume'

1. Log in to the AWS console using your AWS account credentials
2. Go to the Amazon Redshift Console and create a cluster
3. Select the type/nodes of the cluster to be created, as per the requirements. As this is for demonstration, I have selected 'dc2.large' type with 1 Node for obvious reasons

Amazon Redshift - Select a Cluster as per the needs

      4.Now click on configure the cluster by specifying Cluster Name, Master User name,    password

      5.Watch the cluster being provisioned 

      6.Now available 

 Thus we created a Amazon Redshift Cluster Successfully

Amazon Redshift Cluster - Pause and Resume - Series 1

Amazon Redshift - How to fix commands ignored error

Amazon Redshift - How to fix commands ignored error

Amazon Redshift - How to fix query access error

Amazon Redshift - How to fix query access error

Amazon Redshift - Renaming the cluster identifier

Amazon Redshift - Renaming the cluster identifier