Deep Dive on ClickHouse® Sharding and Replication | Tutorial for ClickHouse®

Have questions about ClickHouse®? Get a free consultation with Altinity. Book a call here: hubs.la/Q02qr1RZ0 . No marketing BS. no sales talk during the call. Just answers to your questions.
_______________________________
Join us as we dig into ClickHouse sharding and replication, showing how they enable clusters that deliver fast queries over petabytes of data. We start with basic definitions of each, then move to practical issues. This includes the setup of shards and replicas, defining schema, choosing sharding keys, loading data, and writing distributed queries. We finish up with tips on performance optimization.
#ClickHouse #sharding #ClickHouseTutorial #ClickHouseCommunity #Altinity #opensourcedatabase
--------------
Join Altinity Meetups on ClickHouse: www.meetup.com/san-francisco-...
Check out more resources on ClickHouse: altinity.com/resources/
Visit the Altinity Documentation site: docs.altinity.com/
Contribute to Altinity Knowledge Base for ClickHouse: kb.altinity.com/
Join the Reddit community for ClickHouse: / clickhouse
-------------
More about Altinity! 💡
Site: www.altinity.com​
LinkedIn: / altinity
Twitter: / altinitydb
Slack: altinity.com/slack

[@Altinity]

Want to be the smartest ClickHouse developer in the room?

[@tanyashankina4906]

Thank you for your lecture, very helpful

[@Altinity]

See an updated webinar on this topic here:

[@101graffhead]

love the blog about clickhouse stuff, this all info about sharding is going to help me a lot in the inevitable migration we are gonna do, no one knows much beside querying clickhouse here. you people's love toward sharing information related to clickhouse is kind of peculiar but welcome regardless, almost none of the channels/blogs have this much information on clickhouse, also what are you guys thoughts on clickhouse keeper, its a new(at least new to me) alternative to zookeeper which is not written in java.

[@maheshc1417]

in distributed databases clickhouse given we have cluster with 2 shards distributed factor of 2 and replication factor of 2 how many nodes can be down while the data being fully available? please advise on this or provide your answer for it