View and update the minor version of a cluster - AnalyticDB

As the minor versions of AnalyticDB for MySQL iterate, new minor versions can provide more features and better user experience. This topic describes how to update the minor version of an AnalyticDB for MySQL cluster.

Update impacts

When you update the minor versions of AnalyticDB for MySQL Enterprise Edition clusters, Data Lakehouse Edition clusters, Data Warehouse Edition clusters in elastic mode for Cluster Edition, and Data Warehouse Edition clusters in reserved mode, you cannot perform control operations or execute the INSERT OVERWRITE statement on the clusters.
When you update the minor versions of AnalyticDB for MySQL Data Warehouse Edition clusters in elastic mode for Standalone Edition, you cannot perform read, write, or control operations on the clusters, and the clusters remain in the unavailable state.
When you update the minor version of an AnalyticDB for MySQL cluster, transient connections may occur within seconds. We recommend that you perform an update during off-peak hours. Make sure that your application is configured to automatically reconnect to the AnalyticDB for MySQL cluster.

Update duration

A minor version update requires approximately 30 minutes.

View the minor version of a cluster

View the minor version of a cluster in the AnalyticDB for MySQL 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. On the Clusters page, click an edition tab. Find the cluster that you want to manage and click the cluster ID.
In the Configuration Information section of the Cluster Information page, view the Current Minor Version parameter of the cluster.

Query the minor version of a cluster by executing an SQL statement

Go to the SQL editor.
- Enterprise Edition, Basic Edition, and Data Lakehouse Edition: Log on to the AnalyticDB for MySQL console. Find the cluster that you want to manage and click the cluster ID. In the left-side navigation pane, choose Job Development > SQL Development.
- Data Warehouse Edition: Connect to the AnalyticDB for MySQL cluster that you want to manage.

Execute the following SQL statement to query the minor version of the cluster:

SELECT adb_version();

In the following sample result, the source_version parameter indicates the minor version number:

+----------------+----------------+---------------------+-------------+---------------------+
| 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 |
+----------------+----------------+---------------------+-------------+---------------------+

Update the minor version of a cluster

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 Clusters page, click an edition tab. Find the cluster that you want to manage and click the cluster ID.
In the Configuration Information section of the Cluster Information page, view the Current Minor Version parameter of the cluster.
Click Update Version next to the current minor version of the cluster.
Note
If the Update Version button is dimmed, the current minor version of the cluster is the latest version.

In the Update Version dialog box, specify the update time and the desired minor version.

Parameter	Description
Current Version	The current minor version of the cluster.
Updatable Version	The desired minor version. You can view the features supported by different minor versions in Release notes.
Update Time	The time when you want to update the minor version. Valid values: Within Maintenance Window: updates the minor version within the maintenance window of the cluster. After you click OK, AnalyticDB for MySQL delivers the update job, completes preprocessing, and then waits for the maintenance window. Immediate: updates the minor version immediately after you click OK.

Click OK.
Warning
When you update the minor version of an AnalyticDB for MySQL cluster, transient connections may occur within seconds. We recommend that you perform an update during off-peak hours. Make sure that your application is configured to automatically reconnect to the AnalyticDB for MySQL cluster.

Related operations

Edition	API operation
Enterprise Edition, Basic Edition, or Data Lakehouse Edition	DescribeKernelVersion UpgradeKernelVersion
Data Warehouse Edition	DescribeKernelVersion UpgradeKernelVersion