AWS Certified DevOps Engineer - Professional
Get started today
Ultimate access to all questions.
A company's application relies on a MySQL-compatible Amazon Aurora Multi-AZ DB cluster, which includes a cross-Region read replica established for disaster recovery. In the event of a primary database failure, a DevOps engineer needs to automate the process of promoting the read replica to become the new primary database instance. What solution should be implemented to achieve this automation?
A company's application relies on a MySQL-compatible Amazon Aurora Multi-AZ DB cluster, which includes a cross-Region read replica established for disaster recovery. In the event of a primary database failure, a DevOps engineer needs to automate the process of promoting the read replica to become the new primary database instance. What solution should be implemented to achieve this automation?
Explanation:
The correct answer is D. This option uses AWS Systems Manager Parameter Store to store the Aurora endpoint, which allows for dynamic retrieval of the endpoint by the application. Additionally, it employs Amazon EventBridge to detect database failures and triggers an AWS Lambda function to promote the read replica to the primary instance and update the endpoint URL in Parameter Store. The application can then dynamically reload the updated endpoint if a database connection fails, ensuring a seamless transition with minimal downtime.