ContentSquare / chproxy

Open-Source ClickHouse http proxy and load balancer
https://www.chproxy.org/
MIT License
1.24k stars 256 forks source link

[Feature] Fallback/backup node #424

Open pkesso opened 3 months ago

pkesso commented 3 months ago

I use chproxy for SELECT distribution. I have a single-node 'cluster' in chproxy config for this, however, when the designated node is not ok, I would like to pass requests to another node, which should not be used, when primary is available.

I woud like to have a 'backup' of 'fallback' node in cluster settings, similar to backup upstream in NGINX - the node to send traffic if primary is not available.

Node weight would be fine too.