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

[Nikhil S. <ni...@st...>]

Hi Bei,

> 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.
>

IMO, a better config would be to have datanode1 running on server3 and
datanode 2 running on server4. Also their replicas should then
respectively go to server4 and server3 respectively.


> 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.
>

Or consider having two synchronous replicas configured. Also the
replicas need not be hot standby replicas.

Regards,
Nikhils
-- 
StormDB - http://www.stormdb.com
The Database Cloud
Postgres-XC Support and Service