AnalyticDB for MySQL:Create a resource scaling plan

Create a resource scaling plan for Data Lakehouse Edition (V3.0)

Usage notes

• You cannot change the configuration of a cluster when you use resource scaling plans. Before you change the configuration of a cluster, you must disable the resource scaling plans for the cluster. After you change the configuration of the cluster, you can re-enable the resource scaling plans for the cluster. For information about how to disable a resource scaling plan, see Manage a resource scaling plan.

• You cannot enable an elastic I/O unit (EIU) scaling plan and a Default Proportional Scaling for EIUs scaling plan at the same time.

• If no Interactive Resource Group scaling plan is enabled, Default Proportional Scaling for EIUs scaling plans cannot take effect.

• When the amount of reserved storage resources is 0 AnalyticDB compute unit (ACU), you can create only Interactive Resource Group scaling plans.

Types of resource scaling plans

Procedure

1. Log on to the AnalyticDB for MySQL console. In the upper-left corner of the console, select a region. In the left-side navigation pane, click Clusters. On the Data Lakehouse Edition (V3.0) tab, find the cluster that you want to manage and click the cluster ID.

2. In the left-side navigation pane, choose Cluster Management > Resource Management.

3. On the Resource Management page, click the Scaling Plans tab. On the Resource Scaling Plans tab, click Create Plan in the upper-right corner.

4. In the Create Resource Scaling Plan panel, configure the parameters that are described in the following tables.

   1. Configure the Plan Name, Effective Date, and Expiration Date parameters.

      Parameter	Description
      Plan Name	The name of the scaling plan. The name must meet the following requirements: The name is 2 to 30 characters in length. The name can contain letters, digits, and underscores (_).
      Effective Date	The start date of the scaling plan.
      Expiration Date	The end date of the scaling plan.

   2. Select a Scaling Type and configure the scaling plan parameters.

      Interactive Resource Group scaling plan

      Parameter	Description
      Scaling Type	The type of the scaling plan. Select Interactive Resource Group.
      Resource Group	The interactive resource group that you want to use for the scaling plan. Each Interactive Resource Group scaling plan must be associated with a resource group. If you release the resource group, the scaling plan is re-associated with the user_default resource group.
      Desired Specifications	The desired specifications.
      Scaling Cycle	The days on which you want to execute the scaling plan.
      Scaling Time (Cluster-specific)	The time when you want the system to start scaling resources. Important The interval between the Scaling Time (Cluster-specific) and the current time must be greater than or equal to 10 minutes for an Interactive Resource Group scaling plan. If a Default Proportional Scaling for EIUs scaling plan exists, the scaling time interval between Interactive Resource Group scaling plans must be greater than or equal to 1 hour. If no Default Proportional Scaling for EIUs scaling plan exists, the scaling time interval between Interactive Resource Group scaling plans must be greater than or equal to 10 minutes.
      Enabled	Specifies whether to enable the scaling plan. By default, the scaling plan is enabled. For more information, see the "Effective rules for a Data Lakehouse Edition (V3.0) scaling plan" table.

      EIU scaling plan

      Parameter	Description
      Scaling Type	The type of the scaling plan. Select EIU.
      Desired Specifications per EIU	The desired specifications.
      Scaling Cycle	The days on which you want to execute the scaling plan.
      Scaling Time (Cluster-specific)	The time when you want the system to start scaling resources. Important The interval between the Scaling Time (Cluster-specific) and the current time must be greater than or equal to 30 minutes for an EIU scaling plan. The scaling time interval between EIU scaling plans must be greater than or equal to 1 hour.
      Default Proportional Scaling for EIUs	Specifies whether to enable the Default Proportional Scaling for EIUs scaling plan. By default, the scaling plan is disabled. If you want the Default Proportional Scaling for EIUs scaling plan to take effect, you must create and enable an Interactive Resource Group scaling plan.
      Enabled	Specifies whether to enable the scaling plan. By default, the scaling plan is enabled. For more information, see the "Effective rules for a Data Lakehouse Edition (V3.0) scaling plan" table.

5. Click OK.

Effective rules for a scaling plan

After you create or modify a scaling plan for an AnalyticDB for MySQL Data Lakehouse Edition (V3.0) cluster, the scaling plan takes effect based on the value of the Scaling Time (Cluster-specific) parameter.

Effective time: The scaling plan takes effect on February 15, 2023. The cluster is scaled for the first time at 11:00:00 on February 15, 2023 (Wednesday).

Create a resource scaling plan for Data Warehouse Edition (V3.0)

Prerequisites

• The cluster is in elastic mode for Cluster Edition.

• The cluster has 32 cores and 128 GB memory or more.

• If you want to use the Default Proportional Scaling for Computing Resources and EIUs scaling plan, the version of the cluster must be V3.1.3.2 or later.

• If you want to use the Scaling for Computing Resources or Scaling for EIUs scaling plan, the version of the cluster must be V3.1.6.1 or later and the cluster must be created in one of Chinese mainland regions on September 1, 2022 or later.

Types of resource scaling plans

Procedure

1. Log on to the AnalyticDB for MySQL console. In the upper-left corner of the console, select a region. In the left-side navigation pane, click Clusters. On the Data Warehouse Edition (V3.0) tab, find the cluster that you want to manage and click the cluster ID.

2. In the left-side navigation pane, click Elastic Resource Scaling.

3. On the Resource Scaling Plans tab of the Elastic Resource Scaling page, click Create Plan in the upper-right corner.

4. In the Create Resource Scaling Plan panel, configure the parameters that are described in the following table.

   Scaling plan parameters for Data Warehouse Edition (V3.0)

   Parameter	Description
   Scaling Type	The type of the scaling plan. Important If you want to use the Default Proportional Scaling for Computing Resources and EIUs scaling plan, the version of the cluster must be V3.1.3.2 or later. If you want to use the Scaling for Computing Resources or Scaling for EIUs scaling plan, the version of the cluster must be V3.1.6.1 or later and the cluster must be created in one of Chinese mainland regions on September 1, 2022 or later.
   Plan Name	The name of the scaling plan. The name must meet the following requirements: The name is 2 to 30 characters in length. The name can contain letters, digits, and underscores (_).
   Resource Group	The resource group that you want to use for the scaling plan. Each scaling plan must be associated with a resource group. If you release the resource group, the scaling plan is re-associated with the USER_DEFAULT resource group. For more information about resource groups, see Resource group overview and Create a resource group.
   Effective Date	The start date of the scaling plan.
   Expiration Date	The end date of the scaling plan.
   Scaling Time	The time when you want the system to start scaling resources. Select the time on the hour. Important If you want to execute multiple scaling plans on the same day, we recommend that you schedule the scaling plans at an interval of at least 1 hour.
   Restoration Time	The time when you want the system to scale the resources back to the original specifications. Select the time on the hour.
   Scaled Resources	The specifications of the resources that you want to add, which can be up to eight times the current specifications. For example, if the cluster has 32 cores and 128 GB memory, you can add up to 256 cores and 1,024 GB memory to the cluster resources. After scaling, the cluster has 288 cores and 1,152 GB memory.
   Scaling Cycle	The days on which you want to execute the scaling plan within every week. You must select at least one day.
   Enabled	Specifies whether to enable the scaling plan. By default, the scaling plan is enabled. For more information, see the "Effective rules for a Data Warehouse Edition (V3.0) scaling plan" table.

5. Click OK.

Effective rules for a scaling plan

Related operations