Managing clusters using the console

To view clusters

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. On the navigation menu, choose CLUSTERS. The clusters for your account in the current AWS Region are listed. A subset of properties of each cluster is displayed in columns in the list. If you don't have any clusters, choose Create cluster to create one.

3. Choose the cluster name in the list to view more details about a cluster.

To create a cluster

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. On the navigation menu, choose CLUSTERS. The clusters for your account in the current AWS Region are listed. A subset of properties of each cluster is displayed in columns in the list.

3. Choose Create cluster to create a cluster.

4. Follow the instructions on the console page to enter the properties for Cluster configuration.

   Choose one of the following methods to size your cluster:

   Note

   The following step describes an Amazon Redshift console that is running in an AWS Region that supports RA3 node types. For a list of AWS Regions that support RA3 node types, see Overview of RA3 node types in the Amazon Redshift Cluster Management Guide.

   • If your AWS Region supports RA3 node types, choose either Production or Free trial to answer the question What are you planning to use this cluster for?

     If your organization is eligible, you might be able to create a cluster under the Amazon Redshift free trial program. To do this, choose Free trial to create a configuration with the dc2.large node type. For more information about choosing a free trial, see Amazon Redshift free trial.

   • If you don't know how large to size your cluster, choose Help me choose. Doing this starts a sizing calculator that asks you questions about the size and query characteristics of the data that you plan to store in your data warehouse.

     If you know the required size of your cluster (that is, the node type and number of nodes), choose I'll choose. Then choose the Node type and number of Nodes to size your cluster for the proof of concept.

5. Follow the instructions on the console page to enter the properties for Cluster details.

   Note

   If you are behind a firewall, the database port must be an open port that accepts inbound connections.

6. (Optional) Follow the instructions on the console page to enter properties for Cluster permissions. Provide cluster permissions if your cluster needs to access other AWS services for you, for example to load data from Amazon S3.

7. Choose Create cluster to create the cluster. The cluster might take several minutes to be ready to use.

To create a cluster by using a quick launch cluster

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

   Important

   If you use IAM user credentials, make sure that the user has the necessary permissions to perform the cluster operations. For more information, see Controlling access to IAM users in the Amazon Redshift Cluster Management Guide.

2. Choose the AWS Region where you want to create the cluster, for example US West (Oregon).

3. On the Amazon Redshift dashboard, choose Quick launch cluster.

4. On the Cluster specifications page, enter the following values and then choose Launch cluster:

   • Node type: Choose dc2.large.

   • Number of compute nodes: Keep the default value of 2.

   • Master user name: Keep the default value of awsuser.

   • Master user password and Confirm password: Enter a password for the master user account.

   • Database port: Accept the default value of 5439.

   • Available IAM roles: Choose myRedshiftRole.

   A confirmation page appears. The cluster takes a few minutes to be created. Choose Close to return to the list of clusters.

5. On the Clusters page, choose the cluster that you just launched and review the Cluster Status information. Make sure that Cluster Status is available and Database Health is healthy before you try to connect to the database.

   

To create a cluster by using a launch cluster

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. Choose Launch Cluster.

