jQuery in Action, 3rd edition
The moose likes Distributed Java and the fly likes Need a distributed solution Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Distributed Java
Bookmark "Need a distributed solution" Watch "Need a distributed solution" New topic

Need a distributed solution

ray livia

Joined: Aug 04, 2007
Posts: 16
Hi, buddies,

I am going to build a distributed solution based on the following requirements:

1. I have one production Java web service site (Spring+MS SQL server).
2. I have to build a new site in other region.
3. The two site DB data must be synchronous by real time.

My current consideration is to use MS SQL server replication feature. I guess replication in real time production env is big challenge. Do you have other good solutions? e.g. distributed data transaction?

Thank you in advanced.
margaret gillon
Ranch Hand

Joined: Nov 12, 2008
Posts: 335

Be careful with MS SQLserver replication. When we looked at MS SQLserver 2000 the only real time replication offered would roll back transactions on both servers if both database could not be updated. Because of this we didn't adopt SQLserver replication because the VPN between the two divisions involved goes down sometimes and we could not risk the sites having to stop shipping goods if that happened. Newer SQLserver may offer a better model.

There are 3rd party utilities, like DataMirror, that sit between two servers and do real time replication by reading the transaction logs and posting the transactions to the target server. DataMirror has a nice feature that it knows when replication has been interrupted and queues the updates. When the connection is re-established it will update the target and then go back into real time mode.
subject: Need a distributed solution
It's not a secret anymore!