Fault-tolerant Connections in ClickHouse Client

Why it matters

This feature addresses the need for high availability and reliability when connecting to ClickHouse servers. By specifying multiple hosts and ports in the clickhouse-client command, users can ensure that client connections automatically fail over to the next available server, minimizing downtime and connection errors.

How to use it

When launching the clickhouse-client, users can specify multiple hosts and ports in the command line as follows:

clickhouse-client --host host1 --host host2 --port port2 --host host3 --port port --host host4

The client will attempt to connect to the hosts and ports in the order provided, moving on to the next if the previous is unavailable.