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 can tolerate slightly older data for some reporting queries. Which database deployment strategy would best meet these requirements?
- AMaster-replica deployment with read replicas
- BIn-memory database with write-through cache
- CDistributed database with strong consistency
- DSingle instance database with local storage
Show answer & explanationAnswer & explanation
Correct answer: A. Master-replica deployment with read replicas
A master-replica deployment with read replicas is ideal for high-traffic applications needing low latency reads. Read replicas offload read operations from the master, improving performance and availability, while the master handles writes and ensures data consistency.
Why the other options are wrong
- B. While in-memory databases offer low latency, a write-through cache primarily benefits write operations and doesn't directly address the distribution of read load for scalability as effectively as read replicas.
- C. A distributed database with strong consistency might introduce higher latency due to coordination overhead, which is not ideal for 'extremely low latency' reads.
- D. A single instance database would struggle with high read traffic and would not provide high availability.
Master-Replica with Read Replicas
A database architecture where a primary 'master' database handles all write operations, and one or more 'replica' databases asynchronously receive copies of the data, primarily serving read operations.
- Enhances read scalability and performance by distributing read load.
- Provides high availability and disaster recovery capabilities.
- Replicas can be used for reporting or analytical queries without impacting the master.
Memory trick: Scale reads, replicate writes, stay agile.