AnalyticDB for MySQL allows you to scale up cluster resources. You can use elastic plans to scale up resources at a scheduled point in time and then scale them back at a specified restoration point in time. This feature can meet the requirements for regular resource changes during peak and off-peak hours to make full use of resources. This topic describes how to scale up resources.

Prerequisites

The AnalyticDB for MySQL cluster must meet the following requirements:

  • The edition of the cluster is Elastic mode for Cluster Edition.
  • The cluster has 32 or more cores.
  • The minor engine version of the cluster is 3.1.3.2 or later.
    Note
    • To upgrade the minor engine version, Submit a ticket.
    • 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 is 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-up occurs at 02:00 on Wednesday, May 26, 2021.
23:00~23:59 The elastic plan becomes effective at 00:00 on the third day and is 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-up 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, configure the parameters described in the following table.
    Table 1. Parameters
    Parameter Description
    Plan Name Required. The name of the elastic plan. The name must meet the following requirements:
    • The name is 2 to 30 characters in length.
    • The name contains only letters, digits, and underscores (_).
    Resource Group Required. The resource pool to which to bind the elastic plan.

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

    Start Date Optional. The date on which to start the execution of the elastic plan.
    End Date Optional. The date on which to end the execution of the elastic plan.
    Scale-out Time Required. The start time of the scale-up. The system ensures that the required computing resources are scaled up at the specified time. Select the time on the hour.
    Note If multiple elastic plans are executed within the same day, we recommend that you set the interval between elastic plans to at least 1 hour.
    Restoration Time Required. The end time of the scale-up. The system ensures that the computing resources are scaled back at the specified time. Select the time on the hour.
    Scale-out Resource Required. The specifications of resources to be scaled up. The specifications of resources to be scaled up can be up to eight times the current cluster specifications.

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

    Period Settings The days of the week on which to execute the elastic plan. You can select one or more days.
    Enabled Specifies whether to enable the elastic plan. By default, the elastic plan is enabled. For more information about the effective time of an elastic plan, see the "Effective time of an elastic plan" section of this topic.
  8. Click OK.

Manage 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, perform the following operations on the elastic plan:
    2
    • Modify the elastic 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 your business requirements and click OK.

        For more information about the parameters, see the preceding "Parameters" table.

    • Enable or suspend the 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 the 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. View the details 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 the "Effective time of an elastic plan" section of this topic.

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. View the execution logs of elastic plans, 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 execution logs within the last 30 days.