[BDR] vs pgpool-II v3

From: "Wayne E(dot) Seguin" <wayneeseguin(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: [BDR] vs pgpool-II v3
Date: 2015-08-13 15:52:41
Message-ID: CANf8RLtkw29MG=VfA9xWNPRHXF-2WwKBU2FaY8maHRsqMCYwhA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everyone!

The context of this is using BDR to implement a HA solution where we have
one node getting all connections at a time, if the node fails we move all
connections to another node. (eg. only one node gets all connections at any
given time).

I am looking for help / advice on how to answer the following question I
was presented with:

"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
context.

~Wayne

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2015-08-13 16:28:21 Re: [BDR] vs pgpool-II v3
Previous Message Adrian Klaver 2015-08-13 15:14:16 Re: Sync replication + high latency server