3. On the Cluster Details page, specify values for the following options, and then choose Continue.

   Cluster Identifier

   Type a unique name for your cluster.

   Cluster identifiers must meet the following conditions:

   • They must contain 1–63 alphanumeric characters or hyphens.

   • Alphabetic characters must be lowercase.

   • The first character must be a letter.

   • They can't end with a hyphen or contain two consecutive hyphens.

   • They must be unique for all clusters within an AWS account.

   Database Name

   Type a name if you want to create a database with a custom name (for example, mydb). This field is optional. A default database named dev is created for the cluster whether or not you specify a custom database name.

   Database names must meet the following conditions:

   • They must contain 1–64 alphanumeric characters.

   • They must contain only lowercase letters.

   • A database name can't be a reserved word. For more information, see Reserved Words in the Amazon Redshift Database Developer Guide.

   Database Port

   Type a port number through which you plan to connect from client applications to the database. The port number must be included in the connection string when opening JDBC or ODBC connections to the databases in the cluster.

   The port number must meet the following conditions:

   • It must contain only numeric characters.

   • It must fall in the range 1150–65535. The default port is 5439.

   • It must specify an open port that accepts inbound connections, if you are behind a firewall.

   Master User Name

   Type an account name for the master user of the database.

   Master user names must meet the following conditions:

   • They must contain 1–128 alphanumeric characters.

   • The first character must be a letter.

   • A master user name can't be a reserved word. For more information, see Reserved Words in the Amazon Redshift Database Developer Guide.

   Master User Password and Confirm Password

   Type a password for the master user account, and then retype it to confirm the password.

   It can use any ASCII characters with ASCII codes 33–126, except ' (single quote), " (double quote), \, /, or @.

   In the following screenshot, examplecluster is the cluster identifier, no custom database name is specified, 5439 is the port, and masteruser is the master user name.

   

4. On the Node Configuration page, specify values for the following options, and then choose Continue.

   Node Type

   Choose a node type. When you choose a node type, the page displays information that corresponds to the selected node type, such as CPU, Memory, Storage, and I/O Performance.

   Cluster Type

   Choose a cluster type. When you do, the maximum number of compute nodes for the selected node and cluster type appears for Maximum, and the minimum number appears for Minimum.

   If you choose Single Node, you have one node that shares leader and compute functionality.

   If you choose Multi Node, specify the number of compute nodes that you want for the cluster in Number of Compute Nodes.

   In the following screenshot, the dc1.large node type is selected for a Multi Node cluster with two compute nodes.

   

