Connection string with failover hosts

[Timur Luchkin]

Is it possible to specify several hosts with citus_add_node? 

It will allow automatically redirect coordinator's connections in case of worker's failover.

For example , like libpq string for psql:

psql -d 'host=masterIP,replicaIP1,replicaIP2 port=5432 dbname=mydb user=postgres target_session_attrs=read-write'

If it is not supported, - do U have a plans to implements this any time soon?

Thanks.

[jelte....@microsoft.com]

You can create multiple read replica clusters by using different clustername values for each of the nodes in the different clusters. 

[Timur Luchkin]

Hi Jelte

I got your reply regarding READ replicas in other topic. 

But here I want to specify multiple connections to the WRITE worker (master db) . During the opening of connection from coordinator to worker it should choose the actual master DB from the list  (using libpq flag "target_session_attrs=read-write" flag or java's equivalent  "targetServerType=master").

[jelte....@microsoft.com]

You cannot specify multiple hosts at the same time for a node. The current recommendation is to call citus_update_node as part of your worekr failover procedure to change the hostname/port of the worker that failed over. 

[Timur Luchkin]

thank U