Re: [GENERAL] BDR global sequences in two machine failover

2015-09-08 Thread Giovanni Maruzzelli
Thanks again and more Craig -giovanni On Tue, Sep 8, 2015 at 8:31 AM, Craig Ringer wrote: > On 7 September 2015 at 20:56, Giovanni Maruzzelli > wrote: > > > If I do not use global sequences, and I use uuid as primary keys, would > BDR > > be a correct choice? > > For something like a VoIP ser

Re: [GENERAL] BDR global sequences in two machine failover

2015-09-07 Thread Craig Ringer
On 7 September 2015 at 20:56, Giovanni Maruzzelli wrote: > If I do not use global sequences, and I use uuid as primary keys, would BDR > be a correct choice? For something like a VoIP service where eventual consistency is usually OK and geographic redundancy with latency tolerance and partition

Re: [GENERAL] BDR global sequences in two machine failover

2015-09-07 Thread Giovanni Maruzzelli
On Sep 7, 2015 5:05 AM, "Craig Ringer" wrote: > > On 7 September 2015 at 00:18, Giovanni Maruzzelli wrote: > > Hello, > > > > Typical HA situation. > > > > I have master-master, two only machines, one active and one passive > > (standby) with floating IP. > > I write to only one machine at time,

Re: [GENERAL] BDR global sequences in two machine failover

2015-09-06 Thread Craig Ringer
On 7 September 2015 at 00:18, Giovanni Maruzzelli wrote: > Hello, > > Typical HA situation. > > I have master-master, two only machines, one active and one passive > (standby) with floating IP. > I write to only one machine at time, the one with the floating IP. This is a deployment that is bette

[GENERAL] BDR global sequences in two machine failover

2015-09-06 Thread Giovanni Maruzzelli
Hello, Typical HA situation. I have master-master, two only machines, one active and one passive (standby) with floating IP. I write to only one machine at time, the one with the floating IP. I have one column that is a serial from a global sequence in BDR. When one machine is down I can no mor