5. On the Additional Configuration page, specify values for the following options, and then choose Continue.

   1. For Provide the optional additional configuration details below, configure the following options:

      Cluster Parameter Group

      Choose a cluster parameter group to associate with the cluster. If you don't choose one, the cluster uses the default parameter group.

      Encrypt Database

      Choose whether you want to encrypt all data within the cluster and its snapshots. If you leave the default setting, None, encryption is not enabled. If you want to enable encryption, choose whether you want to use AWS Key Management Service (AWS KMS) or a hardware security module (HSM), and then configure the related settings. For more information about encryption in Amazon Redshift, see Amazon Redshift database encryption.

      • KMS

        Choose KMS if you want to enable encryption and use AWS KMS to manage your encryption key. In Master Key, choose (default) aws/redshift to use a default customer master key (CMK) or choose another key from your AWS account.

        Note

        If you want to use a key from another AWS account, choose Enter a key ARN from Master Key. Then type the Amazon Resource Name (ARN) for the key to use. You must have permission to use the key. For more information about access to keys in AWS KMS, see Controlling access to your keys in the AWS Key Management Service Developer Guide.

        For more information about using AWS KMS encryption keys in Amazon Redshift, see Database encryption for Amazon Redshift using AWS KMS.

      • HSM

        Choose HSM if you want to enable encryption and use a hardware security module (HSM) to manage your encryption key.

        If you choose HSM, choose values from HSM Connection and HSM Client Certificate. These values are required for Amazon Redshift and the HSM to form a trusted connection over which the cluster key can be passed. The HSM connection and client certificate must be set up in Amazon Redshift before you launch a cluster. For more information about setting up HSM connections and client certificates, see Encryption for Amazon Redshift using hardware security modules.

   2. For Configure Networking Options, you configure whether to launch your cluster in a virtual private cloud (VPC) or outside a VPC. The option you choose affects the additional options available in this section. Amazon Redshift uses the EC2-VPC and EC2-Classic platforms to launch clusters. Your AWS account determines which platform or platforms are available to you for your cluster. For more information, see Supported platforms in the Amazon EC2 User Guide for Linux Instances.

      Choose a VPC

      • To launch your cluster in a virtual private cloud (VPC), choose the VPC you want to use. You must have at least one Amazon Redshift subnet group set up to use VPCs. For more information, see Amazon Redshift cluster subnet groups.

        

      • To launch your cluster outside a VPC, choose Not in VPC. This option is available only to AWS accounts that support the EC2-Classic platform. Otherwise, you must launch your cluster in a VPC.

        

      Cluster Subnet Group

      Select the Amazon Redshift subnet group in which to launch the cluster.

      Note

      This option is available only for clusters in a VPC.

      Publicly Accessible

      Choose Yes to enable connections to the cluster from outside of the VPC in which you launch the cluster. Choose No if you want to limit connections to the cluster from only within the VPC.

      Note

      This option is available only for clusters in a VPC.

      Choose a Public IP Address

      If you set Publicly Accessible to Yes, choose No here to have Amazon Redshift to provide an Elastic IP (EIP) for the cluster. Alternatively, choose Yes if you want to use an EIP that you have created and manage. If you have Amazon Redshift create the EIP, it is managed by Amazon Redshift.

      Note

      This option is available only for clusters in a VPC where Publicly Accessible is Yes.

      Elastic IP

      Select the EIP that you want to use to connect to the cluster from outside of the VPC.

      Note

      This option is available only for clusters in a VPC where Publicly Accessible and Choose a Public IP Address are Yes.

      Availability Zone

      Choose No Preference to have Amazon Redshift choose the Availability Zone that the cluster is created in. Otherwise, choose a specific Availability Zone.

      Enhanced VPC Routing

      Choose Yes to enable enhanced VPC routing. Enhanced VPC routing might require some additional configuration. For more information, see Amazon Redshift enhanced VPC routing.

   3. For Optionally, associate your cluster with one or more security groups, specify values for the following options:

      VPC Security Groups

      Choose a VPC security group or groups for the cluster. By default, the chosen security group is the default VPC security group. For more information about VPC security groups, see Security groups for your VPC in the Amazon VPC User Guide.

      Note

      This option is only available if you launch your cluster in the EC2-VPC platform.

      

      Cluster Security Groups

      Choose an Amazon Redshift security group or groups for the cluster. By default, the chosen security group is the default security group. For more information about cluster security groups, see Amazon Redshift cluster security groups.

      Note

      This option is only available if you launch your cluster in the EC2-Classic platform.

      

   4. For Optionally create a basic alarm for this cluster, configure the following options, and then choose Continue:

      Create CloudWatch Alarm

      Choose Yes if you want to create an alarm that monitors the disk usage of your cluster, and then specify values for the corresponding options. Choose No if you don't want to create an alarm.

      Disk Usage Threshold

      Choose a percentage of average disk usage that has been reached or exceeded at which the alarm should trigger.

      Use Existing Topic

      Choose No if you want to create a new Amazon Simple Notification Service (Amazon SNS) topic for this alarm. In the Topic box, edit the default name if necessary. For Recipients, type the email addresses for any recipients who should receive the notification when the alarm triggers.

      

      Choose Yes if you want to choose an existing Amazon SNS topic for this alarm, and then in the Topic list, choose the topic that you want to use.

      

   5. For Optionally, select your maintenance track for this cluster, choose Current or Trailing.

      If you choose Current, your cluster is updated with the latest approved release during your maintenance window. If you choose Trailing, your cluster is updated with the release that was approved previously.

      

6. On the Review page, review the details of the cluster. If everything is satisfactory, choose Launch Cluster to start the creation process. Otherwise, choose Back to make any necessary changes, and then choose Continue to return to the Review page.

   Note

   Some cluster properties, such as the values for Database Port and Master User Name, cannot be modified later. If you need to change them, choose Back to change them now.

   The following screenshot shows a summary of various options chosen during the cluster launch process.

   

