Just a quick note on this: the entity sync stuff is different from database replication as it has different configs for different servers so only the relevant data is needed. A good db level replication tool could probably do something similar, but you would miss some EECA rules that OFBiz runs based on data moving around and stuff like that.
-David Skip wrote:
Vince I have been looking at this myself and was turned onto EnterpriseDB which has a nice replication server. I want all my stores using the same central database and the local database only when the internet breaks. EnterpriseDB's replication server works for that. Somewhat costly, but not nearly as bad as Oracle. Just gotta add (maybe it's already there?) some failover logic. Skip -----Original Message----- From: Vince Clark [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 18, 2007 2:49 PM To: [email protected] Subject: POS Setup I am having trouble figuring out the "step by step" process to deploy POS with synchronization. First area of clarification - How do I get the various pieces deployed and talking to each other? I have reviewed all the documentation I can find, and also the related config files. Here is what I understand so far: 1) Setup all the necessary entities (stores, facilities, products, pricing, etc.) 2) Create POS sync settings to define what entities will be synced (example PosSyncSetting.xml) 3) Define terminals per example DemoRetail.xml 4) Set entity-sync-rmi in serviceengine.xml file 5) Schedule the sync service So where do I do each of these? Master server, per store server, pos, all of the above? For example, if I have a configuration of one store, one pos terminal in the store, and one central server I want the flow to be: Push product, pricing, etc from central server down to POS terminal: MCS -> PSS -> POS Pull transactions from POS terminal to MCS: POS -> PSS -> MCS So let's start with the central server as the majority of setup will occur here. The main question I have about the central server is, how does it know where to "Push"? There is only one setting in serviceengine.xml for entity-sync-rmi. So how do I configure multiple per store servers? Or do I misunderstand the use of "PUSH" in the config file? Is everything really "Pull?" So we just point each deployment to the server where it should communicate? For example the POS terminal would always be configured to talk to the PSS, PSS to MCS? Is it necessary to use a PSS, or can we go straight from POS->MCS? And for those of you also trying to come up to speed on POS, here is the glossary: MCS = Main Central Server PSS = Per Store Server POS = Point of Sale -- Vince Clark Global Era The freedom of open source. (303) 493-6723 (303) 455-2409 fax [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> www.globalera.com
