clickhouse-datasource icon indicating copy to clipboard operation
clickhouse-datasource copied to clipboard

Support load-balancing and failover hosts

Open jonbuffington opened this issue 2 years ago • 1 comments

Is your feature request related to a problem? Please describe.

I would like to connect to multiple ClickHouse servers to support our load-balancing and failover requirements.

Describe the solution you'd like

Provide the values of host(s) as a comma-separated list per the clickhouse-go driver's DSN hosts field. See https://github.com/ClickHouse/clickhouse-go#dsn

Describe alternatives you've considered

Deploying a separate TCP proxy that would support native ClickHouse connections. The downside is that the client would not be directly aware of host connection failures (e.g., rolling update) and simply retry.

Additional context

N/A

jonbuffington avatar Jan 17 '23 15:01 jonbuffington

any updates here @jonbuffington ?

ceevaaa avatar Nov 23 '23 09:11 ceevaaa