Safety First! Using clickhouse-backup for ClickHouse® Backup and Restore | ClickHouse Webinar
ฝัง
- เผยแพร่เมื่อ 7 ธ.ค. 2024
- Experience the unmatched power of ClickHouse® on Hetzner: altinity.com/a...
_____________________________________________________________
Backups protect ClickHouse data 🔐 in cases ranging from accidentally dropping a database to data centers burning down. 🔥 In this webinar, we compare available backup options for ClickHouse, then zero in on clickhouse-backup, a popular open-source project that Altinity maintains.
The presentation discusses how clickhouse-backup works, standard backup and restore commands, and tips for reliable operation in production systems.
========================
PRESENTATION SLIDES
========================
altinity.com/w...
==================================
MANAGED CLOUD FOR CLICKHOUSE
==================================
altinity.com/m...
====================
RESOURCES
====================
Altinity Knowledge Base for ClickHouse: kb.altinity.com/
Altinity Documentation for ClickHouse: docs.altinity.com
Altinity Stable Builds for ClickHouse: altinity.com/a...
Training for ClickHouse: altinity.com/c...
Altinity vs other ClickHouse vendors: altinity.com/a...
====================
COMMUNITY
====================
🧑🏽💻 Join the Community: www.altinity.c...
🙋🏽 Get Support on Slack: www.altinity.c...
⭐️ Star on GitHub: github.com/Alt...
🌐 Connect on LI: / 10955938
🌐 Follow on 𝕏: / altinitydb
🌐 Say Hi on Reddit: / clickhouse
#clickhouse #opensource #databackup #datasecurity #datawarehouse #cloud #devops #realtimedata #databasemanagement #dbms #realtimeanalytics #Altinity #dataanalytics #webinar #opensourcecommunity
Want to be the smartest ClickHouse developer in the room?
Then sign up to our newsletter to get ClickHouse tips and tricks straight to your inbox. Sign up here: hubs.ly/Q02pp8vh0
Fantatisct tool !!!
How could i test my backups ? only with restoring ?
Hi! Thanks for the question. The best way to test is to restore to a different location: either a different ClickHouse server (use a docker image for quick tests) or restore individual databases/files to a different location on the same server.
You can use the 'clickhouse-backup restore -m' option for the latter case. Here's a full example:
sudo -u clickhouse clickhouse-backup restore \
-t 'default.ex2,default.bar' \
-m 'default:default2' my_backup
For clickhouse-backup, is it better to use the embedded method or the non-embedded method?
It depends on your use case, such as how and where you are storing your backups. The non-embedded method was the original concept behind this project.
PS: feel free to get more guidance in our slack channel (altinity.com/slack). We also do free 45 min calls (don’t worry, we won’t try to sell you anything). Just fill in the form here: hubs.la/Q02GGt9x0
I didn't hear anything about the "watch" command being used. I'd love a 5-10 minute demo on that part.
hi guys, I don't fully understand, how can I create an incremental copy locally?
This is for amd only how can i do it using arm server