Database Replication & It’s Types

“In database replication the data is created and maintained for instances of the similar database. It is a process of copying data from a database to server or computer to another so all the users can share same level of information. In the process of sharing data design changes between databases in different locations without having to copy the overall database.”

The custom web development services use data replication to maintain the database between all the users. So the user can access data without interfering in others work. The database replication is implemented for the purpose of eliminating inconsistency of the data among the users and the entire process is called as Normalization.

In this process one server maintains the original database i.e. called as design master and additional data servers maintains copies of the database i.e. called as slave copies of the database known as replica. These makes a replica set including design master and slave copy. In each replica set there’s only one master design. Two and more copies of the database remain synchronized and the process of synchronization states that whether the copy of databases include similar or original data. Only the data that has changed is updated.

Simple task of replication can become complex when you have to include number of database servers in variety of replication. Database replication is preferable to the businesses that need to share data among remote offices, dispersed users, distributes solution updates, make server data more accessible, and back up all data and offer internet and intranet solutions. Three different methods are associated with the database replication, these are:

Snapshot Replication
In snapshot replication data on one database server is copied to the same database server or another database on the same server. It functions by sending the data repeatedly in extent. It is used when subscribing server can work in read only environment and it can also work for sometime without updating data and such type of functioning is called latency.

Merging Replication
In merging replication, data from two or more different databases are merged into a single database. It allows number of sites to work in autonomous format and later on merge updates into a uniform result.

Transactional Replication
In transactional replication, user receives all the initial copies of the database and then attains regular updates with the changes in data. SQL server processes all the actions within the database using Transact-SQL statement and each statement after completion called transaction.