Home icon
Deploy multi-Region Amazon RDS for SQL Server using cross-Region read replicas with a disaster recovery blueprint – Part 2

Blog



This article demonstrates how to perform cross-Region failover for RDS SQL Server using disaster recovery blueprint with Route 53 and S3.

  • Promote RDS SQL Server read replica to standalone instance in secondary Region
  • Verify replica lag is acceptable before initiating failover to prevent data loss
  • Conduct smoke tests to validate application functionality in secondary Region
  • Upload disaster recovery file to S3 to trigger Route 53 health check failure
  • Route 53 automatically fails over internet traffic to secondary Region
  • Enable multi-AZ on promoted instance for in-Region high availability
  • Recreate cross-Region read replica when primary Region recovers
  • Application uses consistent Route 53 CNAME records; no configuration changes needed

This solution provides automated failover between AWS Regions using Route 53 health checks and S3 file uploads, minimizing application downtime during disasters.



Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.