Community mailing list archives

community@mail.odoo.com

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

by
Bista Solutions US, Ray Carnes
- 12/01/2016 11:26:39

Thanks for the replies.

 

The angle I will be pursuing for now is:

 

https://2ndquadrant.com/en/resources/pglogical/

http://www.openscg.com/2016/09/postgresql-replication-checklist/

 

A prospect has been testing it between several Odoo 9 instances in my lab. 

500,000 invoice records and 400,000 res_partner records.

 

Notes from them: It is lightweight on the WAN connection. It will catch-up if disconnected for days. It is simple to set up and use (unlike Slony). Right now it is an extension but is proposed to be built into the next Postgres release or so, so it appears fairly serious.

 

Ray.

 

On Mon, Nov 28, 2016 at 8:47 AM, Ray Carnes <ray.carnes@bistasolutions.com> wrote:

Hello,

 

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?

 

J

 

Ray.

 

 

http://www.bistasolutions.com/images/Sign_Image/Bista-Solutions-logo-for-Email-sig.png

RAY CARNES

Senior Odoo Consultant


?

Greater Los Angeles, UNITED STATES.

?

909.864.4576

?

bista_ray

?

www.bistasolutions.com

USA |

Canada |

UAE |

India

?

?

?

?


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

 

 

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

 

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe