question

Azurebegginer avatar image
0 Votes"
Azurebegginer asked Azurebegginer commented

Virtual machine scale sets for web servers - back end SQL server AG

Hello All,

Hope safe and well

We are planning to use VM scale set for web servers as front end and back end covered by SQL Server always on on VM.

I need help to understand the deployment of web servers on VM scale set.

  1. Deploy a VM with IIS and deploy the web site with code and connection string to back end SQL server

  2. Deply the VM to scale set.

Is this the right process??

Please advice



azure-sql-virtual-machinesazure-virtual-machines-scale-set
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

vipullag-MSFT avatar image
0 Votes"
vipullag-MSFT answered Azurebegginer commented

@NeerajV-6011

Below are few suggestions for your ask:

If you have a custom image already built with all necessary configurations (IIS and DB connections), you can deploy that image to VMSS (VM can be deployed into VMSS only at creation time). And then can connect to SQL server. Here is the doc reference on this.

Another consideration is to use Custom script extension. With this you can avoid building custom image every-time there is a change. You can have scripts to do the configuration on the VM. You can also consider using Azure Key Vault for storing DB string. Please refer this document.

Also, below are few quick start templates that you can check:

https://azure.microsoft.com/en-us/resources/templates/301-multi-vmss-linux-lb-zones/

https://azure.microsoft.com/en-us/resources/templates/201-vmss-custom-script-windows/





Please 'Accept as answer' if it helped, so that it can help others in the community looking for help on similar topics.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you. If I need to have a change of code, normally how the developers do, how can the developers change the code or deploy the code to VMSS?

Do they need to deploy the code to all the VMs (say 50) or there is a short way for this?

0 Votes 0 ·