Section: IT & Technology · DatabasesDifficulty: Medium

Database Replication

USUK

The process of copying and maintaining database data across multiple servers for availability and performance.

Also: database mirroring · primary-replica

Definition

Database replication is the process of maintaining synchronized copies of database data across multiple servers. In primary-replica (master-slave) replication, all writes go to the primary server and are propagated to replicas, which serve read requests. Multi-primary replication allows writes to multiple nodes. Replication improves read performance, provides failover capability, and supports geographically distributed databases. Replication lag — the delay between writing to primary and replica — is a key consideration.

Example

A global e-commerce platform uses database replication with primaries in the US and Europe so that users on each continent read from local replicas with low latency.

Synonyms

  • data mirroring
  • database copying
  • data synchronization

Antonyms / Opposites

  • single instance
  • no redundancy

Images

CC-licensed · free to use
More on Wikimedia
Loading images…

Video

  • sharding
  • high-availability
  • failover
  • primary-replica

Dictionary Entry

Back to IT & Technology