ClickHouse / clickhouse-odbc

ODBC driver for ClickHouse
https://clickhouse.tech
Apache License 2.0
245 stars 86 forks source link

Multiple hosts/endpoints for HA and load balancing (like in clickhouse-jdbc) #385

Open UnamedRus opened 2 years ago

UnamedRus commented 2 years ago

Ability to define multiple hosts, which can be used by odbc driver for load balancing or HA.

Like for clickhouse-jdbc https://github.com/ClickHouse/clickhouse-jdbc/blob/c80b60bd81d1ad98e7a140590ef95f12ee6021d0/clickhouse-jdbc/src/test/java/ru/yandex/clickhouse/BalancedClickhouseDataSourceTest.java#L31

vertica-odbc

https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/ConnectingToVertica/ClientODBC/ODBCConnectionFailover.htm (backup host)

cassandra-odbc

https://docs.informatica.com/data-integration/powerexchange-adapters-for-powercenter/10-2/powerexchange-for-cassandra-user-guide-for-powercenter/powerexchange-for-cassandra-configuration/configuring-the-cassandra-odbc-advanced-properties-for-data-sour/cassandra-odbc-data-source-name-advanced-properties.html ( Whitelist hosts )