Amazon CLF-C01 Exam: AWS RDS Failover Options

AWS RDS Failover Options

Question

Which of the following options of AWS RDS allows for AWS to failover to a secondary database in case the primary one fails?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

Answer - A.

The AWS Documentation mentions the following.

Amazon RDS Multi-AZ deployments provide enhanced availability and durability for Database (DB) Instances, making them a natural fit for production database workloads.

When you provision a Multi-AZ DB Instance, Amazon RDS automatically creates a primary DB Instance and synchronously replicates it to a standby instance in a different Availability Zone (AZ)

Each AZ runs on its own physically distinct, independent infrastructure and is engineered to be highly reliable.

In case of an infrastructure failure, Amazon RDS performs an automatic failover to the standby (or to a read replica in the case of Amazon Aurora)

So you can resume database operations as soon as the failover is complete.

Options B, C and D are the distractors because there is no AWS service like failover, standby or secondary.

Failover is the situation when Multi-AZ appears and Standby or Secondary represents other RDS servers appears during Multi-AZ deployments.

For more information on AWS RDS Multi-AZ, visit the below link:

https://aws.amazon.com/rds/details/multi-az/

The correct answer is A. Amazon RDS Multi-AZ deployments.

Amazon RDS (Relational Database Service) is a managed database service offered by Amazon Web Services (AWS) that allows you to create and operate relational databases in the cloud. Amazon RDS provides easy deployment, scaling, and management of popular relational database engines such as MySQL, PostgreSQL, Oracle, and Microsoft SQL Server.

A Multi-AZ deployment is a feature of Amazon RDS that provides high availability and fault tolerance for database instances. In a Multi-AZ deployment, AWS automatically provisions and maintains a synchronous standby replica of your primary database instance in a different availability zone (AZ) within the same region. If the primary database instance fails due to hardware failure, software failure, or availability zone outage, AWS automatically switches over to the standby replica, which becomes the new primary database instance.

The failover process in Multi-AZ deployments is automatic and does not require any manual intervention. The DNS endpoint of the database remains the same, so your applications can continue to connect to the database without any changes. After the failover, the original primary instance is replaced by a new standby instance, and replication is resumed.

To summarize, Amazon RDS Multi-AZ deployments provide a high availability solution for your database by automatically provisioning and maintaining a synchronous standby replica in a different availability zone, and by automatically failing over to the standby replica in case of a primary instance failure.