Multi-region web app with private connectivity to database - Azure Example Scenarios | Code it | Scoop.it
From docs.microsoft.com - March 5, 2021 4:54 PM

This example scenario discusses a highly available solution for a web app with private connectivity to a SQL database. A single-region architecture already exists for a web app with private database connectivity. This solution extends that base architecture by making it highly available.

 

To offer high availability, this solution:

  • Deploys a secondary instance of the solution in another Azure region.
  • Uses auto-failover groups for geo-replication and high availability of the database.

 

You can achieve high availability with a complete region failover.

 

However, this solution uses a partial region failover. With this approach, only components with issues fail over:

  • If the primary database fails over, the web app in the primary region connects to the newly activated secondary database while maintaining private connectivity.
  • If the app goes down in the primary region, the instance in the secondary region takes over. That instance connects to the primary database, which is still active.

Potential use cases

With private connectivity to a SQL database and high availability, this solution has applications in many areas. Examples include the financial, healthcare, and defense industries.