What is Replication and Type of Replication?

What is Replication

Data replication is the process of storing data in more than one site or node.

Data replication is the process in which the data is copied at multiple location to improve the availability of data.

Type of Replication

There are two types of data replication

• Synchronous Replication
• Asynchronous Replication

Synchronous Replication

In Synchronous replication the replica will be modified immediately after some changes are made in the relation table.

So there is no difference between original and replica

Asynchronous Replication

In asynchronous Replication the replica will be modified after commit is fired on to the database