Cost Effective Data Retention with Aiven for ClickHouse® Tiered Storage

Aiven for ClickHouse® has introduced tiered storage, which is now generally available in the Aiven console. This feature combines the speed of ClickHouse with the cost optimization of object storage to create a powerful data warehouse solution. Tiered storage can be enabled on a per-table basis and allows users to optimize costs by using object storage alongside existing SSD storage. By default, once an Aiven for ClickHouse instance's SSDs hit 80% capacity, data is automatically moved to object storage. This behavior can be further refined by creating an explicit TTL or manually moving data as needed. The tiered storage feature is useful in scenarios where query performance can be traded off for cost optimization, such as logs management.