All Products
Search
Document Center

PolarDB:Add a read-only column store node

Last Updated:Mar 27, 2025

This topic describes how to add a read-only column store node in the PolarDB console. Learn about the Supported versions and Usage notes before you proceed.

Supported versions

  • An Enterprise Edition cluster that meets one of the following requirements:

    • PolarDB for MySQL 8.0.1 whose revision version is 8.0.1.1.22 or later.

    • PolarDB for MySQL 8.0.2 whose revision version is 8.0.2.2.12 or later.

  • A Standard Edition cluster that uses the X86 CPU architecture and meets one of the following conditions:

    • PolarDB for MySQL 8.0.1 whose revision version is 8.0.1.1.38 or later

    • PolarDB for MySQL 8.0.2 whose revision version is 8.0.2.2.19 and later.

Usage notes

  • For a Multi-master Cluster (Limitless) cluster, 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 Configure cluster and node parameters.

  • For a cluster in a global database network (GDN), contact us for assistance before you can add a read-only column store node.

  • 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 or later or 8.0.2.2.23 or 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 us 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.

Procedure

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

Add a read-only column store node in the console

  1. Log on to the PolarDB console. Click Clusters in the left-side navigation pane. In the upper-left corner of the page, select the region in which the cluster resides and then find the cluster in the list. Go to the Add/Remove Node dialog box by using one of the following methods:

    • On the Clusters page, click Add/Remove Node in the Actions column. image

    • On the Basic Information page of the cluster, click Add/Remove Node in the Database Nodes section.

      image

  2. Select Add Read-only IMCI Node and click OK.

    image

  3. Add a read-only column store node and complete the payment.

    1. Click +Add an IMCI Node and select the node specifications from the drop-down list.

    2. Set the Switching Time parameter.

    3. (Optional) View the terms of service and service level agreement.

    4. Click Buy Now.

    image

  4. After you complete the payment, go to the cluster details page. The node is successfully added after it enters the Running state. image

Add a read-only column store node when you purchase a cluster

In the cluster configuration page of the PolarDB buy page, find the Nodes parameter and set Read-only Column Store Nodes. After you complete the purchase, check whether read-only column store node is added. For more information, see the Results section of this topic.

image

Results

Log on to the PolarDB console, go to the Basic Information page of the cluster, and check whether the read-only column store node is added.

image

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

Related API operations

API

Description

CreateDBNodes

Adds a read-only node to a PolarDB cluster.