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

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

Ashutosh:
   Thanks for the suggestion.  We only have limited 6 servers allocated.  3 servers are masters, 3 servers are slaves (stream replication).
If we set up 1 datanode per server, then we only have 3 active datanodes in total. That's why we set up 2 datanodes per server in order to have 6 active datanodes.
Do you think 3 active datanodes  in 3 servers perform better than 6 active datanodes in 3 servers?

From: Ashutosh Bapat <ash...@en...<mailto:ash...@en...>>
Date: Wednesday, March 20, 2013 11:25 PM
To: Xu Bei <be...@ad...<mailto:be...@ad...>>
Cc: "pos...@li...<mailto:pos...@li...>" <pos...@li...<mailto:pos...@li...>>, Karthik Sethupathy <kse...@ad...<mailto:kse...@ad...>>, Venky Kandaswamy <ve...@ad...<mailto:ve...@ad...>>
Subject: Re: [Postgres-xc-developers] proxy setup on standby server

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...<mailto: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...<mailto:Pos...@li...>
https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers




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