Validating cluster resource name
A SQL Server failover clustered instance is a configuration where all of the nodes of the cluster are connected to the same shared storage. In the Summary dialog box, verify that the nodes are validated and all the tests are passed successfully.However, when deployed on an Azure virtual machine, the Windows Server Failover Cluster (WSFC) must use Azure-hosted storage with one of the following options, as per Microsoft KB 2721672: The Azure-hosted storage used for building a WSFC will leverage Star Wind Virtual SAN for the implementation of a volume-level replication. On the next screen, the synchronization and heartbeat channels for the HA device can be selected and the ALUA settings modified. Click Change network settings and specify the interfaces for synchronization and Heartbeat. Click Finish to create the Windows Server Failover Cluster.This guide is intended for experienced Windows system administrators, IT professionals, and SQL Server database administrators who would like to install and configure a 2-node Windows Server 2016 Failover Cluster that will host a SQL Server failover clustered instance (FCI) on Azure virtual machines. NOTE: It is recommended configuring Heartbeat and i SCSI channels on the same interfaces to avoid the split-brain issue. The added devices will appear in the Star Wind Management Console. Type in the IP address of the partner node you will use to connect to the HA i SCSI devices. Select Microsoft ISCSI Initiator as your Local adapter. In the Completing the New Simple Volume Wizard dialog box, review the settings and click Finish. Repeat the steps above on all of the i SCSI disks that should be configured as part of the cluster. Repeat the steps described in this section on SQLNODE2. This section describes how to run the Failover Cluster Validation Wizard from the Failover Cluster Management console. NOTE: The Cluster Validation Wizard may report Warning messages pertaining to storage.A proper network architecture design is a key to successfully implementing a SQL Server failover clustered instance on Azure. Complete the network selection for Replication and click Next. Select the partner device initialization mode as Synchronize from existing Device and click Next. In this section, the i SCSI storage will be connected to the servers added to the cluster. For this example, the IP address of SQLNODE2 is 10.1.1.202. Select the Initiator IP in the same subnet as the IP address from the previous step. Select Microsoft i SCSI Initiator in the Local adapter dropdown menu. NOTE: In case the Failover Only MPIO policy is used, be sure to check that the local path (127.0.0.1) is set to Active, while the partner connection is set to Standby. To launch the tool, navigate to the Server Manager dashboard, click Tools, and select Failover Cluster Manager. In the Failover Cluster Management console, under the Management section, click the Validate Configuration option. In the Testing Options dialog box, click Next to run all the necessary tests to validate the configuration. These warnings can be ignored since the replicated storage is used instead of shared disks.
This is because the virtual machine originally uses the standard Azure DNS. These steps can be performed on any of the virtual machines with Star Wind Virtual SAN installed. Use the example Power Shell script below to create the Azure internal load balancer. #Add the internal load balancer to the Azure cloud service.
$Primary IP_DC = "10.1.0.100" #IP address of the domain controller/DNS server $Cluster Disk1 = "Cluster Disk_Node1" #name of the Azure hosted data disk #Add Failover Clustering and . In the Select Additional Tasks dialog box, validate the selection by checking the Create a desktop icon check box. Windows Power Shell will be used an instrument for performing the required steps.
NET Framework 3.5 (in preparation for installing SQL Server) Install-Windows Feature -Name Failover-Clustering -Include Management Tools Install-Windows Feature –Name NET-Framework-Core Enable-Windows Optional Feature –Online –Feature Name Multi Path IO #Assign IP address of DNS server on the v NIC assigned on the Production subnet, not the Heartbeat_i SCSI subnet #Identify the interface index of the v NIC assigned on the Production subnet $interface Index=(Get-Net Ip Address | Where ). In the Select Components dialog box, verify that Star Wind Virtual SAN Server is selected in the drop-down list and click Next. In the Select Start Menu Folder dialog box, verify the location of the shortcut to launch Star Wind Virtual SAN. NOTE: These steps can be performed on any of the servers that will act as WSFC nodes. Use the example Power Shell script below to create the Azure internal load balancer. # Define variables $cluster Network Name = "Cluster Network 1" #the cluster network name for the SQL Server FCI #use Get-Cluster Network or Failover Cluster Manager to find the appropriate name $IPResource Name = “SQL IP Address 1 (SQLCLUSAZURE)" #the IP Address resource name of the SQL Server FCI #use Get-clusterresource | where for Failover Cluster Manager to find the appropriate name $ILBStatic IP = “10.1.0.180” #the IP Address of the Azure internal load balancer #Update the WSFC resource parameters of SQL Server FCI IP address to work with the Azure internal load balancer Get-Cluster Resource $IPResource Name | Set-Cluster Parameter -Multiple @ #Take the cluster resource offline and the cluster resource group back online for the changes to take effect Stop-Cluster Resource "SQL IP Address 1 (SQLCLUSAZURE)" Start-Cluster Group "SQL Server (MSSQLSERVER)" This section describes how to test application connectivity for SQL Server 2017 failover clustered instance running on Microsoft Azure.
To connect to the SQL Server failover clustered instance, use the SQL Server virtual network name in SQL Server Management Studio.
Having performed all the steps described above, a 2-node Windows Server 2016 Failover Cluster has been configured.