Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Adrian Burlington
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 46
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic