This template creates Azure VMs on an existing VNET, and provisions a SQL Server 2016 AlwaysOn Availability Group cluster across Availability Zones
이 ARM(Azure Resource Manager) 템플릿은 Microsoft가 아니라 커뮤니티 구성원에 의해 만들어졌습니다. 각 ARM 템플릿은 Microsoft가 아닌 해당 소유자에 의해 사용이 허가됩니다. Microsoft는 커뮤니티 구성원에 의해 제공 및 라이선스가 부여된 ARM에 대해 책임이 없으며, 보안, 호환성 또는 성능을 검사하지 않습니다. 커뮤니티 ARM 템플릿은 Microsoft 지원 프로그램 또는 서비스에서 지원되지 않고, 어떠한 보증도 없이 있는 그래도 제공됩니다.
매개 변수
| 매개 변수 이름 | 설명 |
|---|---|
| location | Location for the VM, only certain regions support Availability Zones |
| namePrefix | Naming prefix for each new resource created. 3-char min, 8-char max, lowercase alphanumeric |
| vmSize | Size of the SQL Server VMs to be created |
| vmCount | Number of SQL Server VMs to be created in AlwaysOn Availability Group cluster (Min=2, Max=9) |
| vmDiskSize | Size of each data disk in GB on each SQL Server VM (Min=128, Max=1023) |
| vmDiskCount | Number of data disks on each SQL Server VM (Min=2, Max=32). Ensure that the VM size you've selected will support this number of data disks. |
| existingDomainName | DNS domain name for existing Active Directory domain |
| adminUsername | Name of the Administrator of the existing Active Directory Domain |
| adminPassword | Password for the Administrator account of the existing Active Directory Domain |
| sqlServiceAccount | Name of the user account to be used for the SQL Server service account |
| sqlServicePassword | Password to be used for the SQL Server service account |
| existingVirtualNetworkRGName | Resource Group Name for the existing VNET. |
| existingVirtualNetworkName | Name of the existing VNET. |
| existingSubnetNames | Name of the existing subnets in the existing VNET to which the SQL Server VMs should be deployed |
| workloadType | SQL DB workload type: GENERAL - General workload; DW - Data Warehouse workload; OLTP - Transactional Processing workload |
| _artifactsLocation | Location of resources that the script is dependent on such as linked templates and DSC modules |
| _artifactsLocationSasToken | The sasToken required to access _artifactsLocation. When the template is deployed using the accompanying scripts, a sasToken will be automatically generated. |
템플릿 사용
PowerShell
New-AzureRmResourceGroupDeployment -Name <deployment-name> -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/azure/azure-quickstart-templates/master/sql-alwayson-md-mult-subnets-zones/azuredeploy.jsonAzure 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/sql-alwayson-md-mult-subnets-zones/azuredeploy.jsonAzure 크로스 플랫폼 명령줄 인터페이스 설치 및 구성