All Products
Search
Document Center

PolarDB:Enable cold data archiving

Last Updated:Dec 25, 2024

This topic describes how to enable the cold data archiving feature for a cluster and how to view the information about the cold data archived in Object Storage Service (OSS).

Supported versions

Your cluster must meet the following requirements:

  • The cluster is of Cluster Edition and uses one of the following PolarDB for MySQL versions:

    • PolarDB for MySQL 8.0.1.1.31 or later

    • PolarDB for MySQL 8.0.2.2.9 or later

  • The cluster is of Multi-master Cluster (Database/Table) Edition and uses PolarDB for MySQL 8.0.1.0.13 or later.

Limits

  • You cannot backup or restore cold data tables in OSS. Cold data tables in OSS are skipped by default when a cluster is restored from backups. For more information about backup and restoration, see Overview.

  • You cannot access cold data tables in OSS from a secondary cluster in a GDN. For more information about how to manage a secondary cluster in a global database network (GDN), see Manage a secondary cluster.

Enable cold data archiving

  1. Log on to the PolarDB console.

  2. In the left-side navigation pane, click Clusters.

  3. In the upper-left corner, select the region in which the cluster that you want to manage is deployed.

  4. On the Clusters page, click the name of the cluster.

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

    image

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

View information about the cold data archived in OSS

After you enable the cold data archiving feature, you can view information about the cold data archived in OSS buckets on the Cold Data Archiving page, including the amount of archived cold data and information about the archived databases and tables.冷数据归档信息