Re: [BDR] Node Join Question

From: Craig Ringer <craig(at)2ndquadrant(dot)com>
To: "Wayne E(dot) Seguin" <wayneeseguin(at)gmail(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 08:19:22
Message-ID: CAMsr+YHCnK=8XTxSQzShyuo2wPwQwPNbH-2+SNZorAo1bpQvGQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2015-05-12 08:31:00 Re: [BDR] Node Join Question
Previous Message Anil Menon 2015-05-12 08:07:52 Re: Why does this SQL work?