All Products
Search

This Product

    PolarDB:Enable cold data archiving

    Document Center

    PolarDB:Enable cold data archiving

    Last Updated:Sep 18, 2026

    This topic describes how to enable the cold data archiving feature and view information about cold data archived in OSS after the feature is enabled.

    Applicable scope

    • Archiving to CSV format

      • The cluster edition is Cluster Edition:

        • Archive a standard table:

          • MySQL 8.0.1 with a revision of 8.0.1.1.47 or later.

          • MySQL 8.0.2 with a revision of 8.0.2.2.10 or later.

        • Archive a partitioned table:

          • MySQL 8.0.2 with a revision of 8.0.2.2.34.1 or later.

      • The cluster edition is Multi-master Cluster (Limitless) Edition:

        • MySQL 8.0.1 with a revision of 8.0.1.0.13 or later.

    • Archiving to ORC format

      • The cluster edition is Cluster Edition:

        • Archive a standard table: MySQL 8.0.2 with a revision of 8.0.2.2.30 or later.

        • Archive a partitioned table: MySQL 8.0.2 with a revision of 8.0.2.2.34.1 or later.

      • The cluster edition is Multi-master Cluster (Limitless) Edition: MySQL 8.0.2 with a revision of 8.0.2.2.30 or later.

    • Archiving to IBD format

      • Basic Edition: MySQL 8.0.1 with a revision of 8.0.1.1.51.2 or later.

      • Advanced Edition: MySQL 8.0.2 with a revision of 8.0.2.2.37 or later. The storage type must be PSL4 or PSL5. ESSD cloud disks are not supported.

    • Archiving to X-Engine format

      • Archive a standard table:

        • MySQL 8.0.1 with a revision of 8.0.1.1.31 or later.

        • MySQL 8.0.2 with a revision of 8.0.2.2.12 or later.

      • Archive a partitioned table: MySQL 8.0.2 with a revision of 8.0.2.2.12 or later.

      • Archive to an X-Engine column-store table: MySQL 8.0.2 with a revision of 8.0.2.2.34.1 or later.

    Limitations

    Enable cold data archiving

    1. Log on to the PolarDB console.

    2. In the navigation pane on the left, click Clusters。

    3. In the upper-left corner, select the region where the cluster resides.

    4. On the Clusters page, click the target cluster.

    5. In the left-side navigation pane, choose Settings and Management > Data Lifecycle.

    6. On the Data Archive (Cold Data) tab, click Enable .

    7. (Optional) Archive a partitioned table as a hybrid partitioned table.

      • MySQL 8.0.2 and the minor version is 8.0.2.2.34.1 or later. You must set the loose_polar_allow_create_hybrid_partition parameter to ON.

      • MySQL 8.0.2 and the minor version is earlier than 8.0.2.2.34.1. Upgrade to a later minor version.

    View archived cold data

    After you enable cold data archiving, you can view the size of cold data stored in OSS and the database and table information on the Cold Data Archiving page.

    Important

    Cold data archiving cannot be disabled after it is enabled. If the console shows a cold data usage of 0, no additional fees are incurred.

    Related topics