Managing DWS Logical Clusters/Virtual Warehouses

Precautions

• Workload management is supported only by logical clusters or virtual warehouses of version 8.1.3.x or later.
• When a physical cluster is converted to a logical cluster, the original resource pool configuration is cleared. You have to add the resource pool again if you want to configure it after the conversion.

Procedure

1. Log in to the DWS console.
2. In the navigation pane on the left, choose Cluster > Cluster List.
3. In the cluster list, click the name of the target cluster to go to the Cluster Information page.
4. In the navigation pane, choose Logical Clusters or Compute Groups. In the Operation column of a logical cluster or compute group, click More and select Manage Workload. On the displayed page, you can manage resources in a logical cluster or compute group. For details, see DWS Resource Load Management.

   

Precautions

• Before a scale-out, you need to enable the logical cluster mode and add a logical cluster.
• The Data Node (DN) area displays the number of DNs and that of idle nodes in the current cluster. If there are no idle nodes, the cluster cannot be scaled out. To add idle nodes, click Add Idle Node. For details, see Scaling Out a Cluster.
• Storage-compute coupled logical clusters of 8.1.3 and later versions support online scale-out, and those of 8.2.1.100 and later versions support congested job termination.
• Logical clusters of 9.1.0.100 and later versions using the Storage-Compute Decoupled architecture support online scale-out, and those of 9.1.0.210 and later versions support congested job termination.

Procedure

1. Log in to the DWS console.
2. In the navigation pane on the left, choose Cluster > Cluster List.
3. In the navigation pane, choose Logical Clusters or Compute Groups. Locate the row that contains the logical cluster or compute group you want to scale out and click Scale Out in the Operation column.
   • If the cluster meets inspection conditions before the scale-out, the Inspect area is displayed. Click Start inspection to perform an inspection. (To stop an inspection task, click Abort Task.) When an inspection is ongoing, the inspection progress is displayed. Ensure that the inspection is passed and click Next to perform the change. For details, see Viewing Inspection Results.

4. On the displayed page, select the logical cluster/virtual warehouse you want to scale out. For details, see Scaling Out a Cluster.
5. Confirm that all information is correct, select I acknowledge the potential risks and agree to proceed with the change, and click Submit.

Notes and Constraints

• A host ring with CN nodes cannot be scaled in.
• A host ring with GTM and CM nodes cannot be scaled in.
• Logical clusters of version 9.1.0.215 or later support online scale-in and redistribution concurrency configuration. The redistribution concurrency can be set to a value from 1 to 200. The default value is 4.
• Scale-in will redistribute tables and may affect service performance. Ensure that the remaining nodes after scale-in can handle workloads. Perform scale-in during off-peak hours.

Procedure

1. Log in to the DWS console.
2. In the navigation pane on the left, choose Cluster > Cluster List.
3. In the cluster list, click the name of the target cluster to go to the Cluster Information page.
4. In the navigation pane, choose Logical Clusters or Virtual Warehouses. Locate the row that contains the logical cluster or virtual warehouse you want to scale in and click Scale In in the Operation column.
   Figure 2 Scaling in a logical cluster
   

5. On the displayed page, select the logical cluster or compute group you want to scale in and the number of nodes to remove. For details, see Scaling In a Cluster.

   If the cluster meets inspection conditions before the scale-in, the Inspection page is displayed. Click Start Inspection to perform an inspection. (To stop an inspection task, click Terminate Task.) When an inspection is ongoing, the inspection progress is displayed. Ensure that the inspection is passed and click Next to perform the change. For details, see Viewing Inspection Results.

6. Confirm that the New Specifications are correct, select I understand the possible risks and expenditure changes and agree to proceed with the change, and click Submit.