-
clickhouse-backup
Tool for easy ClickHouse backup and restore using object storage for backup files.
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
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).
Related posts
-
Difference in data size for the Clickhouse backups
-
The ClickHouse Community
-
ClickHouse incremental backups
-
Backup and restore with clickhouse-backup
-
Out of a desire to backup my docker volumes, I created a small utility to periodically compress and upload a directory to S3. Since I'm only 9 months into my Rust journey, any advice is welcome!