On 7 September 2015 at 20:56, Giovanni Maruzzelli <gmaruzz(at)gmail(dot)com> 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 tolerance is needed, yes, it could make a lot of sense.
You could use UUID keys or use normal sequences with different offsets
on the nodes. UUID will probably be easier to manage.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services