All Products
Search
Document Center

AnalyticDB:2025

Last Updated:May 13, 2025

This topic describes the release notes for AnalyticDB for MySQL in 2025 and provides links to the relevant references.

Usage notes

Take note of the following items during minor version updates of AnalyticDB for MySQL clusters:

  • For AnalyticDB for MySQL clusters in reserved mode for Cluster Edition or AnalyticDB for MySQL clusters in elastic mode for Cluster Edition that have 32 cores or more, data read and write operations are not interrupted when engine versions are updated. Within 5 minutes before the update is complete, queries may encounter transient connections.

  • For AnalyticDB for MySQL clusters in elastic mode for Cluster Edition that have 8 or 16 cores, data write operations may be interrupted for 30 minutes when engine versions are updated. Within 5 minutes before the update is complete, queries may encounter transient connections.

  • Minor version updates of AnalyticDB for MySQL clusters do not affect database access, account management, database management, or IP address whitelist settings.

  • During a minor version update of an AnalyticDB for MySQL cluster, network jitters may occur and affect write and query operations. Make sure that your application is configured to automatically reconnect to the AnalyticDB for MySQL cluster.

  • During a minor version update of an AnalyticDB for MySQL cluster, the cluster may encounter transient connections. Make sure that your application is configured to automatically reconnect to the AnalyticDB for MySQL cluster.

If you do not need to update the minor version of your AnalyticDB for MySQL cluster or an error occurs during the update process, you can cancel the scheduled minor version update. You can cancel only the scheduled events of a minor version update. For more information, see the "Cancel scheduled events" section of the Manage O&M events topic.

Warning

If the minor version of your AnalyticDB for MySQL cluster is earlier than the latest minor version, Alibaba Cloud pushes a notification at an irregular interval to inform you that the cluster needs to be updated to the latest minor version. We recommend that you update the minor version of your AnalyticDB for MySQL cluster at the earliest opportunity within six months after you receive the notification. Otherwise, you shall assume all liabilities for risks such as service interruptions and data loss.

April 2025

Category

Feature

Description

References

New feature

New regions available for the lake cache feature

The lake cache feature is supported for Enterprise Edition, Basic Edition, and Data Lakehouse Edition clusters in the Indonesia (Jakarta) region.

Lake cache

Change to the Enterprise SSD (ESSD) performance level

The ESSD performance level can be changed for Enterprise Edition, Basic Edition, and Data Lakehouse Edition clusters.

Scale an Enterprise Edition or Basic Edition cluster

March 2025

Category

Feature

Description

References

New feature

Multi-zone deployment

Enterprise Edition clusters that support multi-zone deployment can be created. Compared with single-zone clusters, multi-zone clusters provide enhanced disaster recovery capabilities to withstand data center failures. If a failure occurs, all service requests are automatically switched to the secondary zone to ensure the continuity of business operations.

Create a cluster

Storage plans

  • Storage plans can be used to offset the storage usage of Enterprise Edition and Basic Edition clusters.

  • The following storage plan specifications are added: 500 GB, 1,000 GB, 5,000 GB, and 10,000 GB.

Storage plans

SSL encryption

The SSL encryption feature is supported to encrypt the data transmitted between Enterprise Edition, Basic Edition, and Data Lakehouse Edition clusters and clients. This prevents the data from being listened to, intercepted, and tampered with by third parties.

SSL encryption

Column addition or removal for external tables

Columns can be added to or removed from external tables in Enterprise Edition, Basic Edition, and Data Lakehouse Edition clusters.

ALTER TABLE (external tables)

V3.2.3

Category

Feature

Description

References

New feature

Fast refresh of materialized views

  • Materialized views whose base tables are partitioned tables support fast refresh.

  • The INSERT OVERWRITE and TRUNCATE statements can be executed on the base tables of a materialized view that supports fast refresh.

Refresh materialized views

Table recycle bin

The table recycle bin feature is supported to temporarily store the deleted tables in the table recycle bin. This helps you restore accidentally deleted data.

Table recycle bin

Change to the number of shards

The number of shards determines the horizontal scaling capability of an AnalyticDB for MySQL cluster. You can change the number of shards for Data Warehouse Edition clusters in the AnalyticDB for MySQL console.

Change the number of shards

Creation of Iceberg external tables

Iceberg external tables can be created.

CREATE EXTERNAL TABLE

February 2025

Category

Feature

Description

References

New feature

Enterprise Edition and Basic Edition released

AnalyticDB for MySQL Enterprise Edition and Basic Edition are released.

  • Enterprise Edition runs in multi-replica mode and is an integrated edition of Data Lakehouse Edition and Data Warehouse Edition that provides the same features as Data Lakehouse Edition. Enterprise Edition supports capabilities in elastic mode, such as resource group isolation, elastic resource scaling, and tiered storage of hot and cold data. Enterprise Edition also supports capabilities in reserved mode, such as high throughput, real-time writes and high-concurrency, real-time queries.

  • Basic Edition runs in single-replica mode and supports tiered storage of hot and cold data. However, Basic Edition does not have the benefits of a distributed architecture or support high availability. Basic Edition does not support resource group isolation or scheduled scaling. You cannot change a cluster from Basic Edition to Enterprise Edition.

Editions

Zero-ETL

The zero-ETL feature is supported to synchronize data from ApsaraDB for MongoDB. You can create data synchronization tasks from ApsaraDB for MongoDB to synchronize and manage data in an end-to-end manner and integrate transaction processing with data analysis.

Use zero-ETL to synchronize data

Change to column names and properties for external tables

Column names and properties, such as the data type, can be changed for external tables in Enterprise Edition, Basic Edition, and Data Lakehouse Edition clusters.

ALTER TABLE (external tables)

January 2025

Category

Feature

Description

References

Optimized feature

Cold data storage upgraded from locally redundant storage (LRS) mode to zone-redundant storage (ZRS) mode

Cold data can be redundantly stored across multiple zones in the same region. This ensures normal data access even if a zone is unavailable.

Tiered storage of hot and cold data