Altinity Backup for ClickHouse®
Protect your ClickHouse® data
Easily safeguard your ClickHouse data with a reliable tool for backup and restore.
I found that clickhouse-backup by @AltinityDB is the best choice [to use for backing up data]. Using it with incremental backups makes it a breeze to backup and restore without wasting space in your bucket.
Carl L
What is Altinity Backup for ClickHouse?
Altinity Backup for ClickHouse is a popular open-source utility designed to simplify the backup and restoration of ClickHouse databases. It supports various storage solutions, including cloud services like AWS S3, Google Cloud Storage, Azure Blob Storage, and protocols such as FTP and SFTP.
Key features
- Comprehensive Backup and Restore: Efficiently create and restore backups for entire databases or specific tables.
- Flexible Storage Options: Store backups locally or in remote object storage systems, providing versatility in data management.
- Incremental Backups: Support for incremental backups reduces storage requirements and speeds up the backup process.
- Streaming Compression: Utilize streaming compression to optimize storage space and network usage during backup and restoration.
- Multi-Environment Support: Compatible with various environments, including multi-disk installations and Kubernetes deployments.
Why use the tool?
- Data Protection: Safeguard your ClickHouse data against accidental loss or corruption by maintaining regular backups.
- Disaster Recovery: Facilitate quick recovery from hardware failures or other catastrophic events, minimizing downtime.
- Migration and Testing: Easily migrate data between environments or set up testing scenarios without impacting production systems.
- Compliance: Meet data retention and recovery requirements mandated by industry regulations.
Curious about other backup tools for ClickHouse? Here is a comparison

Read more about Altinity Backup for ClickHouse®?
Safety First! Using Altinity Backup for ClickHouse® for ClickHouse Backup and Restore
Backups protect ClickHouse data in cases ranging from accidentally dropping a database to data centers burning down. In this webinar, we’ll compare available backup options for ClickHouse, then zero in on clickhouse-backup, a popular open-source project that Altinity maintains. The presentation…
Introduction to ClickHouse® Backups and Altinity Backup for ClickHouse®
Data backups are an inglorious but vital part of IT operations. They are most challenging in “big data” deployments, such as analytics databases. This article will explore the plumbing involved in backing up ClickHouse and introduce the clickhouse-backup tool for…