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

[Ashutosh B. <ash...@en...>]

Hi Bei,
Suzuki-san has replied to your questions. I have different suggestion.

You may want to use separate servers for the two datanodes, that way
improves performance because CPU and IO loads are divided.

On Wed, Mar 20, 2013 at 9:55 PM, Bei Xu <be...@ad...> wrote:

>  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.
>
>
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_mar
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
>


-- 
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Enterprise Postgres Company