wood burning stoves 2.0*
The moose likes Distributed Java and the fly likes how to sync 2 systems --2 different database needs to be in sync (image) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Java » Distributed Java
Bookmark "how to sync 2 systems --2 different database needs to be in sync (image)" Watch "how to sync 2 systems --2 different database needs to be in sync (image)" New topic
Author

how to sync 2 systems --2 different database needs to be in sync (image)

Adrian Burlington
Ranch Hand

Joined: Jun 16, 2009
Posts: 75
Hi all,

Design question:

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?

Thank you!

Francois Nadeau
Ranch Hand

Joined: Apr 09, 2009
Posts: 46
Hello Adrian,

That looks like a fun problem.

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?

Cheers.


[url]http://FrancoisNadeau.com[/url]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to sync 2 systems --2 different database needs to be in sync (image)