Replication
Replication is automatically copying data between two processing systems either simultaneously on both systems (synchronous) or from a primary to a secondary location (asynchronous).
- used to replicate an organization’s essential operations and data at a secondary site
- secondary site will become operational when the primary site is rendered unavailable for any reason
- Replication of database data utilizes a system called a distributed database management system (DDBMS)
- A system that manages a collection of multiple logically interrelated databases, which may be physically located in various locations (even across the world) in a manner that makes it appear as a single database to users
Methods of Replication
Synchronous replication is a technique in which changes to data are copied to a database server, called the model server, and then replicated to all the replica servers before the original system is notified that the data has been replicated.
- takes longer to verify
- because all replica servers must be updated prior to notifying the original system
- has the advantage of knowing that all data was copied before proceeding
- organization may be forced to restrict the geographic distance between sites in order to keep delays lower
Asynchronous replication is a technique in which changes to data are first copied to a database server called the model, or leader, which responds back to the system where the data change originated and confirms that the data was received.
- At that point, the data is copied to the replicas at an unspecified or monitored pace
- no distance limits to where the replica systems can be located
- beneficial in the case of a large-scale disaster that could potentially damage an alternate site that is near the primary site