Scale an AnalyticDB for MySQL Enterprise Edition or Basic Edition cluster to adjust compute resources, node count, or storage performance level based on your workload.
Prerequisites
Before you begin, make sure that:
Your Alibaba Cloud account has no unpaid renewal orders
The cluster is in the Running state
Potential impacts
Workload availability
The
SUBMIT JOBstatement is unavailable during scaling. If your workload depends on asynchronous jobs, schedule scaling accordingly.Transient connections may occur near the end of the scaling process. Scale during off-peak hours and make sure your application automatically reconnects.
Resource scaling plans
Scaling is blocked while resource scaling plans are active. Disable the resource scaling plans before you change configurations. After scaling completes, re-enable the plans.
ESSD performance level
When you change the ESSD performance level, make sure the data volume in your cluster meets the ESSD performance limits. For details, see ESSDs.
Data migration
When you scale a cluster, data in the cluster is migrated for redistribution. The amount of time that is required to migrate data is proportional to the data volume. When you downgrade cluster specifications, data migration may require up to dozens of hours to complete. Proceed with caution especially if your cluster contains a large amount of data.
After you trigger a configuration change operation, you can view the progress of the configuration change on the Clusters or Task Center page.
Billing
For billing details, see Pricing for Enterprise Edition and Basic Edition.
Scale up a cluster
-
Log on to the AnalyticDB for MySQL console. In the upper-left corner, select a region. In the left-side navigation pane, click Clusters.
-
On the Clusters page, find the cluster that you want to scale up and click Scale Up in the Actions column.
-
On the Upgrade/Downgrade page, configure the scaling parameters.
Parameter Enterprise Edition Basic Edition Single-node Specifications of Reserved Resources Supported Supported Reserved Resource Nodes Supported Not available ESSD Performance Level Supported Not available -
Review the Terms of Service and click Buy Now.
Subscription cluster: Confirm the order and payment method, and then click Subscribe.
Pay-as-you-go cluster: Review the Terms of Service and click Buy Now.
Scale down a cluster
-
Log on to the AnalyticDB for MySQL console. In the upper-left corner, select a region. In the left-side navigation pane, click Clusters.
-
On the Clusters page, find the cluster that you want to scale down and choose More > Scale Down in the Actions column.
-
On the Downgrade page, configure the scaling parameters.
Parameter Enterprise Edition Basic Edition Single-node Specifications of Reserved Resources Supported Supported Reserved Resource Nodes Supported Not available ESSD Performance Level Supported Not available -
Review the Terms of Service and click Buy Now.
Subscription cluster: Confirm the order and payment method, and then click Subscribe.
Pay-as-you-go cluster: Review the Terms of Service and click Buy Now.
Troubleshooting
can not submit job because unfinished async task's number = 1. Overwrite async job is not allowed
This error occurs when an asynchronous job is submitted while the cluster is being scaled.
To resolve this issue, wait for the scaling operation to finish before you re-submit the job, or schedule scaling during a period when no asynchronous jobs are running.