I have 2 systems: ALPHA and BETA; both are laying in two different servers and use their own DB. Some of the information needs to be shared on both DBs. Example, ALPHA sends a message to BETA so the info should be in ALPHA and BETA. IF BETA makes changes to the message - it should be revised on ALPHA as well.
Problem: How can I make sure that all messages are in sync. meaning that whatever ALPHA has --BETA will have (and vice versa) ?
Should I create another application that SYNC the data? any better solution?
I was wondering if you could set one of the server as master and the other as a slave. For example, updates are always done on ALPHA and then BETA. This would allow BETA to see the latest message, but clean-up the logic a great deal since you only need to worry about write calls in ALPHA (BETA would simply write what ever comes from ALPHA).
You posted this a few days back, did you already solve this problem?