So looking at https://our.umbraco.com/Documentation/Getting-Started/Setup/Server-Setup/Load-Balancing/flexible we can to a certain extent get resilience with clustered server setup which is all fine. However this works where you have all the instances using the same db.

I have a requirement where as well as webapp redundancy (site is on azure) I need db redundancy. So in this case would we need to use sql replication? But then a publish on the primary i would need to trigger a publish on secondary but i cannot be sure that sql replication has taken place?

Is this kind of setup even possible?

Regards

Ismail