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.
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-driversupports 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_hostsalt_hosts – list of alternative hosts for connection.
Example: clickhouse://username:password@host:port/database?alt_hosts=host1:port1,host2:port2It will assure that if the host is failing it will connect to the alternate host for high availability.