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

Question

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.

Answer 1

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.