The Azure Quickstart templates are currently available in English
Create a SQL Server AlwaysOn Cluster Deployment
Sist oppdatert: 11.09.2018
This template creates 5 new Azure VMs, each group load balancer and a VNet. It configures a primary and backup AD Domain Controller for a new Forest and Domain, two SQL Servers and witness in AlwaysOn configuration
Denne Azure Resource Manager (ARM)-malen ble opprettet av et medlem av fellesskapet og ikke av Microsoft. Hver ARM-mal er lisensiert til deg i henhold til en lisensavtale med eieren, ikke med Microsoft. Microsoft er ikke ansvarlig for ARM-maler som leveres og lisensieres av medlemmer og siler dem ikke ut med tanke på sikkerhet, kompatibilitet eller ytelse. Fellesskapets ARM-maler støttes ikke av noe Microsoft-støtteprogram eller -tjeneste, og er gjort tilgjengelig SOM DE ER, uten noen form for garanti.
Parametere
Parameternavn | Beskrivelse |
---|---|
adminUsername | The name of the Administrator of the new VMs and Domain |
adminPassword | The password for the Administrator account of the new VMs and Domain |
adVMSize | The size of the AD VMs Created |
sqlVMSize | The size of the SQL VMs Created |
witnessVMSize | The size of the Witness VM Created |
domainName | The FQDN of the AD Domain created |
sqlServerServiceAccountUserName | The SQL Server Service Account name |
sqlServerServiceAccountPassword | The SQL Server Service Account password |
sqlStorageAccountName | The name of Sql Server Storage Account |
sqlStorageAccountType | The type of the Sql Server Storage Account created |
dcStorageAccountName | The name of DC Storage Account |
dcStorageAccountType | The type of the DC Storage Account created |
virtualNetworkAddressRange | The address range of the new VNET in CIDR format |
staticSubnet | The address range of the subnet static IPs are allocated from in the new VNET |
sqlSubnet | The address range of the SQL subnet created in the new VNET |
adPDCNICIPAddress | The IP address of the new AD VM |
adBDCNICIPAddress | The IP address of the new backup AD VM |
sqlLBIPAddress | The IP address of the new SQL Server Internal Load Balancer |
deploymentPrefix | The DNS Prefix for the Public IP Address for the Always On Cluster |
virtualNetworkName | Name of virtual network to be created |
templatesBaseUrl | Linked Templates base url |
scriptsBaseUrl | DSC Scripts base url |
autoPatchingDay | The day of a week for auto patching |
autoPatchingStartHour | The start hour of a day for auto patching |
sqlAOAGName | The Sql AlwaysOn Group Name |
sqlAOListenerPort | The Sql AG Listener port |
sqlAOListenerName | The Sql AG Listener Name |
sqlServerVersion | The Sql Server Version |
numberOfSqlVMDisks | The Sql VM Disk Size |
workloadType | The Sql VM work load type: GENERAL - general work load; DW - datawear house work load; OLTP - Transactional processing work load |
location | Location for all resources. |
Bruke malen
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 deploymentInstallere og konfigurere Azure PowerShell
New-AzResourceGroupDeployment -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/sqlvm-alwayson-cluster/azuredeploy.json
Kommandolinje
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 deploymentInstaller og konfigurer Azures kommandolinjegrensesnitt for alle plattformer
az group deployment create --resource-group <my-resource-group> --template-uri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/sqlvm-alwayson-cluster/azuredeploy.json