Autoscale LANSA Windows VM ScaleSet with Azure SQL Database

autor: Rob Goodridge

Ostatnia aktualizacja: 04.11.2019

Wdrażanie na platformie Azure Przeglądaj w usłudze GitHub

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)

Ten szablon usługi Azure Resource Manager (ARM) został utworzony przez członka społeczności, a nie przez firmę Microsoft. Każdy szablon ARM jest licencjonowany przez swojego właściciela, a nie firmę Microsoft. Firma Microsoft nie odpowiada za szablony ARM dostarczane i licencjonowane przez członków społeczności i nie sprawdza ich pod kątem bezpieczeństwa, zgodności ani wydajności. Szablony ARM społeczności nie są wspierane w ramach żadnego programu lub usługi pomocy technicznej firmy Microsoft i są udostępniane W STANIE, W JAKIM SIĘ ZNAJDUJĄ bez żadnego rodzaju gwarancji.

Parametry

Nazwa parametru	Opis
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

Korzystanie z szablonu

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

Instalowanie i konfigurowanie programu PowerShell systemu Azure

Wiersz polecenia

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

Instalowanie i konfigurowanie międzyplatformowego interfejsu wiersza polecenia platformy Azure

Więcej szablonów szybkiego startu platformy Azure