Ask the Expert

The pro and cons of replicating

What are the pros and cons of replicating (for DR) a database with a database replication tool like Quest Shareplex, vs. host-based or array-based replication software?

Requires Free Membership to View

I believe that tools like Quest Shareplex are excellent for creating an alternate copy of a database for report generation, DSS, data mining and other external applications. However, I don't believe that they are adequate for DR. Database (-only) replication tools only replicate the data in the database and nothing more. They do not replicate the executable or configuration files associated with the database. They do not replicate any other files on the primary system, apart from the contents of the database.

Host- or array-based replication tools such as VERITAS Volume Replicator and Hitachi TrueCopy can replicate all of the data on the system. They do a much more thorough job, and are sure that a modified configuration file, or a patched executable are not overlooked in the replication process.

Most database replication tools do not copy the data, they send the transactions to the remote site, and re-execute them there. As a result, the database on the remote side is not exactly the same as it was on the primary side. Transaction numbers and locations of information will likely be different, confusing any tools that rely on that information.

While tools like Shareplex definitely have their place in the market, I believe that they are not adequate for DR, and tools that do full data replication should be used instead.

Thank you for question. If you have any other questions, please feel free to follow up.

Evan L. Marcus

Editor's note: Do you agree with this expert's response? If you have more to share, post it in our .HcX6azlxeJg^0@.ee83ce2!viewtype=&skip=&expand=>Administrator Central discussion forum.


This was first published in July 2002

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: