Difference between synchronous replication and asynchronous replication.

Answer preview

Semi-synchronous: A middle ground — wait for at least one replica to acknowledge (e.g., MySQL semi-sync). Provides a balance between safety and performance.…