Replication (Database)

Database replication copies data across multiple servers for high availability, disaster recovery, and read scaling.

What is Database Replication?

Database replication is the process of copying and maintaining database objects across multiple database servers, providing redundancy, high availability, and improved read performance.

Replication types

Synchronous (immediate consistency), Asynchronous (eventual consistency), Semi-synchronous (hybrid).

Common misconceptions

"Replication is backup" — Different purposes
"Replication eliminates backups" — Still need point-in-time recovery
"All replicas are identical" — Lag can exist