ClickHouse Data Management Internals — Understanding MergeTree Storage, Merges, and Replication

ClickHouse Data Management Internals — Understanding MergeTree Storage, Merges, and Replication

ClickHouse manages huge amounts of data in MergeTree tables. But how is MergeTree organized in storage? What’s a merge and how does it work? How does ClickHouse replicate data and commands across clusters? And what’s a mutation? Our talk explains these features and more. We’ll even discuss mysteries like hard links and the DDL replication queue. Our answers focus on the knowledge necessary to run ClickHouse efficiently and avoid problems. Bring your curiosity and questions!

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

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

Backups protect ClickHouse data in cases ranging from accidentally dropping a database to data centers burning down. In this webinar, we’ll compare available backup options for ClickHouse,  then zero in on clickhouse-backup, a popular open-source project that Altinity maintains. The presentation will discuss how clickhouse-backup works, standard backup and restore commands, and tips for reliable operation in production systems. We’ll end with Q & A. Join us if you love your ClickHouse data and want to ensure it sticks around!