If the resources that are selected when you purchase an AnalyticDB for MySQL Data Warehouse Edition (V3.0) cluster cannot meet your business requirements or are far more than required, you can scale the cluster.
Prerequisites
Your Alibaba Cloud account does not have unpaid renewal orders.
The cluster is in the Running state.
Background information
AnalyticDB for MySQL allows you to scale a cluster. For clusters in reserved mode, you can individually change the number of node groups or the storage capacity or change both of them. For clusters in elastic mode, you can individually change the amount of computing resources or the amount of elastic I/O resources or change both of them.
Usage notes
When you scale a cluster, you cannot execute the
SUBMIT JOBstatement to submit asynchronous jobs. If your business requires asynchronous jobs, perform scaling during appropriate periods.
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.
When the scaling process is about to end, transient connections may occur. We recommend that you scale your cluster during off-peak hours or make sure that your application is configured to automatically reconnect to your cluster.
When you change the performance level of enhanced SSDs (ESSDs), take note of the following items:
If you change the ESSD performance level, you cannot change other configurations.
When you change the ESSD performance level from PL1, PL2, or PL3 to PL0, you cannot execute the
SUBMIT JOBstatement to submit asynchronous jobs. If your business requires asynchronous jobs, perform scaling during appropriate periods.When you change the ESSD performance level from PL1, PL2, or PL3 to PL0, 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 change the ESSD performance level to a higher level, data is not redistributed and your business is not affected.
Billing rules
For information about the billing rules, see Billing of configuration changes.
Procedure
Scale a cluster in elastic mode
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 Scale Up or choose More > Scale Down in the Actions column.
On the Upgrade/Downgrade or Downgrade page, configure the parameters that are described in the following table.
Parameter
Description
Version
The edition and version of the cluster. This parameter is automatically set to Data Warehouse Edition (V3.0). You do not need to configure this parameter.
Mode
The mode of the cluster. This parameter is automatically set to Elastic Mode. You do not need to configure this parameter.
Edition
The edition of the cluster. This parameter is automatically set to Cluster Edition. You do not need to configure this parameter.
Instance Type
The instance type of the cluster. This parameter is automatically set to E32. You do not need to configure this parameter.
Computing Resource
The computing resources of the cluster. You can use computing resources to compute data. The increase in the computing resources can accelerate data queries. We recommend that you select more CPU cores for computing resources than those for storage resources.
EIU Capacity
The single-node specifications of an elastic I/O unit (EIU) for the cluster. Each EIU consists of three nodes.
Elastic I/O resources are bundled into units and sold as EIUs. You can use EIUs to scale up storage resources for clusters in elastic mode for Cluster Edition. For more information, see Scale up elastic I/O resources.
After you scale up elastic I/O resources, the amount of hot data that is locked by each EIU increases. For more information, see the "EIU-based storage performance metrics" section of the Scale up elastic I/O resources topic. If you want to scale down the elastic I/O resources, you must make sure that the amount of hot data in your cluster is less than the amount of hot data that can be locked by EIU specifications after scale-down. If the preceding requirements cannot be met, we recommend that you migrate part of the data to cold storage before you scale down the elastic I/O resources.
EIUs
The number of EIUs.
NoteThis parameter takes effect only when the Mode parameter is set to Elastic Mode and the Computing Resource parameter is set to 32 cores and 128 GB or more.
ESSD Performance Level
The ESSD performance level of the cluster. ESSD performance levels provide the following capacities:
PL0: 20 GiB to 65536 GiB.
PL1: 20 GiB to 65536 GiB.
PL2: 461 GiB to 65536 GiB.
PL3: 1261 GiB to 65536 GiB.
ImportantWhen you change the ESSD performance level, you cannot change other configurations.
When you change the ESSD performance level, the amount of hot data in your cluster must reach the minimum capacity that can be provided by the selected performance level.
The hot storage fee varies based on the ESSD performance level. You can calculate the hot storage fee by using the following formula:
Unit storage price of an ESSD performance level × Hot storage size × Duration. For information about the unit storage price of each ESSD performance level, see Pricing for Data Warehouse Edition (V3.0).
For a subscription cluster, read and select the Terms of Service, and then click Buy Now. Confirm the order and the payment method, and then click Subscribe. For a pay-as-you-go cluster, read and select the Terms of Service, and then click Buy Now.
Scale a cluster in reserved mode
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 Scale Up or choose More > Scale Down in the Actions column.
On the Upgrade/Downgrade or Downgrade page, configure the parameters that are described in the following table.
Parameter
Description
Version
The edition and version of the cluster. This parameter is automatically set to Data Warehouse Edition (V3.0). You do not need to configure this parameter.
Edition
The edition of the cluster. This parameter is automatically set to Cluster Edition. You do not need to configure this parameter.
Instance Type
The instance type of the cluster.
Node Groups
The number of node groups. By default, each node group consists of three nodes.
Capacity
The storage of a single node group. If you purchase multiple node groups, you can calculate the total storage of the cluster by using the following formula: Total storage = Storage per node group × Number of node groups.
ESSD Performance Level
The ESSD performance level of the cluster. ESSD performance levels provide the following capacities:
PL0: 20 GiB to 65536 GiB.
PL1: 20 GiB to 65536 GiB.
ImportantWhen you change the ESSD performance level, you cannot change other configurations.
When you change the ESSD performance level, the amount of hot data in your cluster must reach the minimum capacity that can be provided by the selected performance level.
The hot storage fee varies based on the ESSD performance level. You can calculate the hot storage fee by using the following formula:
Unit storage price of an ESSD performance level × Hot storage size × Duration. For information about the unit storage price of each ESSD performance level, see Pricing for Data Warehouse Edition (V3.0).
For a subscription cluster, read and select the Terms of Service, and then click Buy Now. Confirm the order and the payment method, and then click Subscribe. For a pay-as-you-go cluster, read and select the Terms of Service, and then click Buy Now.