This topic describes how to upgrade the version and change the specifications of column store nodes in a PolarDB-X instance.
Background information
The Clustered Columnar Index (CCI) feature of PolarDB-X uses a read/write splitting architecture with two types of components:
Column store nodes: Write row store data.
Compute nodes: Read the data.
When you create a PolarDB-X instance, the system automatically creates column store nodes.
You can perform the following management operations on column store nodes:
| Operation | Description |
|---|---|
| Upgrade the column store engine version | Update column store nodes to a newer version for bug fixes, performance improvements, and new features. |
| Change column store node specifications | Adjust the resource allocation of column store nodes to meet changing workload requirements. |
Prerequisites
Your PolarDB-X instance uses the Enterprise Edition. The CCI feature is supported only for Enterprise Edition.
The version of your PolarDB-X instance is 5.4.19-16989811 or later.
Upgrade the column store engine version
You can upgrade column store nodes to a newer version. We recommend that you select the latest version, which is displayed by default in the upgrade dialog box.
When you upgrade the version, the instance restarts and a transient connection of about 1 minute occurs. If read-only instances exist, these instances are updated together with the primary instance. Make sure that the automatic reconnection feature is enabled for your application. We recommend that you perform version upgrades during off-peak hours to minimize the impact on your workload.
The Version column on the Column Storage Engine page displays the current version of column store nodes.
Procedure
Log on to the PolarDB-X console.
In the top navigation bar, select the region where the target instance is deployed.
On the Instance List page, click the PolarDB-X 2.0 tab.
Find the target instance and click the instance ID.
In the left-side navigation pane, click Column Storage Engine.
In the upper-right corner of the page, click Column-based Storage Engine Upgrade.
In the dialog box that appears, select the target version and click OK.
Verify the upgrade
After the upgrade is complete, go to the Column Storage Engine page and check the Version column to verify that the version has been updated.
Change column store node specifications
You can change the specifications of column store nodes based on workload requirements.
Specification changes cause a brief service interruption. We recommend that you perform specification changes during off-peak hours to minimize the impact on your workload.
Procedure
Log on to the PolarDB-X console.
In the top navigation bar, select the region where the target instance is deployed.
On the Instance List page, click the PolarDB-X 2.0 tab.
Find the target instance and click the instance ID.
In the left-side navigation pane, click Column Storage Engine.
In the upper-right corner of the page, click Change Specifications.
Select the target specifications, click OK, and wait until the task is complete.
Verify the specification change
After the specification change is complete, go to the Column Storage Engine page to verify that the new specifications are in effect.