Difficulty: Intermediate
Compare synchronous vs. asynchronous replication.
Synchronous waits for acknowledgment from the replica before committing (high data safety, high latency). Asynchronous commits immediately and sends data to replica later (low latency, risk of data loss).
Master-Slave, Multi-Master, Synchronous, Asynchronous