All Products
Search
Document Center

PolarDB:Add a read-only column store node

Last Updated:Oct 30, 2023

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

  1. Log on to the PolarDB console.
  2. In the upper-left corner of the console, select the region in which 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 Basic Information page of the cluster.
      1. Find the cluster that you want to manage and click the cluster ID. The Basic Information 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.

    添加节点
  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.添加完成

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