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
You cannot enable the In-memory Column Index (IMCI) feature and the failover with hot standby feature at the same time. If a cluster contains a read-only node for which the failover with hot standby feature is enabled, you cannot add read-only column store nodes to the cluster.
If you enable the serverless feature for a PolarDB for MySQL 8.0.2 Enterprise Edition cluster, you cannot add read-only column store nodes to the cluster.
Procedure
- Log on to the PolarDB console.
- In the upper-left corner of the console, select the region in which the cluster that you want to manage is deployed.
- Open the Add/Remove Node dialog box by using one of the following methods:
- Open the Add/Remove Node dialog box on the Clusters page.
Find the cluster that you want to manage and click Add/Remove Node in the Actions column.
- Open the Add/Remove Node dialog box on the Basic Information page of the cluster.
- Find the cluster that you want to manage and click the cluster ID. The Basic Information page appears.
- In the Database Nodes section, click the
icon to change the display mode.
- Click Add/Remove Node.
- Open the Add/Remove Node dialog box on the Clusters page.
- Select Add Node and click OK.
Click + Add a read-only node.
Select Enable for Columnstore Index.
Set Switching Time, select Terms of Service, and then click Buy Now.
Result
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.