Re: [GENERAL] BDR and TX obeyance

2016-01-08 Thread Simon Riggs
On 4 January 2016 at 20:09, Riley Berton wrote: > The conflict on the "thingy" table has resulted in node2 winning based > on last_update wins default resolution. However, both inserts have > applied. My expectation is that the entire TX applies or does not > apply. This expectation is clearl

Re: [GENERAL] BDR and TX obeyance

2016-01-08 Thread Riley Berton
Craig Ringer writes: > On 5 January 2016 at 04:09, Riley Berton wrote: > >> >> The conflict on the "thingy" table has resulted in node2 winning based >> on last_update wins default resolution. However, both inserts have >> applied. My expectation is that the entire TX applies or does not >> ap

Re: [GENERAL] BDR and TX obeyance

2016-01-08 Thread Craig Ringer
On 5 January 2016 at 04:09, Riley Berton wrote: > > The conflict on the "thingy" table has resulted in node2 winning based > on last_update wins default resolution. However, both inserts have > applied. My expectation is that the entire TX applies or does not > apply. This expectation is clear

Re: [GENERAL] BDR and TX obeyance

2016-01-05 Thread Edson Richter
Em 05/01/2016 11:42, Riley Berton escreveu: Edson Richter writes: BTW, I'm also looking for a "synchronous multi-master" solution... If you find one, please share :-) The only solution I've found so far is a middleware that is close, the C-Jdbc/Sequoia, which seems not being actively maintaine

Re: [GENERAL] BDR and TX obeyance

2016-01-05 Thread Riley Berton
Edson Richter writes: > BTW, I'm also looking for a "synchronous multi-master" solution... If > you find one, please share :-) > The only solution I've found so far is a middleware that is close, the > C-Jdbc/Sequoia, which seems not being actively maintained for a while > now. See Postgres-R

Re: [GENERAL] BDR and TX obeyance

2016-01-04 Thread Edson Richter
BTW, I'm also looking for a "synchronous multi-master" solution... If you find one, please share :-) The only solution I've found so far is a middleware that is close, the C-Jdbc/Sequoia, which seems not being actively maintained for a while now. Regards, Edson Atenciosamente, Edson Carlos E

Re: [GENERAL] BDR and TX obeyance

2016-01-04 Thread Edson Richter
I think this is the nature of "async multi master"... IMHO, It would be necessary to be "sync multi master" (with two-phase commit?) to get the behavior you expect. Atenciosamente, Edson Carlos Ericksson Richter Em 04/01/2016 18:09, Riley Berton escreveu: I have been experimenting with BDR a

[GENERAL] BDR and TX obeyance

2016-01-04 Thread Riley Berton
I have been experimenting with BDR and have a question about how BDR interacts with transactions. bdrdemo=# create table thingy (id INT, value TEXT, PRIMARY KEY(id)); CREATE TABLE bdrdemo=# create table tx_log(id INT, msg TEXT, PRIMARY KEY(id)); CREATE TABLE bdrdemo=# insert into thingy (id, value