CODEWITHSUNDEEP
insertclickhouseclickhouse-client
Ananth
Ananth

Reputation: 991

Insertion in distributed data tables for multiregion click house deployment

Say I have two regions - DC1 and DC2 . Let's consider that I have 9 nodes in DC1 and DC2 with 3 replicas in each DC for 5 shards. In this case , if I trigger an insert statement to a distributed table via java client or a http call to one of the servers in DC1 , how do I ensure that the healthy node chosen to perform this insert is within DC1? Does Clickhouse handle this automatically or do we need to give that intelligence during the query time via some approach?

Upvotes: 0

Views: 113

Answers (0)

Related Questions