Ask the Expert

Looking at two-way replication methods

We are planning to extend our project to other locations (overseas). One of the objectives is to replicate the database two-way. What tool would you recommend?

    Requires Free Membership to View

By two-way replication, I assume you mean that you have some data at your domestic location and some other, unrelated data at your overseas location, and you wish you replicate each site's data to the other site.

If your intent is to modify the same data in both locations at the same time, that won't work as the latency introduces windows of vulnerability where two people can modify the same record at the same time creating conflicts.

So, assuming the first situation is your goal, to replicate over the kind of distance you are talking about, asynchronous replication is pretty much a requirement. The latency (delay) that synchronous replication can introduce is sure to be quite significant, probably slowing your application to an unacceptable crawl.

(Full disclosure time: I work for Veritas Software.)

In my experience, hardware replication solutions such as EMC's SRDF and Hitachi's True Copy do not handle asynchronous replication as well as software-based replication solutions like Veritas' Volume Replicator or Sun's StorEdge Availability Suite's remote mirror software.

I would recommend however, that you price out both a hardware and a software solution and then run some performance benchmarks over the distance you wish to replicate and see which solution gives you better price/performance. Make sure that the data that you replicate emulates as closely as possible the data you'll have in production, in terms of quantity (number of blocks), size of the blocks, burstiness, rate, number of parallel users, line speed, and like that.

Good luck!

Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our .bphAaR2qhqA^0@/searchstorage>discussion forums.


This was first published in January 2003

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: