AnalyticDB for MySQL Edition can scale out resources in clusters. Computing resources can be scaled out based on elastic plans, and then scaled back to the original specifications at the specified restoration time. This feature can meet the regular requirements for resources during peak and off-peak hours and make full use of resources. This topic describes how to scale out resources.

Prerequisites

The AnalyticDB for MySQL Edition must meet the following conditions at the same time:

  • AnalyticDB for MySQL Edition cluster must be an elastic mode for Cluster Edition .
  • The cluster must have 32 or more cores.
  • The cluster kernel version must be 3.1.3.2 or above.
Note
  • If you need to upgrade the kernel version, please Submit a ticket to contact the support.
  • For more information about cluster editions and specifications, see Editions.

Effective time of an elastic plan

After you create or modify an elastic plan, the system determines the effective time of the plan based on the time when the plan is created or modified. The following table describes the effective time rules of the elastic plan.

Creation or modification time Effective time Example
00:00~23:00 The elastic plan becomes effective at 00:00 the next day and are executed at the specified time after it becomes effective. Example 1:
  • Creation time: 18:00 on Tuesday, May 25, 2021.

    Scale-out Time is set to 02:00 and Period Settings is set to Wednesday.

  • Effective time: The elastic plan becomes effective at 00:00 on Wednesday, May 26, 2021. The first scale-out occurs at 02:00 on Wednesday, May 26, 2021.
23:00~23:59 The elastic plan becomes effective at 00:00 the day after tomorrow and are executed at the specified time after it becomes effective. Example 2:
  • Creation time: 23:30 on Tuesday, May 25, 2021.

    Scale-out Time is set to 02:00 and Period Settings is set to Wednesday.

  • Effective time: The elastic plan becomes effective at 00:00 on Thursday, May 27, 2021. The first scale-out occurs at 02:00 on Wednesday, June 2, 2021.

Create an elastic plan

  1. Log on to the AnalyticDB for MySQL console by your Alibaba Cloud account.
  2. In the upper-left corner of the page, select the region where clusters reside.
  3. In the left-side navigation pane, click Clusters.
  4. On the V3.0 Clusters tab, click the target Cluster ID.
  5. In the left-side navigation pane, click Resource Elastic Plans.
  6. On the Resource Elastic Plans tab of the Resource Elastic Plans page, click Create Plan in the upper-right corner.
    1
  7. In the Create Resource Elastic Plan panel, set the following parameters.
    Table 1. Parameters
    Parameter Description
    Plan Name Required. The name of the elastic plan. The name must meet the following requirements:
    • The name must be 2 to 30 characters in length
    • It can only contain letters, digits, and underscores (_).
    Resource Group Required. The resource pool to which the elastic plan is bound.

    Each elastic plan must be bound to a resource pool. If the specified resource pool is released, the elastic plan is bound to the USER_DEFAULT resource pool. For more information about resource pools, see Resource pool overview and Manage resource pools.

    Start Date Optional. The start date when the elastic plan is executed.
    End Date Optional. The end date when the elastic plan is executed.
    Scale-out Time Required. The start time of the scale-out. The system tries to ensure that the required computing resources are scaled out at the specified time. Select the time on the hour.
    Note If multiple elastic plans are executed within the same day, we recommend that the interval between elastic plans is not less than one hour.
    Restoration Time Required. The end time of the scale-out. The system tries to ensure that the computing resources are scaled in at the specified time. Select the time on the hour.
    Scale-out Resource Required. The specifications of resources to be scaled out. The specifications of resources to be scaled out can be up to eight times as high as the current cluster specifications.

    For example, if the current specifications are 32 cores, 128 GB of memory, you can select the maximum resource specifications of 256 cores, 1,024 GB of memory. The total cluster specifications after the scale-out are 288 cores, 1,125 GB of memory.

    Period Settings The days of the week when you want to execute the elastic plan. You can select one or more days.
    Enabled Specifies whether to enable the elastic plan. It is enabled by default. For more information about the effective time of an elastic plan, see Effective time of an elastic plan.
  8. Click OK.

Manage an elasticity plan

  1. Log on to the AnalyticDB for MySQL console by your Alibaba Cloud account.
  2. In the upper-left corner of the page, select the region where clusters reside.
  3. In the left-side navigation pane, click Clusters.
  4. On the V3.0 Clusters tab, click the target Cluster ID.
  5. In the left-side navigation pane, click Resource Elastic Plans.
  6. On the Resource Elastic Plans tab, you can perform the following operations on the elastic plan:
    2
    • Modify an elasticity plan
      1. Click Edit in the Actions column corresponding to the elastic plan.
      2. In the Modify Resource Elastic Plan panel, modify relevant parameters based on business needs and then click OK.

        For more information about the parameters, see Parameters.

    • Enable or suspend an elastic plan
      1. Click Enable or Pause in the Actions column corresponding to the elastic plan.
      2. In the message that appears, click OK.
    • Delete an elastic plan
      1. Click Delete in the Actions column corresponding to the elastic plan.
      2. In the message that appears, click OK.

View elastic plans of the current-day

  1. Log on to the AnalyticDB for MySQL console by your Alibaba Cloud account.
  2. In the upper-left corner of the page, select the region where clusters reside.
  3. In the left-side navigation pane, click Clusters.
  4. On the V3.0 Clusters tab, click the target Cluster ID.
  5. In the left-side navigation pane, click Resource Elastic Plans.
  6. Click the Elastic Plans of Current Day tab. You can view information of elastic plans of the current day, such as Execution Start Time, Execution End Time, and Elastic Resource.
    1
    Note In the upper-right corner of the elastic plan list, you can select Enabled or Disabled from the Plan Status drop-down list to filter elastic plans of the current day. For more information about the effective time of an elastic plan, see Effective time of an elastic plan.

View execution logs of an elastic plan

  1. Log on to the AnalyticDB for MySQL console by your Alibaba Cloud account.
  2. In the upper-left corner of the page, select the region where clusters reside.
  3. In the left-side navigation pane, click Clusters.
  4. On the V3.0 Clusters tab, click the target Cluster ID.
  5. In the left-side navigation pane, click Resource Elastic Plans.
  6. Click the Execution Logs tab. You can view execution log information of an elastic plan, such as Execution Start Time, Execution End Time, and Execution Status.
    2
    Note By default, the execution logs of the current day are displayed. You can view the execution logs within the last 30 days.