Safety First! Using clickhouse-backup for ClickHouse® Backup and Restore | ClickHouse Webinar

Have questions about ClickHouse? Get a free consultation with Altinity. No pressure, no sales talk. Just answers to your questions. Book a free help session: hubs.la/Q02qr1RZ0
_____________________________________________________________
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

[@Altinity]

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

[@2103greg]

For clickhouse-backup, is it better to use the embedded method or the non-embedded method?

[@Altinity]

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

[@marckeelingiv9405]

I didn't hear anything about the "watch" command being used. I'd love a 5-10 minute demo on that part.

[@lancelotsir2954]

hi guys, I don't fully understand, how can I create an incremental copy locally?

[@vargas4762]

Fantatisct tool !!!
How could i test my backups ? only with restoring ?

[@roberthodges1480]

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

[@AbhishekChaudhary-no8qp]

This is for amd only how can i do it using arm server