Data replication

From Wikipedia, the free encyclopedia

Data replication refers to a data storage and backup strategy that copies data from a host computer to another computer, which may or may not be at a remote location. Replication over a computer network can make data backup entirely independent of local data center physical storage.

Replication is popular in Relational Database Management Systems where it can be used to provide redundancy or to balance load across multiple database servers.

Contents

[edit] Online data replication

In data replication over a network such as the Internet, the data backup is made on a real time basis wherein the data from the host server is copied onto the remote location as soon as the data is changed.

[edit] Offline data replication

In offline data replication, a backup of the datafile is taken on a remote location on an offline basis, such as once a day. Offline data replication is preferred in environments where the number of transactions is very large and doing real time data replication may affect the performance of the system.

[edit] See also

[edit] External links

In other languages