Learn how to enable the cold data archiving feature and view information about cold data archived in OSS.
Applicable scope
Archiving in CSV format
If the product edition is Cluster Edition, the Milvus version must be one of the following:
MySQL 8.0.1, minor version 8.0.1.1.47 or later.
MySQL 8.0.2, revision version 8.0.2.2.10 or later.
For the Multi-master Cluster (Limitless) Edition, the kernel version must be 8.0.1.0.13 or later.
Archiving in ORC format
For the Cluster Edition, the revision version must be 8.0.2.2.30 or later.
For the Multi-master Cluster (Limitless) Edition, the revision version must be 8.0.2.2.30 or later.
Archiving in X-Engine format
Archiving standard tables:
MySQL 8.0.1 with revision 8.0.1.1.31 or later.
MySQL 8.0.2 with revision 8.0.2.2.12 or later.
Archiving partitioned tables: MySQL 8.0.2 with revision 8.0.2.2.12 or later.
Archiving as an X-Engine column-oriented table: MySQL 8.0.2 with revision 8.0.2.2.33 or later.
Limitations
Cold data tables in OSS do not support backup and restore and are skipped by default when you restore a cluster from a backup.
You cannot access data in cold data tables from a secondary cluster in a Global Database Network (GDN).
Enable cold data archiving
Log on to the PolarDB console.
In the navigation pane on the left, click Clusters.
In the upper-left corner, select the cluster's region.
On the Clusters page, click the target cluster.
In the left-side navigation pane, choose .
On the Data Archive (Cold Data) tab, click Enable.
View archived cold data
After you enable cold data archiving, use the Cold Data Archiving tab to view the amount of cold data in OSS and details of the corresponding databases and tables.
Once enabled, cold data archiving cannot be disabled. You are not charged if the console shows a cold data usage of 0.