Postgres Pro
Downloads
Home   >   mailing lists

Re: [BDR] vs pgpool-II v3 - Mailing list pgsql-general

From Wayne E. Seguin
Subject Re: [BDR] vs pgpool-II v3
Date
Msg-id CANf8RLviThDfp61DJiq2iE2Lx2b3S470iNwCV1RZBxTRK5ifxg@mail.gmail.com
Whole thread Raw
In response to Re: [BDR] vs pgpool-II v3  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: [BDR] vs pgpool-II v3
Re: [BDR] vs pgpool-II v3
Re: [BDR] vs pgpool-II v3
List pgsql-general
Tree view
The question is specifically about the replication feature mentioned here http://www.pgpool.net/mediawiki/index.php/Main_Page for the purposes of failing over minimizing downtime.

On Thu, Aug 13, 2015 at 12:28 PM, Joshua D. Drake <jd@commandprompt.com> wrote:

On 08/13/2015 08:52 AM, Wayne E. Seguin wrote:

"BDR is only one in Beta compare to stable options:
https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling.
Not sure why this solution would be chosen. Experience with pgpool is
that you only needed to change a port and no SQL changes required on an
application side."

I appreciate any input as to pros/cons of BDR vs PGPool-II v3 in this

 BDR is async multi master. PGPool is largely just a connection pooler with load balancing (although it has other features). They play different sports.

JD


--
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.



--
  ~Wayne

Wayne E. Seguin
wayneeseguin on irc.freenode.net

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [BDR] vs pgpool-II v3
Next
From: "Wayne E. Seguin"
Date:
Subject: Re: [BDR] vs pgpool-II v3