Route 53

You can use Route 53 failover routing policy to route traffic to the secondary cluster deployed in another region in case outage of the primary cluster. Note that Simple Routing Policy does not support health-checks.

As Elastic Load Blancer does not support RDS instances, you can, however, use Route 53 weighted routing policy to distribute traffic across the RDS Read Replicas. In case of a Read Replica health-check failure, Route 53 weighted record will exlcude those adresses in its reponse to a DNS query.

Routing Policies

GeoProximity Routing lets Amazon Route 53 route traffic to your resources based on the geographic location of your users and your resources. You can also optionally choose to route more traffic or less to a given resource by specifying a value, known as a bias. A bias expands or shrinks the size of the geographic region from which traffic is routed to a resource.

Blue/Green Deployment

You can use weighted routing for blue/green deployement. Read more at Whitepaper: AWS Blue Green Deployment

Reference

• Scale RDS instances
• Distribute requests to RDS read replicas

Note that a reader endpoint for an Aurora DB cluster provides load-balancing support for read-only connections to the DB cluster.

Read more

• Routing internet traffic to AWS resources using Route 53
• Cross-Region DNS-Based Load Balancing and Failover