• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Rob Spoor
  • Devaka Cooray
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Tim Holloway
Bartenders:
  • Jj Roberts
  • Al Hobbs
  • Piet Souris

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

 
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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!

 
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic