Minor version updates for AnalyticDB for MySQL clusters deliver bug fixes, performance improvements, and new features. This topic explains how to check your current minor version and update it through the console.
Prerequisites
Before you begin, ensure that you have:
An AnalyticDB for MySQL cluster
Access to the AnalyticDB for MySQL console
Potential impacts
The impact varies by cluster edition.
| Edition | Impact during update |
|---|---|
| Enterprise Edition, Data Lakehouse Edition, Data Warehouse Edition (elastic mode – Cluster Edition), Data Warehouse Edition (reserved mode) | Control operations and INSERT OVERWRITE statements are blocked. |
| Data Warehouse Edition (elastic mode – Standalone Edition) | All read, write, and control operations are blocked. The cluster remains in the unavailable state. |
All editions: Transient connections may occur within seconds during the update. Schedule updates during off-peak hours and configure your application to automatically reconnect to the cluster.
Update duration
A minor version update takes approximately 30 minutes.
Check the current minor version
Check in the console
Log on to the AnalyticDB for MySQL console. In the upper-left corner, select a region. In the left-side navigation pane, click Clusters.
On the Clusters page, click an edition tab, find the cluster, and click the cluster ID.
On the Cluster Information page, go to the Configuration Information section and find the Current Minor Version parameter.
Check by running an SQL statement
Open the SQL editor for your cluster:
Enterprise Edition, Basic Edition, Data Lakehouse Edition: In the left-side navigation pane, choose Job Development > SQL Development.
Data Warehouse Edition: Connect to the cluster.
Run the following SQL statement:
SELECT adb_version();The
source_versioncolumn in the output shows 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
Log on to the AnalyticDB for MySQL console. In the upper-left corner, select a region. In the left-side navigation pane, click Clusters.
On the Clusters page, click an edition tab, find the cluster, and click the cluster ID.
On the Cluster Information page, go to the Configuration Information section and click Update Version next to the Current Minor Version parameter.
NoteIf Update Version is dimmed, the cluster is already running the latest minor version.
In the Update Version dialog box, configure the following parameters:
Parameter Description Current Version The current minor version of the cluster (read-only). Updatable Version The target minor version. See Release notes for features available in each version. Update Time When to apply the update. Within Maintenance Window delivers the update job, completes preprocessing, and then waits for the cluster's maintenance window before applying the update. Immediate applies the update as soon as you click OK. Click OK.
Verify the update
After the update completes, confirm the new version is active:
Console: On the Cluster Information page, check that Current Minor Version in the Configuration Information section shows the expected version number.
SQL: Run
SELECT adb_version();and verify thesource_versionvalue matches the target version.
API reference
| Edition | API operations |
|---|---|
| Enterprise Edition, Basic Edition, Data Lakehouse Edition | DescribeKernelVersion, UpgradeKernelVersion |
| Data Warehouse Edition | DescribeKernelVersion, UpgradeKernelVersion |