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

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

On Thu, Mar 21, 2013 at 10:35 AM, Bei Xu <be...@ad...> wrote:

>  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?
>
 3 active datanodes on 3 separate server is expected to do better than 6
active datanodes on 3 servers. But, in rare cases (if they balance CPU and
IO amongst two datanodes on same server) 6 datanodes on 3 servers might be
as good as other configuration. Please see if the later is the case with
you, but that would be rare, I guess.


>
>   From: Ashutosh Bapat <ash...@en...>
> Date: Wednesday, March 20, 2013 11:25 PM
> To: Xu Bei <be...@ad...>
> Cc: "pos...@li..." <
> pos...@li...>, Karthik Sethupathy <
> kse...@ad...>, Venky Kandaswamy <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...> 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
>



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