Building Microsoft SQL Server AlwaysOn Availability Groups – Part 2 – Create cluster and configure OS


Storage

We do not need any clustered disk for this type of SQL cluster that we will create but unless you do not want to store all database data and logs on the C volume (not recommended in the production environment) you need enough local disks.

  • In our case we do not need too many disks so we do not have to use Mount Point disk.
  • Add multiple disks in the to your VM, format them and assign a drive letter.
    • PowerShell
# Make all disks online but do not initialize them
Get-Disk | Where-Object IsOffline | Set-Disk -IsOffline:$false

# Make all disks online, initialize them and format them - Sort-Object ensure that the drive letters follow one another by disk number
Get-Disk | Where-Object partitionstyle -eq 'raw' | Sort-Object -Property Number | Initialize-Disk -PartitionStyle GPT -PassThru | New-Partition  -AssignDriveLetter -UseMaximumSize | Format-Volume -FileSystem NTFS -AllocationUnitSize 65536 -Confirm:$false

Create cluster

  • Join all servers to the domain.
  • Install Failover Clustering.
    • PowerShell
Install-WindowsFeature -Name Failover-Clustering -IncludeManagementTools
  • Create Cluster Wizard
      • contdb1c0n0; contdb1c0n1; contdb1c0n2
  • Validate a Configuration Wizard
  • Check the report.
  • Warnings in the section with Network tests were expected because I have only one virtual network adapter on each VM.
  • Warnings in the Storage tests section was also expected because we do not have disks that can be used by the cluster.
  • Set name and IP of the cluster
      • contdb1c0
  • We do not have any storage suitable for the cluster.
  • Check the results. Warning about the storage was expected.
      • Warning: An appropriate disk was not found for configuring disk witness. The cluster is not configured with a quorum witness. As a best practice, configure a quorum witness to help achieve the highest availability of the cluster.

Leave a Reply

Your email address will not be published. Required fields are marked *

Active Directory Advanced function AlwaysOn Availability Groups AlwaysOn Failover Cluster Instances Building Cloud Cloud Cluster Cmdlet Database Deployment Design DFS Domain Controller DSC Fabric Failover Clustering File Server Group Policy Hardware Profile Host Hyper-V Installation Library Library Asset Library Server Network Operations Manager Orchestrator PowerShell PowerShell User Group PowerShell Workflow Security Service Manager SQL Server Storage System Center Template Time Time Synchronization Tips Virtual Machine Virtual Machine Manager VM Network VM Template Windows Server 2012 R2