All Products
Search

This Product

    PolarDB:Add a read-only column store node

    Document Center

    PolarDB:Add a read-only column store node

    Last Updated:Mar 11, 2024

    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

    • The In-Memory Column Index (IMCI) feature cannot be used together with the Voting Disk Service (VDS) module of the failover with hot standby feature. For more information about the failover with hot standby feature, see Overview. If a cluster contains read-only nodes for which the failover with hot standby feature is enabled, VDS is enabled. In this case, you cannot add a read-only column store node to the cluster.

      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 you enable the serverless feature for a PolarDB for MySQL 8.0.2 Enterprise Edition cluster, you cannot add a read-only column store node to the cluster. For more information, see Overview.

    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.