How do you approach database replication strategies, and what are the trade-offs between synchronous and asynchronous replication?

Sample answer preview

Database replication copies data from one database instance to one or more replicas, serving purposes of high availability, disaster recovery, and read scaling. The replication mode, whether synchronous or asynchronous, determines the trade-off between data consistency and…