When a PolarDB-X Standard Edition instance hits performance ceilings — large table query degradation, high-concurrency overload, or insufficient analytical capability — vertical scaling alone cannot solve the problem. This topic describes how to upgrade a PolarDB-X instance from Standard Edition to Enterprise Edition. Enterprise Edition resolves these issues by using distributed features and HTAP capabilities while preserving the MySQL database user experience.
| Symptom | Enterprise Edition solution |
|---|---|
| Slow queries on large tables | Distributed query execution |
| Service degradation under high-concurrency load | Horizontal scaling across compute nodes |
| Limited analytical capabilities | Hybrid transactional/analytical processing (HTAP) |
Prerequisites
Before you begin, make sure that:
The Standard Edition instance is running the latest database engine version. Upgrade the engine version if needed.
No public endpoint is attached to the instance. Release the public endpoint before proceeding.
The data node specifications are already set to the size you want in Enterprise Edition. You cannot change data node specifications during the edition upgrade — upgrade them on the Standard Edition instance first if needed.
Run a precheck
Before purchasing the Enterprise Edition, run a precheck to confirm the instance is eligible. PolarDB-X creates a temporary Enterprise Edition instance in the background — it shares the same storage node as your Standard Edition instance — and runs the following checks.
| Check item | Pass criterion |
|---|---|
| Accounts | Database accounts can be imported to the Enterprise Edition instance |
| Whitelists | Whitelists can be imported to the Enterprise Edition instance |
| XA transactions | No eXtended Architecture (XA) transaction-related statements are in use (Enterprise Edition does not support XA transactions; the XA RECOVER statement is sent to the Standard Edition instance) |
| Number of databases | Does not exceed the logical database limit of Enterprise Edition. If this check fails, contact technical support |
| Stored procedures or custom functions | None exist |
| Endpoint | Only one VPC endpoint exists |
| Read-only instances | None exist |
| Isolation level | Supported by Enterprise Edition |
To run the precheck:
Log on to the PolarDB-X console.
In the top navigation bar, select the region where the instance is deployed.
On the Instances page, click the PolarDB-X 2.0 tab.
Click the instance ID.
In the Common Operations section, click Upgrade to Enterprise Edition.
Click Start Check, then click OK to confirm. PolarDB-X starts the check task in the background. Click the icon in the upper-right corner to monitor progress.
Wait for the check to complete before proceeding to the next step. Do not start the upgrade while the check is still running.
After the check completes, review the results in the Upgrade to Enterprise Edition dialog box. Resolve any failed items before continuing.
Upgrade to Enterprise Edition
Note the following before you start:
Switchover causes a service interruption of several minutes while the data nodes restart.
Cleanup removes all Standard Edition resources and cannot be rolled back. Verify that the Enterprise Edition instance is working correctly before you run cleanup.
In the Upgrade to Enterprise dialog box, click Upgrade.
On the Upgrade Configuration page, select the specifications and number of compute nodes.
Click Buy Now, then click Sign and Purchase.
On the Basic Information page, click the icon in the upper-right corner to open the task list and monitor progress.
After the task reaches the Metadata Imported state, click Switch over. The switchover redirects traffic to the Enterprise Edition instance by switching the endpoint and restarting the data nodes. Service is unavailable for several minutes during this step.
After verifying the Enterprise Edition instance is working correctly, click Clean up.
ImportantCleanup removes the Standard Edition instance resources. This action cannot be rolled back.
The instance edition updates to Enterprise Edition on the Instance List page within a few minutes.
Operations during the upgrade
At any point during the upgrade, you can perform the following operations from the task list.
| Operation | Description |
|---|---|
| Switchover | Redirects traffic to the Enterprise Edition instance. Switches the endpoint and restarts the data nodes. Required to complete the upgrade. |
| Cleanup | Removes residual Standard Edition metadata. Required to complete the upgrade. Cannot be rolled back. |
| Switchback | Rolls back the switchover. Redirects traffic back to the Standard Edition instance and restarts the data nodes in Standard Edition mode. |
| Cancel | Terminates the upgrade. The order is refunded. |
The following diagram shows the upgrade process.
