What is Replication Advantages and Disadvantages of Replication?

What is Replication

Data replication is the process of storing data in more than one site or node
It is useful in improving the availability of data
It is simply copying data from a database from one server to another server so that all the user can share the same data without any inconsistency
The result is a distributed database in which users can access data relevant to their tasks without interfering with the work of others.

Replication

Advantages of Replication

To provide a consistent copy of data across all the database nodes
To increase the availability of data
The reliability of data is increased through data replication
Data replication supports multiple users and gives high performance
To remove any data redundancy, the database is merged and slave database are updated with outdated or incomplete data
Since replicas are created there are chances that the data is found itself where the transaction is executing which reduces the data movement
To perform faster execution of queries

Disadvantages of Replication

More storage space is needed as storing the replicas of same data at different sites consumes more space
Data replication becomes expensive when the replicas at all different sites need to be updated
Maintaining data consistency at all different sites involves complex measures

Safdar Dogar