Cold data refers to data that is infrequently updated and rarely queried in specific database tables in a PolarDB-X instance. To reduce data storage costs and ensure query performance, PolarDB-X allows you to archive cold data to low-cost storage in Object Storage Service (OSS).
PolarDB-X provides two cold data archiving solutions to meet different archiving requirements.
Archive cold data by row (row-level archiving): automatically archives cold data to OSS and then uses data manipulation language (DML)
DELETEoperations to remove cold data from online tables. This solution is also called the Time To Live (TTL) 2.0 solution.Archive cold data by partition (partition-level archiving): uses data definition language (DDL) operations such as
DROP PARTITIONto remove cold data from online tables, and automatically archives the removed data to OSS. This solution is also called the TTL 1.0 solution.