Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: SQL Server
Expertise: Beginner
Mar 24, 1997



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Data Replication

I've heard several of the arguments in favor of a server that supports data replication. What are the potential problems?

For our readers, the advantages of data replication [creating copies of data, or fragments of data, at one or more sites] include the improved performance that comes from working with local data, and the increased availability of data, which is especially important for a global operating environment (data can continue to be retrieved even if the primary site becomes unavailable provided that a copy continues to be available).

The major disadvantage is that every copy of data that has been replicated also must be updated. (If one or more copies of the data do not agree, data integrity has been compromised.) Under ideal circumstances, one would want to have all primary and replicated data updated simultaneously, thus avoiding loss of integrity. Unfortunately, this would potentially defeat the major benefits of replication — if a site becomes unavailable, updates cannot be replicated there, which would in turn cause the transaction to fail (the same result if the entire system were unavailable). To avoid such a negative scenario, most commercial systems that support data replication propagate updates on a delayed basis. Thus, integrity that is taken for granted on an unreplicated system is sacrificed with delayed replication. Most businesses that need data replication are able to work within this limitation, but it obviously is a limitation that should be known beforehand.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date