cloudflare / cloudflare/sqlalchemy-clickhouse
How to connect with the multiple host
Open
- 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
Assessment
This issue has not been assessed yet.