apla / node-clickhouse

Yandex ClickHouse driver for nodejs
MIT License
216 stars 50 forks source link

Connection and Loadbalancing to multiple clickhouse hosts #19

Open elghazal-a opened 5 years ago

elghazal-a commented 5 years ago

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?

apla commented 5 years ago

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 notifications@github.com 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.

nezed commented 5 years ago

@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