7. After you initiate the creation process, choose Close. The cluster might take several minutes to be ready to use.

   

   You can monitor the status of the operation in the performance dashboard.

To modify a cluster

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. On the navigation menu, choose CLUSTERS.

3. Choose the cluster to modify.

4. For Actions, choose Modify. The Modify cluster page appears.

5. Update the cluster properties. Some of the properties you can modify are:

   • Cluster identifier

   • VPC security groups

   • Enhanced VPC routing

   • Parameter groups

   • Encryption

   • Maintenance window

   • Maintenance track

   • Defer maintenance window

   • Snapshot retention

6. Choose Modify cluster.

To modify a cluster

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. In the navigation pane, choose Clusters, and then choose the cluster that you want to modify.

   

3. On the Configuration tab of the cluster details page, choose Cluster, and then choose Modify.

   

4. In the Modify Cluster window, change your cluster, and then choose Modify. The resulting window shows the options available to modify a cluster. Including tabs with options to update Cluster settings, Maintenance settings, and Snapshot settings.

To set a maintenance track for a cluster

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. In the navigation pane, choose Clusters, and then choose the cluster that you want to modify.

3. Choose the Maintenance settings tab.

4. Choose either Current or Trailing.

5. Choose Modify.

To defer the maintenance window

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. In the navigation pane, choose Clusters, and then choose the cluster that you want to modify.

3. Choose the Maintenance settings tab.

4. Choose Defer maintenance and set the date and time to defer maintenance.

5. Choose Modify.

To delete a cluster

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. On the navigation menu, choose CLUSTERS.

3. Choose the cluster to delete.

4. For Actions, choose Delete. The Delete cluster page appears.

5. Choose Delete cluster.

To delete a cluster

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. In the navigation pane, choose Clusters, and then choose the cluster that you want to delete.

   

3. On the Configuration tab of the cluster details page, choose Cluster, and then choose Delete.

4. In the Delete Cluster dialog box, do one of the following:

   • In Create snapshot, choose Yes to delete the cluster and take a final snapshot. In Snapshot name, type a name for the final snapshot, and then choose Delete.

     

   • In Create snapshot, choose No to delete the cluster without creating a final snapshot, and then choose Delete.

   After you initiate the delete of the cluster, it can take several minutes for the cluster to be deleted. You can monitor the status in the cluster list as shown in the following screenshots. If you requested a final snapshot, Cluster Status shows final-snapshot before deleting.

   The following screenshot shows the cluster with a status of final-snapshot before it is deleted.

   

   The following screenshot shows the cluster with a status of deleting.

   

   When the process has finished, you can verify that the cluster has been deleted because it no longer appears in the list of clusters on the Clusters page.

To reboot a cluster

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. On the navigation menu, choose CLUSTERS.

3. Choose the cluster to reboot.

4. For Actions, choose Reboot cluster. The Reboot cluster page appears.

5. Choose Reboot cluster.

To reboot a cluster

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. In the navigation pane, choose Clusters, and then choose the cluster that you want to reboot.

3. On the Configuration tab of the cluster details page, choose Cluster and then choose Reboot.

4. In the Reboot Clusters window, confirm that you want to reboot this cluster, and then choose Reboot.

   It can take several minutes for the cluster to be available. You can monitor the status of the reboot in the cluster list as shown in the following screenshot.

   

To resize a cluster

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. On the navigation menu, choose CLUSTERS.

3. Choose the cluster to resize.

4. For Actions, choose Resize. The Resize cluster page appears.

5. Follow the instructions on the page. You can resize the cluster now, once at a specific time, or increase and decrease the size of your cluster on a schedule.

6. Depending on your choices, choose Resize now or Schedule resize.

To resize a cluster

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. In the navigation pane, choose Clusters, and then choose the cluster that you want to resize.

   

3. On the Configuration tab of the cluster details page, choose Cluster, and then choose Resize.

