CompTIA DataSys+ (DS0-001)Database DeploymentMedium
A database administrator is deploying a new database server for a high-traffic e-commerce application. The application requires extremely low latency for read operations and must maintain data consistency across multiple geographically dispersed regions. Which replication strategy would best meet these requirements?
- AMulti-master replication with eventual consistency
- BSynchronous replication with multiple geographically dispersed read replicas and a load balancer
- CAsynchronous replication with a single read replica
- DSynchronous replication with a single master and multiple asynchronous read replicas
Show answer & explanationAnswer & explanation
Correct answer: B. Synchronous replication with multiple geographically dispersed read replicas and a load balancer
Synchronous replication ensures data consistency across all replicas, which is crucial for consistency across regions. Multiple geographically dispersed read replicas, combined with a load balancer, provide low-latency reads to users in different regions by directing them to the nearest replica, while maintaining strong consistency.
Why the other options are wrong
- A. Multi-master with eventual consistency prioritizes availability over immediate consistency, which does not meet the 'maintain data consistency' requirement.
- C. Asynchronous replication does not guarantee immediate consistency, and a single replica might not provide low latency globally.
- D. Asynchronous read replicas don't guarantee immediate consistency, failing the consistency requirement across regions.
Synchronous Replication
A database replication strategy where a transaction is not considered committed until it has been successfully written to both the primary and at least one replica.
- Ensures strong data consistency.
- Higher write latency compared to asynchronous replication.
- Suitable for critical data where consistency is paramount.
Memory trick: Replication is about balancing speed, safety, and scale.