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

Have burning ClickHouse questions?
Get a free consultation with Altinity. No pressure, no sales talk. Just answers to your questions. Book a call here: 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.
👀 Looking for the presentation slides? Here you go:
altinity.com/wp-content/uploa...
#clickhouse #opensource #databackup #datasecurity #datawarehouse #cloud #devops #realtimedata #databasemanagement #dbms #realtimeanalytics #Altinity #dataanalytics #webinar
-----------------
Join ClickHouse Meetups: www.meetup.com/san-francisco-...
Check out more ClickHouse resources: altinity.com/resources/
Visit the Altinity Documentation site: docs.altinity.com/
Contribute to ClickHouse Knowledge Base: kb.altinity.com/
Join the ClickHouse Reddit community: / clickhouse
----------------
Learn more about Altinity! 💡
Site: www.altinity.com​
LinkedIn: / altinity
Twitter: / altinitydb
Slack: altinitydbworkspace.slack.com...

[@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

[@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

[@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?

[@AbhishekChaudhary-no8qp]

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