Community mailing list archives

community@mail.odoo.com

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

by
DevCO Colombia , David Arnold
- 12/01/2016 20:25:48
Hey, what's wrong with pglogical? It's an evolution, but a significant one. Ray is right in wisely point to it's planned inclusion into upstream postgres.

But announcing panaceas, the real problem is not so much replication, but write consistency and there is NO solution to it. I guess it's not even that hard to prove the inexistence of such solution mathematically. :)
Everything else is workaround. crate.io referenced above ha quite strong guarantees on write concistency after all, I would love to see how Oracle and Microsoft solves this problem better... 

Take a look at https://aphyr.com/tags/jepsen the single most impressive source of indepth distributed databse analysis. A genius type of guy to many.

El jue., 1 dic. 2016 a las 19:34, Axel Mendoza Pupo (<aekroft@gmail.com>) escribió:
I don't see that SQL Server or Oracle will be a solution for everybody because those are non opensource database solutions. I think that Odoo could solve this like many others are doing, by changing their database type to a really distributed database solution, NoSQL or SQL like Apache Cassandra

I mean PostgreSQL is a great database but there are others that covers more scenarios present in Odoo deployments but for PostgreSQL I stick with Postgres-XL for beign distributed, scalable and supports sharding and distributed transactions something very difficult to have
Regards

On Thu, Dec 1, 2016 at 3:47 PM, Carlos Paz <phoenixsampras@gmail.com> wrote:
This search for a panacea for this problem has many years already.

Meanwhile SAP support replication with tools like SQL SERVER or ORACLE, pretty well support for corporation-style demanding infrastructure.

Odoo and Postgresql are like 20 years behind in this matters... most of this solutions are very artesanal and unreliable, some pseudo-solutions are almost comic.

Maybe it's time Odoo support SQL SERVER or ORACLE for once, if they ever want to enter sometime to the Corporate System world. (and if Larry Ellison doesn't beat to death to Mr. Pinckaers with his billions just for daring)

Regards,

On Thu, Dec 1, 2016 at 7:15 PM, Daniel Reis <dreis.pt@hotmail.com> wrote:
Ray, db level sync could do the trick, but app level sync sounds wiser:
Some sort of idoo2odoo connector, or maybe just some reporei based Python scripts ran by crons.

--dr 

No dia 01/12/2016, às 16:38, Ray Carnes <ray.carnes@bistasolutions.com> escreveu:

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

_______________________________________________
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




--
Best regards,
CP

_______________________________________________
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