Databases · Senior · Question 16 of 75
What is the trade-off between synchronous and asynchronous replication?
- 1Asynchronous replication is always safer
- 2Synchronous replication doesn't use the network
- ✓Correct answer: Synchronous: commits wait for a replica, so no data loss on failover but higher latency; asynchronous: faster commits, but recent transactions can be lost
Explanation
A common setup is one synchronous standby (or quorum) for durability plus asynchronous replicas for reads.