multi-region app service with sql database -active active mode

Ganesh Prasad 26 Reputation points
2022-04-18T03:37:44.653+00:00

Hi ,
I am looking for reference architecture for azure app service with SQL in active-active mode .I have an existing asp.net core application with sql server in US region .I want to create a another instance of azure app service with sql server in Europe region in active-active mode and load balance the request using front door .For performance reason, I am looking for options of app service to write data to sql server in same region . I have read about sql server geo replication ,failover group and this does not support write in two regions. Is there any other options with sql server ?

active-passive mode is described here .
https://learn.microsoft.com/en-us/azure/architecture/reference-architectures/app-service-web-app/multi-region

Thank you very much in advance.

Azure SQL Database
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,351 questions
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 33,421 Reputation points MVP
    2022-04-18T13:35:10.42+00:00

    You can have Azure SQL databases replicating between them while have them on different regions and even on different subcriptions using SQL Data Sync. You can read and write data between the databases involved on the Data Sync configuration. Using that free tool (SQL Data Sync) you can have bi-directional replications between Azure SQL databases with a frequency of seconds, minutes, hours, and days.

    At the application level, when your applications needs to run a query, it needs to connect to the appropriate location. You can use sharding and the elastic database client tools/library to determine to what database/region you have to connect.

    Hope this helps.


0 additional answers

Sort by: Most helpful