PolarDB:Manage a columnar node

Background information

The Clustered Columnar Index (CCI) feature of PolarDB-X adopts a component-based read/write splitting architecture. This architecture consists of two components: column store nodes and compute nodes. Column store nodes write row-oriented storage data and compute nodes read the data. When a PolarDB-X instance is created, the system automatically creates columnar nodes. You can manage the version upgrades and change specifications of columnar nodes.

Usage notes

• The CCI feature is supported only for Enterprise Edition.

• The version of your PolarDB-X instance is 5.4.19-16989811 or later.

Procedure

1. Log on to the PolarDB-X console.

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

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

4. Find the instance and click the instance ID.

5. In the left-side navigation pane, click Column Storage Engine. On the page that appears, you can perform the following operations:

   • Upgrade

     In the upper-right corner of the page, click Upgrade Column Storage Engine. In the dialog box that appears, select the version to which you want to update and click OK.

     Important

     In the instance list, the Version column displays the version of columnar nodes in the current instance. Version upgrades cause service interruption during CCI synchronization and synchronization latency for several tens of seconds.

     When you select a destination version, we recommend that you select the latest version, which is also the version displayed by default.

   • Change specifications

     In the upper-right corner of the page, click Change Specifications and then OK. Wait until the task is completed.

     Important

     Configuration changes cause service interruption during CCI synchronization and therefore synchronization latency for several tens of seconds.