Upgrade minor version
As new minor versions of AnalyticDB for MySQL are released, you can upgrade your cluster to access new features and enjoy an improved user experience.
Upgrade impacts
-
For Enterprise Edition, Data Lakehouse Edition, Data Warehouse Edition (elastic mode – Cluster Edition), and Data Warehouse Edition (reserved mode) clusters, the upgrade prohibits management operations and
INSERT OVERWRITEstatements. Other read and write operations are unaffected. -
For Basic Edition and Data Warehouse Edition (elastic mode – Standalone Edition) clusters, the upgrade prohibits read, write, and management operations, and the cluster becomes unavailable.
-
During the upgrade, the cluster may experience brief transient connection interruptions. To mitigate this, perform the upgrade during off-peak hours and configure your application with an automatic reconnection mechanism.
Upgrade duration
A minor version upgrade takes approximately 30 minutes.
Check minor version
Using the console
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. Find the cluster that you want to manage and click the cluster ID.
-
On the Cluster Information page, find the Configuration Information in the Current Minor Version section.
Using SQL
-
Go to the SQL editor.
-
For Enterprise Edition, Basic Edition, and Data Lakehouse Edition: Log on to the AnalyticDB for MySQL console and click the ID of your cluster. In the left-side navigation pane, click .
-
For Data Warehouse Edition: Connect to your cluster.
-
-
Run the following SQL statement to check the current minor version of the cluster:
SELECT adb_version();The source_version column in the output shows the minor version:
+----------------+----------------+---------------------+-------------+---------------------+ | source_version | rpm_version | build_date | revision_id | revision_date | +----------------+----------------+---------------------+-------------+---------------------+ | 3.1.10.3 | 20240308165905 | 2024-03-08 16:59:05 | 1b60f22 | 2024-03-08 16:45:09 | +----------------+----------------+---------------------+-------------+---------------------+
Upgrade minor version
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. Find the cluster that you want to manage and click the cluster ID.
-
On the Cluster Information page, find the Configuration Information in the Current Minor Version section.
-
Click Update Version next to the minor version number.
NoteIf the Update Version button is grayed out, your cluster is already on the latest minor version.
-
In the Update Version dialog box, configure the update time and the target version.
Parameter
Description
Current Version
The current minor version of the cluster.
Updatable Version
Select the target minor version from the drop-down list.
For more information about the features supported by each minor version, see Release notes.
Update Time
Specifies when the upgrade starts. Valid values:
-
Within Maintenance Window: When you click OK, the system immediately submits the upgrade task. After completing the necessary preparations, the task waits to run during the cluster's specified maintenance window .
-
Immediate: When you click OK, the upgrade starts immediately.
-
-
Click OK.
WarningDuring the minor version upgrade, the cluster may experience brief transient connection interruptions. To mitigate this, perform the upgrade during off-peak hours and configure your application with an automatic reconnection mechanism.
Related APIs
|
Edition |
API |
|
Enterprise Edition, Basic Edition, or Data Lakehouse Edition |
|
|
Data Warehouse Edition |