The now removed POS component used a solution for similar cases. This solution still
exists and is reliable on a LAN ("less" on Internet)
You can find the documentation at
https://cwiki.apache.org/confluence/display/OFBIZ/Sync+Setup+Notes+and+Example
Disclaimer: it's not very easy to understand and use...
HTH
Jacques
Le 17/01/2017 à 00:01, Bahaa Alamood a écrit :
Hello All,
We have a situation that we need to have more than 2 servers of ofbiz running,
server A, B, and C. The scenario is like this
1. Server A is the main server and it is online all the time with its own database. some people do connect to that and make changes to the data
(create, delete, modify)
2. Server B is a server in one office (own database) and they do not have a reliable internet connection so it goes offline some times while the
users in this office continue to use their local ofbiz
3. Server C is the same as server B with its own database as well
I have been looking at the bdr from 2nd Quadrant https://2ndquadrant.com/en/resources/bdr/ to do the data replicationamong the servers. I realize
that this could create conflicts in the primary keys of many things in the system. So I looked at SequenceUtil.java and I can see if I change the
stagger in getNextSeqId from 1 to 2 in one of the systems I can avoid this conflict in two of them, but what about the third one? also in the above
scenario what else I need to look out for other than the sequences that might create conflicts?