How to set JDBC connection string for Clickhouse cluster

[gubinjie]

I set up a ClickHouse cluster with 3 partitions and 1 replica, but when I use a JDBC connection, I can only choose one of the IP addresses to use as the connection string, which has a single point of failure. I try to use nginx (ip: 30.23.78.112) as the listening port 8123 and forward the request to the Clickhouse host, so is the JDBC connection string (jdbc: clickhouse: //30.23.78.112: 8123 / database name) I use correct?

[4ertus2]

FYI, @alex-krash
I think it's an issue for https://github.com/ClickHouse/clickhouse-jdbc

[den-crane]

@gubinjie if you have a few instances, you can use **BalancedClickhouseDataSource**. https://github.com/ClickHouse/clickhouse-jdbc

https://github.com/ClickHouse/clickhouse-jdbc/blob/master/src/test/java/ru/yandex/clickhouse/settings/ClickHousePropertiesTest.java#L107

[todd5167]

@den-crane use BalancedClickhouseDataSource，need to use API to manipulate data, inconvenient

[den-crane]

@todd5167 That's OK. You can use another JDBC driver if you don't like this one.