Autoscale a LANSA Windows VM Scale Set using an existing Database

Last updated: 12/15/2016

This template deploys a Windows Virtual Machine Scale Set with a desired count of Virtual Machines in the scale set and a LANSA MSI to install into each Virtual Machine. Once the Virtual Machine Scale Set is deployed a custom script extension is used to install the LANSA MSI. The database server must already exist. The database within the database server must already exist too, unless its SQL Server, in which case it will be created. If the database does exist it must either not have any LANSA tables or already have had the same MSI installed. This is not checked by the template. Once this template has been run, it must be the only way that an upgrade to the MSI is applied. Two different MSI installs should not attempt to upgrade a LANSA install. This is very important in order that the SQL tables are upgraded correctly. Current databases supported are Azure SQL Database, Microsoft SQL Server and MySql

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

Parameters

Parameter Name Description
msiURL URL of the LANSA MSI which will be installed on each virtual machine.
virtualMachineSize Size of Virtual Machines in the Virtual Machine Scale Set.
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.
minimumInstanceCount Minimum number of Virtual Machine instances (1 or more).
maximumInstanceCount Maximum number of Virtual Machine instances (100 or less).
databaseType Refer to LANSA documentation for an explanation of each Database Type and the supported versions of the database servers
databaseServerName The name of the existing Database Server to connect to. If the name has /MSSQLSERVER appended, omit it.
databaseName The name of the existing database to connect to.
databaseLogin The admin user of the Database
databaseLoginPassword The password of the admin user of the Database
adminUsername Admin username on all Virtual Machines.
adminPassword Admin password on all Virtual Machines.
webUsername Web Server username on all Virtual Machines.
webPassword Web Server password on all Virtual Machines.
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.
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.
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-AzureRmResourceGroupDeployment -Name <deployment-name> -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/azure/azure-quickstart-templates/master/lansa-vmss-windows-autoscale-existing-db/azuredeploy.json
Install and configure Azure PowerShell
Command line
azure config mode arm
azure group deployment create <my-resource-group> <my-deployment-name> --template-uri https://raw.githubusercontent.com/azure/azure-quickstart-templates/master/lansa-vmss-windows-autoscale-existing-db/azuredeploy.json
Install and Configure the Azure Cross-Platform Command-Line Interface