Create a SQL Server AlwaysOn Cluster Deployment

weidaiMS 提供
上次更新时间: 2016/4/28

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

此 Azure Resource Manager (ARM) 模板由社区的某个成员(而不是由 Microsoft)创建。每个 ARM 模板都根据其所有者(不是 Microsoft)的许可协议向你授予许可。Microsoft 不对由社区成员提供并授予许可的 ARM 模板负责,并且不针对安全性、兼容性和性能进行筛选。社区 ARM 模板不由任何 Microsoft 支持计划或服务提供支持,按“原样”提供,没有任何种类的担保。

参数

参数名 说明
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

使用模板

PowerShell
New-AzureRmResourceGroupDeployment -Name <deployment-name> -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/azure/azure-quickstart-templates/master/sqlvm-alwayson-cluster/azuredeploy.json
安装和配置 Azure PowerShell
命令行
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/sqlvm-alwayson-cluster/azuredeploy.json
安装和配置 Azure 跨平台命令行界面