Frequently asked questions about purchasing, billing, configuration changes, and upgrades in AnalyticDB for MySQL.
Unless an edition is specified, a question applies to AnalyticDB for MySQL Data Warehouse Edition clusters only.
Billing
How are Enterprise Edition and Basic Edition clusters billed?
When you purchase an Enterprise Edition or Basic Edition cluster, the upfront payment on the buy page covers reserved resources only. Storage and elastic resources are billed on a pay-as-you-go basis as you use them. For the full billing breakdown, see Billable items of Enterprise Edition and Basic Edition.
Example: A pay-as-you-go Enterprise Edition cluster with single-zone deployment in the China (Hangzhou) region, 3 nodes at 8 AnalyticDB Compute Units (ACUs) each, storing 100 GB of hot data and 260 GB of cold data:
| Billable item | Calculation | Hourly fee |
|---|---|---|
| Reserved resources | USD 0.04615/ACU-hour × 8 ACUs × 3 nodes | USD 1.1076 |
| Hot data storage | USD 0.00022/GB-hour × 100 GB × 2 | USD 0.044 |
| Cold data storage | USD 0.000028/GB-hour × 260 GB | USD 0.00728 |
| Total | USD 1.15888 |
Billable item | Fee |
Reserved resources | USD 0.04615 per ACU-hour × 8 ACUs × 3 nodes × 1 hour = USD 1.1076 |
Hot data storage | USD 0.00022 per GB-hour × 100 GB × 1 hour × 2 = USD 0.044 |
Cold data storage | USD 0.000028 per GB-hour × 260 GB × 1 hour = USD 0.00728 |
Total fees per hour = USD 1.1076 + USD 0.044 + USD 0.00728 = USD 1.15888.
Why am I charged pay-as-you-go fees for my subscription cluster?
Subscription fees cover basic resources only. If your cluster consumes additional storage or elastic resources beyond the subscription, those are billed on a pay-as-you-go basis and appear as separate line items in your bill. See Billable items for the complete list.
How do I stop charges for a cluster I no longer use?
The answer depends on your billing method:
Subscription cluster: You have already paid for reserved resources. To avoid additional pay-as-you-go charges, delete or stop any operations that generate them — such as elastic resources, excess storage, caches, or backups. See Billable items for the full list of pay-as-you-go items.
Pay-as-you-go cluster: Billed hourly. To stop all charges, delete the cluster.
How do I confirm that billing has stopped?
After deleting a cluster, billing stops immediately. To verify, log on to the AnalyticDB for MySQL console, select the region in the upper-left corner, and confirm the cluster no longer appears in the list.
Can I reduce costs without deleting my cluster?
Cluster shutdown is not supported. To reduce costs, purchase storage plans or ACU-hour plans to offset storage and resource consumption, including reserved computing resources, reserved storage resources, and elastic resources.
Editions and modes
What are the differences between Enterprise Edition and Basic Edition?
Both editions support elastic mode (resource group isolation, elastic resource scaling, and tiered storage of hot and cold data) and reserved mode (high throughput, real-time writes, and high-concurrency real-time queries). The key difference is storage architecture:
| Enterprise Edition | Basic Edition | |
|---|---|---|
| Storage architecture | Multi-replica | Single-replica |
| High availability | Yes | No |
For the full feature comparison, see Editions.
What are the differences between Data Warehouse Edition and Data Lakehouse Edition?
Data Lakehouse Edition builds on the high-performance real-time analysis of Data Warehouse Edition (Enterprise Edition) and adds cost-effective batch processing and machine learning capabilities. It decouples computing and storage, which eliminates the consistency and timeliness issues that data synchronization can introduce. For details, see Editions.
What are the differences between elastic mode and reserved mode in Data Warehouse Edition?
| Elastic mode | Reserved mode | |
|---|---|---|
| Storage provisioning | Not required at cluster creation; charged based on actual usage | Must specify storage capacity upfront; charged based on specified capacity |
| Minimum storage charge | 20 GB (even if actual usage is lower) | Based on provisioned capacity |
| Resource separation | Computing and storage resources are separated | Combined |
Separating computing and storage in elastic mode lets you identify whether a performance bottleneck is in compute or storage and scale each independently to control costs.
What are elastic I/O resources?
Elastic I/O resources are measured and sold in elastic I/O units (EIUs). EIUs define the storage performance of a cluster. Real-time data and hot data are stored in EIUs to sustain high-throughput workloads from data import and index building. For more information, see Scale out elastic I/O resources.
Operations
Can I shut down an AnalyticDB for MySQL cluster?
No. AnalyticDB for MySQL clusters cannot be shut down.
Can I restart an AnalyticDB for MySQL cluster from the console?
No. To restart a cluster, submit a ticket.
What do I do if my cluster is locked?
If your Data Warehouse Edition cluster in elastic mode is locked because hot data stored in an elastic I/O unit (EIU) exceeds 8 TB, scale up your elastic I/O resources as soon as possible.
In what scenarios may cluster availability be affected?
Cluster availability may be affected when failures occur on the cluster or when the cluster undergoes configuration changes or version upgrades.
How do I check the minor version of my cluster?
Run the following statement:
select adb_version();Read the
source_versionfield in the result. Sample output:+----------------+----------------+---------------------+-------------+---------------------+ | source_version | rpm_version | build_date | revision_id | revision_date | +----------------+----------------+---------------------+-------------+---------------------+ | 3.1.4.10 | 20210809205222 | 2021-08-09 20:52:22 | 97b631a | 2021-08-09 20:32:04 | +----------------+----------------+---------------------+-------------+---------------------+
Upgrades and configuration changes
How long does an upgrade take, and does it affect my business?
Upgrades typically take 30 minutes to 2 hours, depending on cluster specifications and data volume. During the upgrade, your application may experience transient connection drops. Configure your application to automatically reconnect to avoid disruption. For best results, schedule upgrades during nighttime or off-peak hours.
Does a configuration change affect the number of shards?
No. A configuration change does not affect the number of shards.