Hi all,
I've been looking at how I can expand an Azure deployment to factor in a multi-region BCDR aspect - preferably a load balanced active/active HA approach to make it light-touch - but I'd take an active/passive approach if I had to.
For a starting point see attached image. It's a very summary view I realise, the concern here is Umbraco does locks at the application level rather than the database level - and can only have one admin portal - which would suggest the failover region would be in essence 'read only' while the primary region had a fault - and that would be acceptable - but it doesn't account for the lock constraint.
Ergo, If we had West as primary, we could be replicating the SQL to South constantly, but if we have an outage in West, then we'd need a runbook action of some kind to switch the traffic at the frontdoor and start the app service in South with it pointing at the replicated SQL DB.
Doesn't seem optimal, and would still absolutely leave a period where there's no functioning service - which isn't a good selling point.
So my question is this - am I missing something obvious? Am I going about this the wrong way? How has the community provided a BCDR aspect to their deployments?
https://cdn.discordapp.com/attachments/1311276400942121010/1311276401101639760/image.png?ex=674844d0&is=6746f350&hm=295ad5331eddf74f3e63a9ccd4fce9f0aa60d70cbe060311b53fa7171de16af4&