v.20.1New Feature

Add Disk Migration Based on TTL for MergeTree Table Engines

Official CH changelog text
Add ability to move data between disks according to configured TTL-expressions for *MergeTree table engines family. #8140 (Vladimir Chebotarev)
Adds the capability to move data between different storage disks based on configured TTL expressions for tables using the *MergeTree family of engines.

Why it matters

This feature enables automated data management by relocating data to appropriate storage devices over time according to user-defined TTL rules. It helps optimize storage usage and costs by allowing older or less frequently accessed data to be stored on cheaper or slower disks, improving overall system efficiency.

How to use it

Define TTL expressions in the table schema that specify data lifecycle rules including movement between disks. ClickHouse will automatically execute these rules and move data parts accordingly without manual intervention.

Related resources

PreviousNext