Skip to main content

Transfer data between storage devices in Aiven for ClickHouse®'s tiered storage

Moving data from network-attached block storage to object storage allows you to size down your block storage by selecting a service plan with less capacity. You can move the data back to network-attached block storage anytime.

You can transfer data between storage devices in Aiven for ClickHouse® using SQL statements against your tables directly.

Prerequisites​

  • At least one Aiven for ClickHouse service
  • Command line tool (ClickHouse client) installed

Transfer data from network-attached block storage to object storage​

If you enable the tiered storage feature on your table, by default your data is moved from network-attached block storage to object storage as soon as it reaches 80% of its capacity.

  1. Connect to your Aiven for ClickHouse service using, for example, the ClickHouse client.

  2. Run the following query:

    ALTER TABLE database-name.tablename MODIFY SETTING storage_policy = 'tiered'

Now, with the tiered storage feature enabled, your data is moved from network-attached block storage to object storage when it reaches 80% of its capacity.

note

You can also configure your tiered storage so that data is moved to object storage at a specific time.

Transfer data from object storage to network-attached block storage​

Use the MOVE PARTITION|PART statement to transfer data to network-attached block storage.

  1. Connect to your Aiven for ClickHouse service using, for example, the ClickHouse client.

  2. Select a database for operations you intend to perform.

    USE database-name

  3. Run the following query:

    ALTER TABLE table_name MOVE PARTITION partition_expr TO VOLUME 'default'

Your data has been moved to network-attached block storage.

What's next​

Related pages