Ends in
00
days
00
hrs
00
mins
00
secs
SHOP NOW

💝 Valentine's Sale! Get 30% OFF Any Reviewer. Use coupon code: PASSION-4-CLOUD & 10% OFF Store Credits/Gift Cards

Find answers, ask questions, and connect with our
community around the world.

Home Forums AWS AWS Certified Solutions Architect Associate DB instance failover Reply To: DB instance failover

  • Nikee-TutorialsDojo

    Administrator
    January 18, 2025 at 8:31 am

    Hello theodosiostziomakas,

    Thank you for posting here. Let me explain why Option 2 is the correct answer to the question.

    In the given scenario, a single Amazon Aurora instance is used, and there is no mention of Aurora Replicas being configured. When a single-instance Aurora database experiences a system failure, Amazon Aurora attempts to create a new DB instance in the same Availability Zone as the original instance. This process is conducted on a best-effort basis, meaning it depends on the availability of resources in that AZ. If the Availability Zone is experiencing broader issues, this effort may not succeed.

    Option 1 describes the failover process when Amazon Aurora Replicas are present. In such a case, Aurora promotes an existing healthy replica and flips the CNAME record to point to the new primary instance. However, since the scenario explicitly uses a single Aurora instance (with no replicas mentioned), this failover mechanism does not apply. Without replicas, Aurora must attempt to replace the failed instance, aligning with the behavior described in Option 2.

    In summary, the correct answer is Option 2 because the described failover mechanism aligns with the behavior of a single-instance Aurora setup. Option 1 applies only when replicas are available, which is not the case in the scenario.

    Thank you for bringing this important distinction to our attention, and hope this clears up any confusion you have.

    Best regards,
    Nikee @ Tutorials Dojo

Skip to content