Re: [GENERAL] [BDR] vs pgpool-II v3

2015-08-17 Thread Wayne E. Seguin
Thank you everyone for your replies, the thoughts and context are greatly appreciated! On Sun, Aug 16, 2015 at 9:35 PM, Craig Ringer wrote: > On 13 August 2015 at 23:52, Wayne E. Seguin > wrote: > > > The context of this is using BDR to implement a HA solution where we > have > > one node getti

Re: [GENERAL] [BDR] vs pgpool-II v3

2015-08-16 Thread Craig Ringer
On 13 August 2015 at 23:52, Wayne E. Seguin wrote: > 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).

Re: [GENERAL] [BDR] vs pgpool-II v3

2015-08-13 Thread Tatsuo Ishii
For your information, I would like to explain a little bit more about pgpool-II own replication (we call it "native replication mode" to separate from streaming replication or slony replication). In the pgpool-II's native replication mode, for a start pgpool-II sends the query to "master" PostgreS

Re: [GENERAL] [BDR] vs pgpool-II v3

2015-08-13 Thread Martín Marqués
El 13/08/15 a las 14:37, Wayne E. Seguin escribió: > 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. They aim a completely different problems. The thing Joshua m

Re: [GENERAL] [BDR] vs pgpool-II v3

2015-08-13 Thread Wayne E. Seguin
(But thank you for the response!!!) On Thu, Aug 13, 2015 at 1:37 PM, Wayne E. Seguin wrote: > 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

Re: [GENERAL] [BDR] vs pgpool-II v3

2015-08-13 Thread Wayne E. Seguin
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 wrote: > > On 08/13/2015 08:52 AM, Wayne E. Seguin wrote: > > "BDR

Re: [GENERAL] [BDR] vs pgpool-II v3

2015-08-13 Thread Joshua D. Drake
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