Re: [GENERAL] Bi-Directional replication client awareness

2014-07-14 Thread Martin Gudmundsson
I think we (as in postgres) will probably get the ability to run individual transactions in such a mode, but you surely wouldn't want to run every transaction in it. So, would then these transactions be ”2-phase”? I mean either all nodes commit the transaction or none of them do? Or only

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-14 Thread Martin Gudmundsson
13 jul 2014 kl. 21:54 skrev Martin Gudmundsson martingudmunds...@gmail.com: I think we (as in postgres) will probably get the ability to run individual transactions in such a mode, but you surely wouldn't want to run every transaction in it. So, would then these transactions be

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Craig Ringer
On 07/12/2014 02:24 PM, Martin Gudmundsson wrote: 12 jul 2014 kl. 04:58 skrev Craig Ringer cr...@2ndquadrant.com: PgJDBC actually already supports rudimentary client-based failover. I’ve seen some mailing list threads regarding this but was that ever implemented? Do you know where it’s

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Andres Freund
On 2014-07-12 18:22:30 +0800, Craig Ringer wrote: On 07/12/2014 02:24 PM, Martin Gudmundsson wrote: Any ideas giving BDR an option to be synchronous. I mean in ”close quarters” with low latency it should work ok. BDR doesn't do synchronous replication _yet_, but it's on the roadmap. Just

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Andres Freund
On 2014-07-12 13:23:08 +0200, Martin Gudmundsson wrote: 12 jul 2014 kl. 12:33 skrev Andres Freund and...@2ndquadrant.com: On 2014-07-12 18:22:30 +0800, Craig Ringer wrote: On 07/12/2014 02:24 PM, Martin Gudmundsson wrote: Any ideas giving BDR an option to be synchronous. I mean in

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Michael Paquier
On Sat, Jul 12, 2014 at 7:22 PM, Craig Ringer cr...@2ndquadrant.com wrote: On 07/12/2014 02:24 PM, Martin Gudmundsson wrote: 12 jul 2014 kl. 04:58 skrev Craig Ringer cr...@2ndquadrant.com: PgJDBC actually already supports rudimentary client-based failover. I've seen some mailing list threads

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Andres Freund
On 2014-07-12 14:37:02 +0200, Martin Gudmundsson wrote: It's possible to do it to a streaming replication sync standby, but also to another BDR node. The logical decoding facility added in 9.4 allows logical replication solutions to use the same mechanism as streaming rep does.

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Martin Gudmundsson
12 jul 2014 kl. 04:58 skrev Craig Ringer cr...@2ndquadrant.com: On 07/12/2014 02:42 AM, Martin Gudmundsson wrote: Hi all! I was wondering if there are any specific load balancing/failover functionality planned for client drivers connection to a BDR group. In my case the jdbc driver, but

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Martin Gudmundsson
Because BDR is asynchronous multi-master _replication_ though, clients are expected to be aware of some of the anomalies that can occur. A naïve client that just picked a random BDR server and did the next transaction on it would be very likely to cause unwanted replication anomalies,

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Martin Gudmundsson
12 jul 2014 kl. 13:45 skrev Andres Freund and...@2ndquadrant.com: On 2014-07-12 13:23:08 +0200, Martin Gudmundsson wrote: 12 jul 2014 kl. 12:33 skrev Andres Freund and...@2ndquadrant.com: On 2014-07-12 18:22:30 +0800, Craig Ringer wrote: On 07/12/2014 02:24 PM, Martin Gudmundsson wrote:

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Martin Gudmundsson
I’ve seen some mailing list threads regarding this but was that ever implemented? Do you know where it’s documented? I don't think the patch ever got accompanying documentation. It's not mentioned here, anyway: http://jdbc.postgresql.org/documentation/93/connect.html Failover

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Martin Gudmundsson
12 jul 2014 kl. 14:48 skrev Andres Freund and...@2ndquadrant.com: On 2014-07-12 14:37:02 +0200, Martin Gudmundsson wrote: It's possible to do it to a streaming replication sync standby, but also to another BDR node. The logical decoding facility added in 9.4 allows logical replication

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-12 Thread Martin Gudmundsson
12 jul 2014 kl. 12:33 skrev Andres Freund and...@2ndquadrant.com: On 2014-07-12 18:22:30 +0800, Craig Ringer wrote: On 07/12/2014 02:24 PM, Martin Gudmundsson wrote: Any ideas giving BDR an option to be synchronous. I mean in ”close quarters” with low latency it should work ok. BDR

[GENERAL] Bi-Directional replication client awareness

2014-07-11 Thread Martin Gudmundsson
Hi all! I was wondering if there are any specific load balancing/failover functionality planned for client drivers connection to a BDR group. In my case the jdbc driver, but could be relevant for other drivers as well. Or is the long term plan that we need we need to rely on middleware like

Re: [GENERAL] Bi-Directional replication client awareness

2014-07-11 Thread Craig Ringer
On 07/12/2014 02:42 AM, Martin Gudmundsson wrote: Hi all! I was wondering if there are any specific load balancing/failover functionality planned for client drivers connection to a BDR group. In my case the jdbc driver, but could be relevant for other drivers as well. PgJDBC actually