Which solution will provide the HIGHEST availability for the database?
Configure automated backups on Amazon RDS. In the case of disruption, promote an automated backup to be a standalone DB instance. Direct database traffic to the promoted DB instance. Create a replacement read replica that has the promoted DB instance as its source.
Configure global tables and read replicas on Amazon RDS. Activate the cross-Region scope. In the case of disruption, use AWS Lambda to copy the read replicas from one Region to another Region.
Configure global tables and automated backups on Amazon RDS. In the case of disruption, use AWS Lambda to copy the read replicas from one Region to another Region.
Configure read replicas on Amazon RDS. In the case of disruption, promote a cross-Region and read replica to be a standalone DB instance. Direct database traffic to the promoted DB instance. Create a replacement read replica that has the promoted DB instance as its source.
Explanations:
While automated backups allow recovery from disruptions, promoting a backup to a standalone instance may not guarantee the highest availability. This option lacks real-time replication and fails to maintain continuous uptime during failover.
Configuring global tables and read replicas allows for cross-Region replication, but using AWS Lambda to copy read replicas is not a direct approach for maintaining availability. If the primary Region is disrupted, this method would not ensure immediate availability, making it less suitable for high availability needs.
Although global tables provide cross-Region replication, relying solely on AWS Lambda to copy read replicas is inefficient for ensuring high availability. This setup may introduce latency and potential data loss in failover scenarios, making it not the best option for maintaining continuous uptime.
This option provides the highest availability by allowing real-time replication with read replicas across Regions. In case of disruption, promoting a cross-Region read replica ensures minimal downtime. It allows for quick failover and maintains continuous availability for the application.