I need to syncronize two openerp physically distanced databases. One database is on local install, and the second database must on a cloud environment.
Since I lack of good internet access, I cannot have the system working full time on cloud, and the solution is to allow access to the database via cloud (A) and local install (B). When I am on the company, I use the local install (A), and when outside the company, I use the cloud Odoo system (B).
With syncronization, I want to have all data entered on the cloud A available on the local install B and vice-versa.
The syncronitation should be time defined and/or on demand.
Thank you very much
For Asynchronous replication, you can setup bucardo and run in your local server. The remote or cloud server is not required for any installation but you must have postgres 9.x above for both location, you can setup master-master replication or master-slave replication. Once installed just cron the sync on demand by starting and stopping the service. Bucardo 5.1.1 works for me hope it can help you too.
For your problem, i think you can get a good result if you define a cron job which synchronise data on the two databases periodically.
A link for definition of cron job : http://www.thesitewizard.com/general/set-cron-job.shtml
NB: If my answer help you, don't forget to vote my message. Thank you.
Forget asynchronous replication. Suppose you have two databases asynchronous replicated, each accessed by one diferent user. In a time when the two dates are not connected, the two users insert a new record in the same object in each of the two databases (in sale.order for example). I have the same ID for sale.order? (Primary key IDs are serial long in odoo). Also reference field will have the same SO ...? Raise this situation a conflict at next replication ? I think yes...
Lets say if your internet connection goes off at your Local Office. The people who are using at your office will prepare some quotes in local erp and you might be travelling and might make quotations on cloud database,
How does above mentioned solutions help? Does it take care of conflicts too?
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
|Asked: 8/11/14, 8:22 AM|
|Seen: 7552 times|
|Last updated: 5/14/15, 11:09 AM|