View and update the engine version of a PolarDB for Xscale instance - PolarDB

Check which engine version your PolarDB for Xscale instance runs on, and update it to access the latest features.

Prerequisites

A PolarDB for Xscale instance
Access to the PolarDB for Xscale console

View the engine version

Use either the console or SQL to check the engine version of your instance.

Console

Log on to the PolarDB-X console.
In the top navigation bar, select the region where your instance resides.
On the Instances page, click the PolarDB-X 2.0 tab.
Click the ID of your instance.
In the Configuration Information section of the Basic Information page, find the Version parameter.

SQL

Connect to a database in your PolarDB for Xscale instance and run the following statement:

SELECT VERSION();

Sample output:

+-----------------------------+
| VERSION()                   |
+-----------------------------+
| 5.6.29-TDDL-5.4.8-16079964 |
+-----------------------------+
1 row in set (0.00 sec)

Note

In this output, 5.4.8-16079964 is the engine version of the instance.
For instructions on connecting to a database, see Connect to a database.

Update the engine version

Update the engine version of your PolarDB for Xscale instance to access the latest features.

Potential impacts

Warning

After you update the engine version of a PolarDB for Xscale instance, the primary instance and the read-only instances that are associated with the primary instance are all updated to the latest version.
During the update process, transient connections occur and a few errors are reported. We recommend that you perform the update during off-peak hours.

Procedure

Log on to the PolarDB-X console.
In the top navigation bar, select the region where your instance resides.
On the Instances page, click the PolarDB-X 2.0 tab.
Click the ID of your instance.
In the Configuration Information section of the Basic Information page, click Update Kernel version.
- Enterprise Edition: In the Update Kernel version dialog box, you can select the latest version or a recommended version to which you want to update your instance.
- Standard Edition: After the update task starts, you can click the icon in the upper-right corner to check the progress of the update task.