Advanced
Database Management Systems
Q87 / 100
What is the difference between synchronous and asynchronous replication?
Correct! Well done.
Incorrect.
The correct answer is B) Synchronous: commit waits for replica acknowledgment (no data loss, higher latency); Asynchronous: commit returns immediately (potential data loss, lower latency)
B
Correct Answer
Synchronous: commit waits for replica acknowledgment (no data loss, higher latency); Asynchronous: commit returns immediately (potential data loss, lower latency)
Explanation
Synchronous replication (sync standby in PostgreSQL) waits for replica to write WAL before returning. Zero RPO but adds replica latency to every write. Async replication may lose committed data if primary crashes before replica catches up.
Progress
87/100