Step 2: Creating a Cluster

Before using GaussDB(DWS) to execute data analysis tasks, you need to create a data warehouse cluster. A cluster consists of multiple nodes in the same subnet. These nodes together provide services. To create a cluster, perform the following steps:

Creating a Cluster

  1. Log in to the GaussDB(DWS) management console.
  2. In the navigation pane on the left, choose Cluster Management. On the displayed page, click Buy DWS Cluster in the upper right corner.
  3. Select the region to which the cluster to be created belongs.

    • Region: Select CN North-Beijing4.
    • AZ: Use the default value.

  4. Configure node-related parameters.

    • Cluster Type: Select Standard.
    • CPU Architecture: Select x86.
    • Node Flavor: Retain the default value.
    • Nodes: Retain the default value. At least 3 nodes are required.
    Figure 1 Configuring node-related parameters

  5. Configure cluster-related parameters.

    • Cluster Name: Enter dws-demo.
    • Administrator Account: The default value is dbadmin. Use the default value. After a cluster is created, the client uses this administrator account and its password to connect to the cluster's database.
    • Administrator Password: Enter the password.
    • Confirm Password: Enter the administrator password again.
    • Database Port: Use the default port number. This port is used by the client or application to connect to the cluster's database.
    Figure 2 Configuring the cluster

  6. Configure network parameters.

    • VPC: You can select an existing VPC from the drop-down list. If no VPC has been configured, click Create VPC to enter the VPC management console to create one, for example, vpc-dws. Then, go back to the page for creating a cluster on the GaussDB(DWS) management console, click next to the VPC drop-down list, and select the new VPC.

      For details, see the Virtual Private Cloud User Guide.

    • Subnet: When you create a VPC, a subnet is created by default. You can select the corresponding subnet.
    • Security Group: Select Automatic creation.

      The automatically created security group is named GaussDB(DWS)-<cluster name>-<GaussDB(DWS) cluster database port>. The outbound allows all access requests, while the inbound opens only the Database Port to allow access requests from clients or applications.

      If you select a customized security group, add an inbound rule to it to open the Database Port of the GaussDB(DWS) cluster for client hosts that access GaussDB(DWS). Table 1 shows an example of the inbound rule. For details about how to add the inbound rule, see Adding a Security Group Rule in the Virtual Private Cloud User Guide.

      Table 1 Inbound rule example

      Parameter

      Example Value

      Protocol/Application

      TCP

      Port

      8000

      NOTE:

      Enter the Database Port set when creating the data warehouse cluster. This port is used for receiving client connections to GaussDB(DWS). The default port is 8000.

      Source

      Select IP address, and enter the IP address and subnet mask of the client host that accesses GaussDB(DWS), for example, 192.168.0.10/16.

    • EIP: Select Buy now to purchase an EIP for the cluster as the cluster's public network IP address, and set its Bandwidth.
    Figure 3 Network parameters

  7. Configure the Enterprise Project to which the cluster belongs. You can configure this parameter only when the Enterprise Project Management service is enabled. The default value is default.

    An enterprise project facilitates project-level management and grouping of cloud resources and users.

    You can select the default enterprise project (default) or other existing enterprise projects. To create an enterprise project, log in to the Enterprise Management console. For details, see the Enterprise Management User Guide.

  8. Select Default for Advanced Settings in this example.

    • Default: Indicates that the following advanced settings use the default configurations.
      • Automated Snapshot: By default, the policy for automatically creating cluster snapshots is enabled.
      • CNs: Two CNs are deployed by default.
      • Parameter Template: The default database parameter template is associated with the cluster.
      • Tag: By default, no tag is added to the cluster.
      • Encrypt DataStore: This parameter is disabled by default, indicating that the database is not encrypted.
    • Custom: If you select this option, parameters Automated Snapshot, CNs, Tag, Encrypt DataStore, and Parameter Template are displayed on the page. You can customize these settings as required.

  9. Click Next. The Details page is displayed.
  10. Click Submit.

    After the submission is successful, the creation starts. Click Back to Cluster List. The cluster management page is displayed. The initial status of the cluster is Creating. Cluster creation takes some time. Wait for a while. After the cluster becomes Available, it is ready for use.