We have a web solution that we sell and it comes with 1 dedicated Azure VM containing everything it requires to run the application:
- ASP.NET web application
- Production environment
- QA environment
- SQL server containing data for both PROD and QA environment
A specific customer however, has a user requirement to run his application in a high availability setup. What he wants is that when 1 server goes down, the other one should take over and vice versa.
I'm completely new to load balancing/high availability set ups and I know that Azure supports load balancing, but I'm puzzled how I could make it work. Is it as easy to just create 2 servers with the above set up and then get the high availability functionality set up? My concern is how I would get the website data and SQL Server data in sync between the 2 servers? Especially the latter.
Or would it be easier if I used the Azure SQL server instead of a local SQL server? Or perhaps introducing additional servers rather than 2?