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.

Prerequisites

An AnalyticDB for MySQL Data Warehouse Edition cluster is created.

Important

To update the minor version of an AnalyticDB for MySQL Data Lakehouse Edition cluster, submit a ticket.

Usage notes

When you update the minor version of an AnalyticDB for MySQL cluster, the cluster may encounter transient connections and remain in the read-only state for up to 30 seconds before all data is synchronized. We recommend that you perform the update during off-peak hours. Make sure that your application is configured to automatically reconnect to the AnalyticDB for MySQL cluster.

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 Data Warehouse 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 of the cluster.

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

Connect to an AnalyticDB for MySQL cluster. For more information, see Connect to an AnalyticDB for MySQL cluster.

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 Data Warehouse 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 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 minor version to which you want to update the cluster.

Parameter	Description
Current Version	The current minor version of the cluster.
Updatable Version	The minor version to which you can update the cluster. For information about the minor versions of AnalyticDB for MySQL, see 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. For more information, see Configure a 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, the cluster may encounter transient connections and remain in the read-only state for up to 30 seconds before all data is synchronized. We recommend that you perform the update during off-peak hours. Make sure that your application is configured to automatically reconnect to the AnalyticDB for MySQL cluster.

AnalyticDB:Update the minor version of a cluster