Community mailing list archives
Re: Odoo in a distributed (MULTIMASTER replication) environment?by
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 CassandraI 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 haveRegardsOn Thu, Dec 1, 2016 at 3:47 PM, Carlos Paz <email@example.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 <firstname.lastname@example.org> 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.
No dia 01/12/2016, às 16:38, Ray Carnes <email@example.com> escreveu:
Thanks for the replies.
The angle I will be pursuing for now is:
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.
On Mon, Nov 28, 2016 at 8:47 AM, Ray Carnes <firstname.lastname@example.org> 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.
The information in this email (including any accompanying document) is
intended only for the recipient and any distribution of the same is prohibited.