Examkin

Question

Difficulty: MediumDatabase High Availability

A SysOps Administrator is tasked with configuring high availability for an Amazon RDS for MariaDB DB instance. The database must support automated, synchronous failover with zero data loss in the event of an Availability Zone outage. Additionally, the administrator must offload read-heavy reporting queries to a separate database endpoint to minimize performance impact on the primary write instance. Which database configuration will satisfy these requirements?

  1. Modify the database to a Multi-AZ deployment, and create a Read Replica in a separate Availability Zone to handle reporting queries.Answer
  2. B
    Create an RDS Read Replica in a different Availability Zone, and configure the application to perform automated failover to this replica during an outage.
  3. C
    Modify the DB instance to a Multi-AZ deployment, and configure the reporting application to connect directly to the standby database instance's endpoint.
  4. D
    Deploy a Read Replica in a different Availability Zone, and configure an Amazon Route 53 failover routing policy to automatically promote the Read Replica when the primary instance becomes unhealthy.

Answer

Modify the database to a Multi-AZ deployment, and create a Read Replica in a separate Availability Zone to handle reporting queries.
To satisfy both requirements, the database must be configured for Multi-AZ to enable synchronous replication and automatic DNS-based failover. A separate Read Replica must be created to handle the reporting queries because the standby instance in a standard Multi-AZ configuration is passive and cannot be accessed for read queries.

Step-by-Step Solution

1
Evaluate high availability requirements.
Automatic failover with zero data loss requires synchronous replication, which is provided by Amazon RDS Multi-AZ deployments.
Single-AZ deployments or standalone Read Replicas (which replicate asynchronously) do not support synchronous zero-data-loss failover.
2
Address read scaling requirements.
Read-heavy reporting queries should be offloaded to an RDS Read Replica.
The standby instance in a standard Multi-AZ deployment is passive and cannot accept read traffic, so a Read Replica is needed to provide a readable endpoint.
3
Combine configurations to meet both constraints.
The primary DB instance runs in Multi-AZ mode for automated failover, while one or more Read Replicas are created to serve the reporting queries.
This combined architecture ensures high availability for writes and offloads read performance issues.

Key Concept

RDS Multi-AZ vs. Read Replicas for High Availability and Read Scaling
Estimated Time:1m 30s
Rate this question

Topics

Database High Availability

More questions from this topic