Community mailing list archives

Re: Odoo in a distributed (MULTIMASTER replication) environment?

XOE Corp. SAS, David Arnold
- 11/30/2016 20:58:58
Let's just skype... :)

El mié., 30 nov. 2016 a las 21:56, David Arnold (<>) escribió:
Ps.: You can probably separate write/read streams via a lua script upon haproxy load balancers in your stack. Haven't tested this. Just investigation...
Pps: Use as your stack management solution of choice! Encrypted VPN-like software defined networks for free...
Ppps: Become a docker apostel!

El mié., 30 nov. 2016 a las 21:54, David Arnold (<>) escribió:
Write stream: (this is actually quite what you are looking for, look no further! / gotcha)
Read stream: (creazy idea, but when it comes to crm cube analisis across multiple sites, distributed query engine just sounds like sugar to my ears)

Gotcha: The scheduling mechanism in postgres-xl is entirely written in bash/sh/ash/zsh! Whaat?!?! Are we 19th century??? Don't touch this! It's a bash bomb!

El lun., 28 nov. 2016 a las 16:18, Axel Mendoza Pupo (<>) escribió:
Hi Ray

I have researched on this a lot and used some tools and I have anothers planned to be used it for that matter. Honestly the most feature complete solution that I have found is Postgres-XL that your could find here:

I have also used Pgpool II but if you are looking for a really multi-master solution you need to look for a distributed approach like Postgres-XL does and start building the DB cluster with component thought on that direction.
I really liked the design of the components in Postgres-XL

Hope this helps
Best Regards

On Mon, Nov 28, 2016 at 8:47 AM, Ray Carnes <> wrote:



Has anyone implemented “distributed” (ideally loosely coupled logical multi-master replication) environment?


A complete Odoo stack at each site, with eventual replication of data between sites of SOME tables (perhaps partners and some crm data) – not EVERYTHING.  I’m just getting started understanding requirements, but each Odoo stack could be implemented as a company in a multi-company environment.   The companies would carry on mostly independently, but want to access CRM data across companies.


Bucardo? – Postgres-BDR?


Can you point me to anything to help me start to understand how to do this?  What might be the ‘gotcha’ things to consider.  Is anyone doing this?  What questions should I be trying to answer?






Senior Odoo Consultant


Greater Los Angeles, UNITED STATES.







Canada |







The information in this email (including any accompanying document) is 
intended only for the recipient and any distribution of the same is prohibited.



Post to:

Post to: