PolarDB:Upgrade Standard Edition to Enterprise Edition

Background

As business grows, users of PolarDB-X Standard Edition may encounter the bottlenecks typical of single-node databases. These issues can include poor query performance on large tables, high database load from concurrent queries, and an inability to meet analytical demands. At this stage, vertically scaling the database is often insufficient and not cost-effective.

PolarDB-X lets you upgrade a Standard Edition instance to an Enterprise Edition instance. The upgrade leverages distributed features and Hybrid Transactional/Analytical Processing (HTAP) to resolve the limitations of a single-node database while maintaining a user experience similar to a standalone MySQL database.

Prerequisites

• The PolarDB-X Standard Edition instance must be upgraded to the latest kernel version.

• If the PolarDB-X Standard Edition instance has a public endpoint, you must first release the public endpoint.

• During the upgrade, the data node specifications for the Enterprise Edition instance must match those of the current Standard Edition instance. If you want to increase the data node specifications for the Enterprise Edition instance, you must first upgrade the specifications of the Standard Edition instance.

Pre-upgrade check

1. Log on to the PolarDB-X console.

2. In the top navigation bar, select the region where the instance is deployed.

3. On the Instances page, click the PolarDB-X 2.0 tab.

4. Find the instance that you want to manage and click its ID.

5. In the Upgrade to Enterprise Edition section, click Upgrade to Enterprise Edition.

6. Before the upgrade, you must run a pre-check. In the background, a temporary Enterprise Edition instance is created that shares the data node with the Standard Edition instance. Click Start Check. The following items are checked:

   Check item	Description	Pass criterion
   Account	Checks whether accounts can be imported.	Database accounts on the Standard Edition instance can be successfully imported into the temporary Enterprise Edition instance.
   Whitelist	Checks whether whitelists can be imported.	Whitelists on the Standard Edition instance can be successfully imported into the temporary Enterprise Edition instance.
   XA transaction	Checks for the existence of XA transactions.	Enterprise Edition instances do not support XA transaction-related commands. The check runs the XA RECOVER command on the Standard Edition instance to verify that no active XA transactions exist.
   Number of databases	Checks if the number of databases exceeds the limit for Enterprise Edition.	The number of business databases on the Standard Edition instance must not exceed the logical database limit of Enterprise Edition. If this check fails, contact us.
   Stored procedure or custom function	Checks for user-created stored procedures or custom functions.	No user-created stored procedures or custom functions exist.
   Endpoint	Checks if there is only one endpoint.	Only one VPC endpoint exists.
   Read-only instance	Checks for the existence of read-only instances.	No read-only instances exist.
   Isolation level	Checks if the isolation level is supported by Enterprise Edition.	The isolation level is supported by Enterprise Edition.

7. Click OK. PolarDB-X initiates an upgrade check task. You can click the task icon in the upper-right corner to view the task progress.

   After the check task is complete, view the results in the Upgrade to Enterprise Edition dialog box.

Upgrade to Enterprise Edition