An organization is designing a business continuity and disaster recovery strategy for an enterprise web application deployed in the East US and West US regions.
The application must meet the following requirements:
- Route incoming HTTP requests to the closest healthy region based on latency.
- Support SSL offloading at the network edge and route traffic based on URL paths.
- Maximize availability by routing traffic away from an unhealthy region within seconds without relying on client-side DNS cache expiration.
- Provide automatic failover for the backend Azure SQL Database to the secondary region using a single connection string listener.
Which architecture solution should you recommend?
- ADeploy Azure Traffic Manager to manage global traffic routing and Azure SQL Database auto-failover groups for database replication and failover.
- BDeploy Azure Front Door to manage global traffic routing and Azure SQL Database active geo-replication (without auto-failover groups) to handle database failover.
- Deploy Azure Front Door to manage global traffic routing and Azure SQL Database auto-failover groups for database replication and failover.Answer
- DDeploy Azure Traffic Manager to manage global traffic routing and configure Read-Access Geo-Redundant Storage (RA-GRS) to support active-active write operations across both regions.
Answer
Deploy Azure Front Door to manage global traffic routing and Azure SQL Database auto-failover groups for database replication and failover.
The combination of Azure Front Door and Azure SQL Database auto-failover groups meets all requirements. Azure Front Door uses Anycast to route HTTP traffic based on latency, terminates SSL at the edge, performs URL path-based routing, and detects backend failures using fast health probes to redirect traffic within seconds, avoiding DNS caching delays. Azure SQL Database auto-failover groups provide a read-write listener endpoint that automatically fails over the database layer.
Step-by-Step Solution
Key Concept
Contrasting Layer 7 Anycast routing (Azure Front Door) with Layer 4 DNS-based routing (Traffic Manager) and configuring database failover mechanisms.