Skip to content

Latest commit

 

History

History
105 lines (78 loc) · 5.83 KB

README.md

File metadata and controls

105 lines (78 loc) · 5.83 KB

Lab 7 - Amazon Redshift Operations

In this lab, we step through some common operations a Redshift Administrator may have to do to maintain their Redhshift environment.

Contents

Before You Begin

This lab assumes you have launched a Redshift cluster. If you have not launched a cluster, see LAB 1 - Creating Redshift Clusters.

Event Subscriptions

  1. Navigate to your Redshift Events page. Notice the Events involved with creating the cluster.
https://console.aws.amazon.com/redshift/home?#events:cluster=
  1. Click on the Subscriptions tab and then click on the Create Event Subscription button.
  1. Create a subscription for any severity management notification on any cluster. Notice the types of event on the right you will recieve a notification for.
  1. Name the subscription ClusterManagement and click Next.
  1. Select the Create New Topic tab and enter the topic name ClusterManagement. Add your email address and click Add Recipient. Finally, click Create.
  1. You will recieve an email shortly. Click on the Confirm subscription link in the email.
  1. The link should take you to a final confirmation page confirming the subscription.

Cluster Encryption

Note: This portion of the lab will take ~45 minutes to complete based on the data loaded in LAB 2 - Creating Redshift Clusters. Please plan accordingly.

  1. Navigate to your Redshift Cluster list. Select your cluster and click on Cluster -> Modify Cluster.
https://console.aws.amazon.com/redshift/home?#cluster-list
  1. Select KMS for the database encryption and then click Modify.
  1. Notice your cluster enters a resizing status. The process of encrypting your cluster is similar to resizing your cluster using the classic resize method. All data is read, encrypted and re-written. During this time, the cluster is still avialable for read queries, but not write queries.
  1. You should also receive an email notification about the cluster resize because of the event subscription we setup earlier.

Cross Region Snapshots

  1. Navigate to your Redshift Cluster list. Select your cluster and click on Backup -> Configure Cross-region snapshots.
https://console.aws.amazon.com/redshift/home?#cluster-list
  1. Select the Yes radio button to enable the copy. Select the destination region of us-east-2. Because the cluster is encrypted you must establish a grant in the other region to allow the snapshot to be re-encrypted. Select No for the Existing Snapshot Copy Grant. Name the Snapshot Copy Grant with the value SnapshotGrant.
  1. To demonstrate the cross-region replication, initiate a manual backup. Click on Backup -> Take Snapshot.
  1. Name the snapshot CRRBackup and click Create.
  1. Navigate to your list of snapshots and notice the snapshot is being created.
https://console.aws.amazon.com/redshift/home?#snapshots:id=;cluster=
  1. Wait for the snapshot to finish being created. The status will be available.
  1. Navigate to the us-east-2 region by select Ohio from the region drop down, or navigate to the following link. Notice that the snapshot is available and is in a copying status.
https://us-east-2.console.aws.amazon.com/redshift/home?region=us-east-2#snapshots:id=;cluster=

Elastic Resize

Note: This portion of the lab will take ~15 minutes to complete based on the data loaded in LAB 2 - Creating Redshift Clusters. Please plan accordingly.

  1. Navigate to your Redshift Cluster list. Select your cluster and click on Cluster -> Resize. Note, if you don't see your cluster, you may have to change the Region drop-down.
  1. Ensure the Elastic Resize radio is selected. Choose the New number of nodes, and click Resize.
  1. When the resize operation begins, you'll see the Cluster Status of prep-for-resize.
  1. When the operation completes, you'll see the Cluster Status of available again.

Before You Leave

If you are done using your cluster, please think about decommissioning it to avoid having to pay for unused resources.