cloudflare / cloudflare/sqlalchemy-clickhouse

How to connect with the multiple host

Open
#70 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
325
Forks
101
PR merge metrics
No merged PRs in 30d

Description

For HA for the databases, it recommends providing alt_hosts as a parameter to the connection string. The clickhouse drive in the `pip install clickhouse-driver` supports parameters to pass in the connection uri. But how to achieve it in sqlalchemy-clickhouse. So, Is there a way to pass parameters in create engine to support alt_hosts

alt_hosts – list of alternative hosts for connection. `Example: clickhouse://username:password@host:port/database?alt_hosts=host1:port1,host2:port2`

It will assure that if the host is failing it will connect to the alternate host for high availability.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.