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

Connection and Loadbalancing to multiple clickhouse hosts

Open elghazal-a opened this issue 7 years ago • 2 comments

We have a clickhouse cluster, used for replication, and we want to connect to all the hosts and ensure a load balancing across healthy hosts or an automatic failover. Is this something that is scheduled to be implemented in the near future? Are you open for a pull requests?

elghazal-a avatar Sep 09 '18 12:09 elghazal-a

Sure, you can send pull request. I don’t have multiple servers, so I have only imaginary use cases against it.

On 9 Sep 2018, at 15:50, Elghazal Ahmed [email protected] wrote:

We have a clickhouse cluster, used for replication, and we want to connect to all the hosts and ensure a load balancing across healthy hosts or an automatic failover. Is this something that is scheduled to be implemented in the near future? Are you open for a pull requests?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

apla avatar Sep 09 '18 13:09 apla

@geniousphp

  1. May Distributed engine be enough for you?
  2. Do you have cases when you need to switch to any alive replica ASAP?
  3. Which kind of queries you need to be failover?

Looks like it may be related to #27

nezed avatar May 12 '19 23:05 nezed