ClickHouse DBMS With Wasabi

  • Updated on Sep 10, 2025
  • Published on Aug 8, 2025
  • 1 minute(s) read
Prev Next

How do I use ClickHouse DBMS with Wasabi?

ClickHouse has been validated for use with Wasabi Object Storage. ClickHouse is a high-performance, open-source, column-oriented database management system (DBMS) designed for online analytical processing (OLAP) and real-time data analytics.

Prerequisites

  • ClickHouse Server v.23.0 or later

  • ClickHouse Backup Tool (Optional, but recommended)

  • ClickHouse Open Source or Paid Version

  • Active Wasabi Object Storage Account

  • Wasabi Access Keys

  • Wasabi Bucket

Reference Architecture Diagram

Configuration

Creating a Wasabi Bucket

  1. Log in to the Wasabi Console.

  2. Click Buckets then click Create Bucket.

  3. Enter a name (for example, “clickhouse-backup”).

  4. Select a region (for example, us-east-1).

  5. Be sure to keep Versioning and Object Lock disabled.

  6. Click Create.

Creating an IAM Sub-User

  1. Click Users then click Create User.

  2. Assign a name for the user (for Example, “clickhouse-s3-user).

  3. Select Programmatic Access.

  4. Create a new Group using the policy below:

{

 "Version": "2012-10-17",

 "Statement": [

   {

     "Effect": "Allow",

     "Action": [

       "s3:GetBucketLocation",

       "s3:ListAllMyBuckets"

     ],

     "Resource": "arn:aws:s3:::*"

   },

   {

     "Effect": "Allow",

     "Action": "s3:*",

     "Resource": [

       "arn:aws:s3:::clickhouse-backup",

       "arn:aws:s3:::clickhouse-backup/*"

     ]

   }

 ]

}

  1. Finish and download the Access and Secret Keys.

Installing ClickHouse

If ClickHouse is not installed, below is an example for Linux - Ubuntu:

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv E0C56BD4

echo "deb https://packages.clickhouse.com/deb stable main" | sudo tee /etc/apt/sources.list.d/clickhouse.list

sudo apt update

sudo apt install clickhouse-server clickhouse-client -y

sudo systemctl start clickhouse-server

Configuring S3 Disk in ClickHouse

  1. Create a file /etc/clickhouse-server/config.d/backup_disk.xml.

<clickhouse>

 <storage_configuration>

   <disks>

     <s3_backup>

       <type>s3</type>

       <endpoint>https://s3.ap-southeast-1.wasabisys.com/clickhouse-backup/</endpoint>

       <access_key_id>YOUR_ACCESS_KEY</access_key_id>

       <secret_access_key>YOUR_SECRET_KEY</secret_access_key>

       <s3_max_single_part_upload_size>10485760</s3_max_single_part_upload_size>

       <upload_part_size>67108864</upload_part_size>

       <s3_max_put_rps>25</s3_max_put_rps>

       <metadata_path>/var/lib/clickhouse/disks/s3_backup/metadata</metadata_path>

     </s3_backup>

   </disks>

 </storage_configuration>

</clickhouse>

  1. Restart ClickHouse.

sudo systemctl restart clickhouse-server

  1. Check log /var/log/clickhouse-server/clickhouse-server.log for confirmation.

Installing ClickHouse-Backup Tool (Optional)

This tool simplifies backup/export and upload to S3:

wget https://github.com/AlexAkulov/clickhouse-backup/releases/download/v2.5.3/clickhouse-backup

chmod +x clickhouse-backup

sudo mv clickhouse-backup /usr/local/bin/

Configuring ClickHouse-Backup Tool

Edit /etc/ClickHouse-backup/config.yml.

general:

 remote_storage: s3

 disable_progress_bar: true

s3:

 bucket: clickhouse-backup

 endpoint: s3.ap-southeast-1.wasabisys.com

 access_key: YOUR_ACCESS_KEY

 secret_key: YOUR_SECRET_KEY

 use_path_style: true

 compression_format: tar

 compression_level: 1

Running Backup and Restoring Operations

Backup a specific database:

clickhouse-backup create my_backup

clickhouse-backup upload my_backup

Restore a specific database:

clickhouse-backup download my_backup

clickhouse-backup restore my_backup

Verification on Wasabi

  1. Navigate to the Wasabi Console.

  2. Open the “clickhouse-backup” bucket.

  3. Verify that the backup folder/files exist.