clickhouse-backup

Tool for easy ClickHouse backup and restore using object storage for backup files. (by Altinity)

Clickhouse-backup Alternatives

Similar projects and alternatives to clickhouse-backup

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better clickhouse-backup alternative or higher similarity.

clickhouse-backup reviews and mentions

Posts with mentions or reviews of clickhouse-backup. We have used some of these posts to build our list of alternatives and similar projects.
  • Backing up Plausible Analytics database
    1 project | /r/Clickhouse | 3 Aug 2021
    I set up Plausible Analytics in my Kubernetes cluster and am trying to figure out how to properly back up and restore the Clickhouse database. I am trying to use https://github.com/AlexAkulov/clickhouse-backup but it only supports table of the MergeTree family. Plausible uses a table named schema_migrations which is of type TinyLog, so it's skipped during backups, making restores useless (because the table is restored empty, when Plausible starts it will try to run all the migrations which will fail because the other tables already exist).
  • Difference in data size for the Clickhouse backups
    1 project | /r/Clickhouse | 28 Jul 2021
    already fixed on https://github.com/AlexAkulov/clickhouse-backup/issues/224
  • The ClickHouse Community
    1 project | news.ycombinator.com | 17 May 2021
    Similar experience to vulkoingim: steep learning curve but quite stable once deployed properly.

    Schema management in zookeeper has been the biggest pain point for us. Occasionally individual clickhouse shards will get out of sync during a schema update, which can be hard to diagnose.

    We use a heavily modified version of clickhouse-backup[1], which works well for us.

    As for hands-off replica reboot: you must have an automated process to reapply the same schema which exists in zookeeper, otherwise it won't resync. If the local schema gets out of sync with that in zookeeper, then you'll have issues again.

    I expect a lot of these ergonomics issues will be fixed over time. It's already much easier to use than it was 3 years ago, and even if progress on usability and reducing the learning curve is slow the database performance makes it worth it.

    [1] https://github.com/AlexAkulov/clickhouse-backup

  • ClickHouse incremental backups
    1 project | dev.to | 14 Jan 2021
    clickhouse-backup allows us to perform local backups, that are always full backups, and full or incremental uploads to remote storage. In my previous post I talked about how to perform full backups and uploads. Now we are going to review all the steps required to work with incremental uploads. This way we could upload a weekly full backup to our remote storage and perform daily incremental uploads.
  • Backup and restore with clickhouse-backup
    1 project | dev.to | 13 Jan 2021
    We can automate this process thanks to clickhouse-backup.
  • A note from our sponsor - SaaSHub
    www.saashub.com | 24 Apr 2024
    SaaSHub helps you find the best software and product alternatives Learn more →

Stats

Basic clickhouse-backup repo stats
5
1,139
9.6
13 days ago

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com