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