Re: [BDR] Node Join Question

From: "Wayne E(dot) Seguin" <wayneeseguin(at)gmail(dot)com>
To: Craig Ringer <craig(at)2ndquadrant(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [BDR] Node Join Question
Date: 2015-05-12 14:06:04
Message-ID: CANf8RLsMEdTuuP+t3s8jVBiLAnQPXXgfeGnNWKJh8YkTtmm8bw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Craig,

I was starting the first node then letting all of the other nodes join as
quick as they could which clearly won't work. It also explains why it
worked when I did it manually, I can only do it sequentially myself ;) I
had suspected a race condition and it seems I was in the right area :)

Thank you for this, I will alter what I am doing to start sequentially.

On Tue, May 12, 2015 at 1:19 AM, Craig Ringer <craig(at)2ndquadrant(dot)com> wrote:

>
>
> On 12 May 2015 at 14:33, Wayne E. Seguin <wayneeseguin(at)gmail(dot)com> wrote:
>
>>
>>
> 7. on nodes 1-4 I am doing (adjusted for the nodes IP):
>> SELECT bdr.bdr_group_join(
>> local_node_name := 'pgbdr1',
>> node_external_dsn := 'host=10.244.2.6 port=5432 user=postgres
>> dbname=pgbdr',
>> join_using_dsn := 'host=10.244.2.2 port=5432 user=postgres
>> dbname=pgbdr'
>> );
>>
>
> At a guess you're probably not waiting between joins to ensure that each
> new node has finished joining before starting another node join.
>
> BDR really needs to be enhanced to either support parallel join of
> multiple nodes or identify and reject it.
>
>
> --
> Craig Ringer http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>

--
~Wayne

Wayne E. Seguin
wayneeseguin(at)gmail(dot)com
wayneeseguin on irc.freenode.net
http://twitter.com/wayneeseguin/
https://github.com/wayneeseguin/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wayne E. Seguin 2015-05-12 14:21:09 Re: [BDR] Node Join Question
Previous Message Wayne E. Seguin 2015-05-12 13:50:20 Re: [BDR] Node Join Question