Add a read-only column store node - PolarDB

By default, a PolarDB for MySQL cluster contains a primary node and a read-only row store node. When you add a read-only node, you can choose to add a read-only row store node or a read-only column store node. This topic describes how to add a read-only column store node.

Usage notes

For a cluster of Multi-master Cluster (Database/Table) Edition, you can change the value of the loose_polar_enable_imci_with_mm parameter to ON and then add a global read-only column store node to the cluster. For more information about the parameter, see Parameter Configuration.
The In-Memory Column Index (IMCI) feature can be used together with the Voting Disk Service (VDS) module of the failover with hot replica feature only under these conditions. For more information about the feature, see Overview.
- For a cluster whose revision version is 8.0.1.1.42 and later or 8.0.2.2.23 and later:
  - If a cluster contains a read-only node where the failover with hot replica feature is enabled, you can add read-only column store nodes to the cluster.
  - If a read-only column store node already exists in a cluster, you cannot enable the hot standby feature for any read-only node in the cluster.
- For a cluster whose revision version is earlier than 8.0.1.1.42 or earlier than 8.0.2.2.23, the IMCI feature cannot be used together with failover with hot replica feature.
  - If a cluster contains a read-only node for which the failover with hot replica feature is enabled, you cannot add read-only column store nodes to the cluster.
    Note
    If you want to add a read-only column store node to the cluster, contact the technical support to disable VDS. When VDS is being disabled, all nodes in the cluster are automatically restarted.
  - If a read-only column store node already exists in a cluster, you cannot enable the hot standby feature for any read-only node in the cluster.

Prerequisites

Your cluster meets one of the following requirements:

A cluster of PolarDB for MySQL 8.0.1 whose revision version is 8.0.1.1.22 or later.
A cluster of PolarDB for MySQL 8.0.2 whose revision version is 8.0.2.2.12 or later.

Procedure

You can use one of the following methods to add read-only column store nodes:

In the cluster configuration page of the PolarDB buy page, find the Nodes parameter and set Read-only Column Store Nodes. Configure other parameters based on your business requirements. Click Buy Now to go to the cluster purchase page, complete required configurations, and then click Buy Now. On the Purchase page, click Subscribe. After you complete the purchase, check whether read-only column store nodes are added. For more information, see the Test results section of this topic.

Log on to the PolarDB console. Select the region where you want to create a cluster. Go to the Add/Remove Node dialog box by using one of the following methods:
- Access the Add/Remove Node dialog box from the Clusters page.
  Find the cluster that you want to manage and choose More > Add/Remove Node in the Actions column.
- Access the Add/Remove Node dialog box from the Basic Information page of the cluster.
  1. Find the cluster that you want to manage and click the cluster ID to go to the Basic Information page.
  2. In the Database Nodes section, click Add/Remove Node.
1. Select Add Read-only IMCI Node and click OK.
2. Click +Add an IMCI Node and select the node specifications from the drop-down list.
3. Set Switching Time as required. Select Terms of Service and click Buy Now.
4. Return to the Clusters page, and you can see the status of the cluster is Adding Node.

Results

After you make the payment, you are redirected to the Basic Information page of the cluster. After a while, the read-only column store node is added. 添加完成

In the preceding figure, Read-only Columnar Node is the new column store node, and Read-only Node is the original row store node.