A global manufacturing company uses a critical application that processes real-time sensor data from factories worldwide. This data is stored in a relational database, and the company requires continuous availability and automatic failover in case of an Availability Zone (AZ) outage. Data consistency is paramount, and the solution must handle high transaction rates. Which AWS database service and configuration should be chosen?
- AAmazon Aurora Multi-AZ with a single primary instance and multiple read replicas.
- BAmazon RDS for MySQL Multi-AZ deployment.
- CAmazon DynamoDB Global Tables.
- DAmazon Redshift with cross-region snapshots.
Show answer & explanationAnswer & explanation
Correct answer: A. Amazon Aurora Multi-AZ with a single primary instance and multiple read replicas.
Amazon Aurora is a highly available and fault-tolerant relational database. Its Multi-AZ deployment automatically replicates data across three Availability Zones and provides continuous backup to S3. With up to 15 read replicas, it offers high read capacity. In case of an AZ failure, Aurora automatically fails over to one of its replicas (which could be a reader or a specially designated replica) with minimal downtime, ensuring continuous availability and data durability.
Why the other options are wrong
- B. While RDS Multi-AZ provides high availability and automatic failover, Aurora offers more robust fault tolerance, faster recovery times, and higher performance and scalability, making it a better fit for 'mission-critical' and 'high transaction rates' requirements.
- C. DynamoDB Global Tables is a NoSQL database solution. The requirement specifies a 'relational database,' making DynamoDB unsuitable.
- D. Amazon Redshift is a data warehousing service, not an OLTP (Online Transaction Processing) relational database suitable for real-time application data processing. Cross-region snapshots are for disaster recovery, not continuous availability and automatic failover within an AZ or region.
Aurora Multi-AZ Resilience
Amazon Aurora's architecture provides high availability, fault tolerance, and automatic failover across multiple Availability Zones for relational databases.
- Data automatically replicated across 3 AZs.
- Automatic failover to a replica in seconds.
- Separates compute and storage for scalability and fault tolerance.
Memory trick: Aurora Multi-AZ is your relational database's fortress, always up, always ready.