By default, a PolarDB for MySQL cluster contains one primary node and one read-only node. When you add a read-only node, you can select 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.

Precautions

The in-memory column index feature cannot be enabled along with the failover with hot standby feature. If a cluster contains a read-only node where the failover with hot standby feature is enabled, you cannot add read-only column store nodes to the cluster.

Procedure

  1. Log on to the PolarDB console.
  2. In the upper-left corner of the console, select the region where the cluster that you want to manage is deployed.
  3. 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.

      Cluster list
    • Open the Add/Remove Node dialog box on the Overview page of the cluster.
      1. Find the cluster that you want to manage and click the cluster ID. The Overview page appears.
      2. In the Database Nodes section, click the 1 icon to change the display mode.
      3. Click Add/Remove Node.
      Basic information
  4. Select Add Node and click OK.
    Add or remove a node
  5. Click + Add a read-only node.
  6. Select Enable for Columnstore Index.
    Add a node
  7. 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. Node added

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