Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

7

Openerp with multimaster DB replication

By
raj
on 3/25/13, 1:22 PM 4,107 views

Hi,

We would like to implement openerp in multiple locations,but datas from all the location should be synced? Is it possible to have multi master replication of database(postgres) with openerp?

What is the minimum system requirements for 300 users? Can we use openerp on centos 6 for production?

Please help with this. It must be one of the most crucial questions for a multi-site openerp installation. You cannot compare openERP to the likes of SAP if there isnt a solid way to do this. I'm looking at http://www.enterprisedb.com/products-services-training/products-overview/xdb-replication-server-multi-master - looks like a potentially good option if it works as advertised. Anyone got a better way to do this??

Timothy Solomon
on 4/9/13, 6:34 AM

This is a must have feature for geographical distributed installations with poor internet connectivity. Any updates?

Osoul for Technology and Software Development
on 4/29/13, 10:32 AM
3
Lorenzo Cabrini
On 4/9/13, 5:25 PM

I don't know if it's too late, but since there is no other answer yet, I'll chip in the following. On a project where we needed multi-master replication of PostgreSQL databases, we had success with bucardo. The project was not related to OpenERP, but since it is database replication you are looking for, you might as well give it a shot.

It was quite some time ago, and I'm fairly old and no longer remember things very well, but IIRC bucardo was a bit of a pain to set up, but once it was it worked well, at least for what we needed it for.

There are a few other replication systems for pgsql as well, some of which support multi-master replication. But I don't have any experience with them. You'd have to test them until you find one that suits you.

In an OpenERP context I believe that you may also have to take a few other things into consideration, depending on how you are storing your attachements, for instance. But if they are on the file system, then I guess a tool like rsync might be helpful. But I'm not sure if OpenERP 7 still stores any objects on the file system. Maybe somebody who knows more can shed light on that issue?

0
Intigra Technolab
On 5/14/15, 11:08 AM

Read this.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

6 follower(s)

Stats

Asked: 3/25/13, 1:22 PM
Seen: 4107 times
Last updated: 6/4/15, 12:03 AM