4. In the Resize Clusters window, configure the resize parameters including the Node Type, Cluster Type, and Number of Nodes, and then choose Resize.

   

   You can monitor the progress of the resize on the Status tab.

   

   You can cancel a classic resize before it's complete by choosing cancel resize on the cluster list.

   

To upgrade a cluster to a new release version

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. On the navigation menu, choose CLUSTERS.

3. Choose the cluster to upgrade.

4. For Actions, choose Upgrade cluster version. The Upgrade cluster version page appears.

5. Follow the instructions on the page.

6. Choose Upgrade cluster version.

To upgrade your cluster to a new release version

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. In the navigation pane, choose Clusters, and then choose the cluster that you want to upgrade.

3. On the Clusters tab, choose Cluster, and then choose Upgrade release version.

4. In the Upgrade window, you can view version numbers of the Current release and New release, a link to details about the Cluster version history, and the Maintenance window schedule. If you choose Yes, Upgrade now, you must acknowledge that the cluster is offline during the upgrade. Otherwise, you can Never mind, upgrade in my maintenance window.

   When the upgrade completes, you can see the new status in the Release status column.

To display information about a cluster

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. On the navigation menu, choose CLUSTERS, then choose the cluster name from the list to open its details. The details of the cluster are displayed, including Cluster performance, Query monitoring, Maintenance and monitoring, Backup, Properties, and Schedules tabs.

3. Choose each tab to view more details.

To get cluster configuration details

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. In the navigation pane, choose Clusters, and then choose the cluster for which you want to view configuration information.

   

3. On the Configuration tab of the cluster details page, review the configuration information. You can view information about the cluster properties, status, database, capacity, backup, audit logging, maintenance, and SSH ingestion settings.

To view the status of a cluster

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. On the navigation menu, choose CLUSTERS.

3. View the status of the cluster in the Status column.

To get an overview of cluster status

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. In the navigation pane, choose Clusters, and then choose the cluster for which you want to view status information.

   

3. Choose the Status tab.

   The status summary page is displayed as shown in the following screenshot.

   

To create a snapshot of a cluster

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. On the navigation menu, choose CLUSTERS.

3. Choose the cluster for which to create a snapshot.

4. For Actions, choose Create snapshot. The Create snapshot page appears.

5. Follow the instructions on the page.

6. Choose Create snapshot.

To create a snapshot of a cluster

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. In the navigation pane, choose Clusters, and then choose the cluster for which you want to take a snapshot.

   

3. On the Configuration tab of the cluster details page, choose Backup, and then choose Take Snapshot.

   

4. In the Create Snapshot dialog box, do the following:

   1. In the Cluster Identifier box, choose the cluster that you want to take a snapshot of.

   2. In the Snapshot Identifier box, enter a name for the snapshot.

   

5. Choose Create.

   To view details about the snapshot taken and all other snapshots for your AWS account, see the snapshots section of the Amazon Redshift console. For more information, see Managing snapshots using the console.

To create a disk space usage alarm for a cluster

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. On the navigation menu, choose ALARMS.

3. For Actions, choose Create alarm. The Create alarm page appears.

4. Follow the instructions on the page.

5. Choose Create alarm.

To edit the default disk space alarm

1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshift/.

2. In the navigation pane, choose Clusters, and then choose the cluster associated with the alarm that you want to edit.

3. Choose the Status tab.

4. In the CloudWatch Alarms section, choose the alarm that you want to edit.

   The default disk space alarm that was created when you launched your cluster is named percentage-disk-space-used-default-<string>. The string is randomly generated by Amazon Redshift.

   

5. In the Edit Alarm window, edit any values that you want to change, such as the percentage or minutes.

   

6. To change the Amazon SNS topic that the alarm is associated with, do one of the following:

   • If you want to choose another existing topic, choose a topic from the Send a notification to list.

   • If you want to create a new topic, choose create topic and specify a new topic name and the email addresses for recipients.

7. Choose Save.