how to create a vm which will satisfy both my clients in singapore and UK

Question

we have a problem of distributing network traffic . for example our main server in is southeast asia with SQL web 2022. Users from UK are currently facing a lag when accessing appplication and the sql database data. how to create a vm which will satisfy both my clients in singapore and UK

Answer 1

Hi DevOps BackendTeam

Thanks for using the Q&A platform.

Here's a recommended approach using geo-distributed architecture and traffic optimization techniques:

Deploy Regional VMs + Replicated SQL Setup

1. Deploy Secondary VM in the UK.
   1. Clone your application setup and place it close to UK users for lower latency.
2. Implement SQL Replication
   1. Use SQL Server 2022 replication between Southeast Asia and the UK:
      1. Transactional Replication for near real-time sync.
      2. Or use Always On Availability Groups if you need read/write on both sides; this requires a Windows Server Failover Cluster.
   2. UK users read from the UK SQL replica (read-only if needed), Singapore users use the primary.
3. Use Global Load Balancer

Use Azure Front Door to route traffic based on user location (geo-proximity) to the nearest app instance

Kindly find Microsoft documentation for more insight:
https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-replication-for-always-on-availability-groups-sql-server?view=sql-server-ver17
https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/read-scale-availability-groups?view=sql-server-ver17
https://learn.microsoft.com/en-us/azure/frontdoor/
https://learn.microsoft.com/en-us/azure/load-balancer/cross-region-overview

Lastly, host the app in a middle-ground region if managing replication is too complex.

If the response was helpful, please feel free to mark it as “Accepted Answer” and consider giving it an upvote. This helps others in the community as well.

Regards,

Obinna.