Tiered storage Limited availabilty
Tiered storage in Aiven for ClickHouse® allows you to use storage resources efficiently and can help reduce storage costs of your service.
This feature is in limited availability. Contact your account team to enable it for your project.
Tiered storage feature
The tiered storage feature introduces a method of organizing and storing data in two tiers for improved efficiency and cost optimization. The data is automatically moved to an appropriate tier based on your database's local disk usage.
Access tiered storage details
When enabled on your service, tiered storage along with its details can be accessed in the Aiven Console:
- Click Tiered storage in the service page or
- Click Databases and tables > Actions > View details > Storage details in the service page.
Enable tiered storage in Aiven for ClickHouse®
Find out how to enable the tiered storage feature on your project and activate it for specific tables. To learn what tiered storage is, how it works, and why use it, see Tiered storage in Aiven for ClickHouse®.
Configure data retention thresholds in Aiven for ClickHouse®'s tiered storage
Learn to control how your data is distributed between storage devices in the tiered storage of an Aiven for ClickHouse service. Configure tables so that your data is automatically written either to SSD or object storage as needed.
Check data distribution between storage devices in Aiven for ClickHouse®'s tiered storage
Monitor how your data is distributed between the two layers of your tiered storage: SSD and object storage.
Transfer data between storage devices in Aiven for ClickHouse®'s tiered storage
After enabling the tiered storage feature, you can move your data from SSD to object storage. Next, you may want to size down your SSD by selecting a service plan with less SSD capacity. Later, you can move your data from object storage back to your SSD if needed. Both operations can be performed using SQL statements against your tables directly.