Skip to main content

Manage DPS Clusters

DPS clusters are essential when you use service units to process your data. Relyt provides rich features to help you manage DPS clusters to cater to your business needs. For example, you can create multiple DPS clusters of specific specifications to process different workloads, to isolate workloads. You can also enable the auto-suspend option to better manage your cloud budget.

In Relyt, only DW users acted on by the main account or SYSTEMADMIN subaccount can manage DPS clusters.

Create a DPS cluster

Relyt allows you create multiple DPS clusters based on your demands.

info

Currently, in each DW service unit, you can create only one Hybrid DPS cluster and as many as Extreme DPS clusters. The Hybrid DPS cluster is created along with the creation of the DW service unit. For more information about how to create a Hybrid DPS cluster, see "Create a DW service unit" in Manage DW Service Units.

The following procedure details how to create an Extreme DPS cluster. You can repeat the following procedure to create as many as Extreme DPS clusters based on your business requirements.

  1. Sign in to the Relyt by using the main account or a SYSTEMADMIN account.

  2. Click the information card of the target DW service unit to enter the service unit.

  3. Select DPS Clusters in the left sidebar and click + DPS Cluster in the upper right corner.

  4. On the Create DPS Cluster page, configure the DPS cluster.

    The following table describes the configuration parameters for DPS cluster.

    ParameterRequiredDescription
    NameYesThe name of the DPS cluster. The value can contain only letters, digits, and hyphens (-), be 4 to 32 characters in length, and must start with a letter.
    TypeYesThe DPS Type used by the DPS cluster. It is fixed to Extreme DPS.
    SizeYesThe size of compute resources allocated to the DPS cluster.
    Auto-SuspendYesWhether to enable the auto-suspend option. If you set this parameter to Never, the auto-suspend feature is disabled. If you set this parameter to another value, for example 5 minutes, the DPS cluster will be automatically suspended if it is idle for 5 minutes.
    DescriptionNoThe description of the DPS cluster.
    Advanced OptionsNoThe advanced options for the DPS cluster. Currently, only Adaptive Query Scaling (AQS) is provided. For more information about AQS, see Adaptive Query Scaling.
  5. Click Create.

After you complete the operation, the DPS cluster appears in the list on the DPS Clusters page. When its status changes to Active, it is ready for use.

Resize a DPS cluster

As your business develops, the sizes of your workloads may change. As a result, the current sizes of your DPS clusters may become unsuitable. Relyt allows you to resize these DPS clusters without affecting workloads running on them if any.

  1. Sign in to the Relyt by using the main account or a SYSTEMADMIN account.

  2. Click the information card of the target DW service unit to enter the service unit.

  3. In the left sidebar, select DPS Clusters.

  4. On the DPS Clusters page, locate the DPS cluster you want to resize and choose ... > Edit in the Actions column.

  5. On the Edit DPS Cluster page, select the desired size for the DPS cluster and click Update.

    You can also update the description of the DPS cluster on this page.

This change takes effect immediately.

Enable auto-suspend for a DPS cluster

The auto-suspend feature allows you to set a suspend condition for your DPS cluster. In this way, the DPS cluster will be automatically suspended if the suspend condition is met. In Relyt, the auto-suspend feature is triggered by the maximum idle time you set for the DPS cluster, that is the value of the Auto-Suspend field configured during the DPS cluster creation.

info

The auto-suspend feature supports only Extreme DPS clusters and can be configured only during the Extreme DPS cluster creation.

To create an Extreme DPS cluster with auto-suspend enabled, see the procedure provided in Create a DPS cluster, with Auto-Suspend set to any value instead of Never.

Note that auto-suspend cannot be disabled once enabled. If you no longer want an Extreme DPS cluster to be automatically suspended, you can delete the Extreme DPS cluster first and then recreate it with Auto-Suspend set to Never.

Manually suspend a DPS cluster

When a DPS cluster is temporarily unneeded, especially when is is not enabled with the auto-suspend feature, you can automatically suspend it. Same as auto-suspended DPS clusters, automatically suspended DPS clusters will be automatically resumed in milliseconds if new queries or tasks are issued to them.

caution

Note that after a DPS cluster is suspended, all queries running or queuing to run on it will be terminated. Exercise with caution when performing this operation.

  1. Sign in to the Relyt by using the main account or a SYSTEMADMIN account.

  2. Click the information card of the target DW service unit to enter the service unit.

  3. In the left sidebar, select DPS Clusters.

  4. On the DPS Clusters page, locate the DPS cluster you want to resize and choose ... > Suspend in the Actions column.

    Note that only active DPS clusters can be suspended.

  5. In the dialog box that is displayed, click Yes, Suspend.

Drop a DPS cluster

You can drop the Extreme DPS clusters that are no longer needed.

tip

Hybrid DPS clusters cannot be dropped.

  1. Sign in to the Relyt by using the main account or a SYSTEMADMIN account.

  2. Click the information card of the target DW service unit to enter the service unit.

  3. In the left sidebar, select DPS Clusters.

  4. On the DPS Clusters page, locate the unwanted Extreme DPS cluster, and choose ... > Drop in the Actions column.

  5. In the confirmation dialog box that is displayed, type the DPS cluster name in the text box and click Confirm.