[Postgres-xc-developers] proxy setup on standby server

[Bei Xu <be...@ad...>]

Hi, I want to set up HA for pgxc, please see below for my current setup.

server1: 1 GTM
server2: 1 GTM_Standby
server3 (master):  1 proxy
                                  1 coordinator
                                  2 datanode

Server4: (stream replication slave) :  1 standalone proxy ??
                                  1 replicated coordinator (slave of server3's coordinator)
                                   2 replicated datanode  (slave of server3's datanodes)


server3's coordinator and datanodes are the master of the server4's coordinator/datanodes by stream replication.

Question.
1. Should there be a proxy on server 4?   If not, which proxy  should the server4's coordinator and datanodes pointing to? (I have to specify the gtm_host in postgresql.conf)/
2. Do I have to use synchronous replication vs Asynchrous replication?  I am currently using Asynchrnous replication because I think if I use synchronous, slave failour will affect master.