Question
Comments
2 comments
-
I'l repost with my current account :-) -
Here we are again ...
Where is DBServer2 located? If it is not in de the same region you need to use async commit.
Otherwise delay will cause application issues.
I recommend you read through this article:
https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-overview?view=azuresql
The biggest difference with on-prem is:
- Load balancer that is needed in Azure
- All nodes inside your cluster need to be a member of an availability set
- I also recommend using striped volumes for your SQL files to foresee better performance:
https://learn.microsoft.com/en-us/gaming/azure/game-dev-virtual-machine/striped-disks-iops
Feel free to contact me afterwards if you still have questions. I've done it in the past on SQL 2016 and by the looks of it , not too much has changed.
Add comment
Please sign in to leave a comment.