Autoscale LANSA Windows VM ScaleSet with Azure SQL Database

Last updated: 04/11/2019

The template deploys a Windows VMSS with a desired count of VMs in the scale set and a LANSA MSI to install into each VM. Once the VM Scale Set is deployed a custom script extension is used to install the LANSA MSI)

This Azure Resource Manager (ARM) template was created by a member of the community and not by Microsoft. Each ARM template is licensed to you under a licence agreement by its owner, not Microsoft. Microsoft is not responsible for ARM templates provided and licensed by community members and does not screen for security, compatibility or performance. Community ARM templates are not supported under any Microsoft support programme or service, and are made available AS IS without warranty of any kind.

Parameters

Parameter Name Description
location Resource Group Location.
msiURL URL of the LANSA MSI which will be installed on each virtual machine.
virtualMachineSize Size of the Virtual Machines in the Virtual Machine Scale Set.
dbVirtualMachineSize Size of the Virtual Machine which manages the database.
stackName String used as a base for naming resources. Must be 3-61 characters in length and globally unique across Azure. A hash is prepended to this string for some resources, and resource-specific information is appended. Some identifiers use precisely 9 characters from this name and so it can be useful to use exactly 9. The template pads it out or truncates it as necessary to make it 9 characters long where required.
applicationGatewaySkuTier Application Gateway SKU Tier
applicationGatewaySkuName Application Gateway SKU Name
applicationGatewayCapacity Number of Application Gateway instances
certificateBase64Encoded Base 64 encoded String representing the SSL certificate
certificatePassword SSL certificate password
minimumInstanceCount Minimum number of Virtual Machine instances (1 or more).
maximumInstanceCount Maximum number of Virtual Machine instances (100 or less).
databaseNewOrExisting Determines whether a new SQL database should be provisioned or to use an existing database. Parameters which are relevant to choosing 'new' are prefixed 'New DB'. Parameters which are relevant to choosing 'existing' are prefixed 'Existing DB'.
databaseType Existing DB. Refer to LANSA documentation for an explanation of each Database Type and the supported versions of the database servers. DO NOT CHANGE THIS IF CREATING A NEW DATABASE. IT MUST BE SET TO SQLAZURE.
databaseServerName Existing DB. The name of the existing Database Server to connect to. If the name has /MSSQLSERVER appended, omit it.
databaseName The name of the new database to create or name of the existing database to connect to.
databaseLogin The admin user of the Azure SQL Database
databaseLoginPassword The password of the admin user of the Azure SQL Database
collation New DB. The new database collation for governing the proper use of characters.
edition New DB. The type of database to create.
requestedServiceObjectiveName New DB. Describes the performance level for Edition
maxSizeBytes New DB. The maximum size, in bytes, for the new database
adminUsername Admin username on all VMs.
adminPassword Admin password on all VMs.
webUsername Web Server username on all VMs. This must be different to the Admin Username.
webPassword Web Server password on all VMs.
webServerMaxConnect The maximum number of LANSA jobs to run on each Web Server. Setting triggerWebConfig will cause this value to be updated.
installMSI Install the MSI: Set this to 1 to execute an MSI install. Usually set to 0 when updating the stack
updateMSI Update Stack: Set this to 1 to execute an MSI Upgrade. Obtains the specified MSI and installs it. Ensure the LansaMSI parameter is set correctly. If the LansaMSI parameter is not different a repair will be performed
uninstallMSI Uninstall the MSI: Set this to 1 to uninstall the MSI. The MSI used to uninstall, is the last one that was installed. It is called c:\lansa\MyApp.msi
triggerWebConfig Update Stack: Set this to 1 to update the web configuration
imageOffer The offer of the image. Allowed values: lansa-scalable-license, lansa-scalable-license-preview
gitBranch Git Branch
trace Switch tracing on. Allowed values Y or N
fixLicense Re-run licensing. It is unlikely that this parameter needs to be used

Use the template

PowerShell

New-AzResourceGroup -Name <resource-group-name> -Location <resource-group-location> #use this command when you need to create a new resource group for your deployment
New-AzResourceGroupDeployment -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/lansa-vmss-windows-autoscale-sql-database/azuredeploy.json
Installing and configuring Azure PowerShell

Command line

az group create --name <resource-group-name> --location <resource-group-location> #use this command when you need to create a new resource group for your deployment
az group deployment create --resource-group <my-resource-group> --template-uri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/lansa-vmss-windows-autoscale-sql-database/azuredeploy.json
Installing and configuring the Azure cross-platform command-line interface