Re: pgpool + BDR, is it possible? - Mailing list pgsql-admin

From Craig Ringer
Subject Re: pgpool + BDR, is it possible?
Date
Msg-id CAMsr+YHTXDLFzy80MOacv5O8aM09VH_q3V+5mESi1XXvc8b-ng@mail.gmail.com
Whole thread Raw
In response to pgpool + BDR, is it possible?  ("Ruth Melendo" <rmelendo@teltronic.es>)
Responses Re: pgpool + BDR, is it possible?  ("Ruth Melendo" <rmelendo@teltronic.es>)
List pgsql-admin


On 16 March 2015 at 21:48, Ruth Melendo <rmelendo@teltronic.es> wrote:

Hi all,

 

¿Does anybody know if I can use pgpool as a balancer between 2 nodes that have BDR  master/master configured for replication?


It's possible. In most cases I think it's probably going to be a very bad idea, though.

Most applications cannot just be pointed at multiple nodes and expected to work properly. BDR doesn't have a global lock manager or global transaction manager, so anomalies can occur that cannot on a single node. Applications must take extra steps to avoid them or be tolerant of them.

If you take an app that expects ACID semantics and READ COMMITTED isolation then, without it knowing, you send some of its transactions to each of two semi-independent nodes, you're going to get fireworks.

If your goal is write scaling, then it's not likely to do you a great deal of good anyway, because each node still has to apply the writes from the other node. So the writes still have to get done, just on another channel.

I'm speaking of the most general case, where I have no idea of what problem you're trying to solve or what your application is. If you can be more specific about the problem you're trying to solve by doing this and what the app does perhaps I can tell you more about whether/how BDR can help you, and if not point you to other solutions that might.

 


I have tried also Barman but does not work in logical replication and repmgr that does not work master/master.


repmgr doesn't understand multi-master and BDR yet, correct.

PgBarman works fine with BDR. It doesn't care that the database(s) it's backing up are BDR nodes. However you can't just restore a single node - to do a restore you have to shut the lot down, restore one node, then re-init new nodes from the one you restored.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-admin by date:

Previous
From: om prash jaiswal
Date:
Subject:
Next
From: "Ruth Melendo"
Date:
Subject: Re: pgpool + BDR, is it possible?