DocsICP FilingConsole
Documentation
Home Page PolarDB PolarDB for MySQL User Guide Cold data archiving Enable cold data archiving

Enable cold data archiving

Updated at:
Copy as MD
Product
My Favorites

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.

Note

If you have any questions about the cold data archiving feature, search for the DingTalk group number to join the group for consultation. You can directly @ the experts in the group and attach your question.

DingTalk group number: 24490017825

Applicable scope

  • Archiving to CSV format

    • The cluster edition is Standard Edition or 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

Previous：What is cold data archivingNext：Used cold data archiving