In part 1 of this series I showed you how to configure the virtual storage required for the cluster. In this part I will show you how to create the SQL cluster as an Active/Passive cluster and in the next part I will show how to convert it to an Active/Active cluster.
In this series of posts I will walk you through the processes of creating an Active/Active SQL server cluster using Hyper-V and Microsoft iSCSI target software for virtualized SAN. The target is to create first a storage server hosted on a normal Windows 2008 R2 server. Then connect to this server using two other machines as iSCSI initiators. Then I will create the windows cluster along with the DTC clustered service. A clustered SQL server instance will then be created. Finally another clustered SQL server instance will be created and Active/Active configuration of both instances will be applied.
The solution is fairly simple as per the below configuration.
Windows Cluster Configuration Steps
Now that we have configured the storage we can start the windows failover cluster configuration.
2- Bring all shared storage online to the current node.
3- Open the cluster management console and click create cluster. Note that it would be preferable to disable all disks at this stage from the iSCSI target but the disk that will be used as the Quorum.
10- If you disabled all disks from the iSCSI target but the Quorum disk then you will need to add them as a new storage to the cluster once they are needed. It is advisable to add every disk you will use once you need it.
SQL Server First Cluster Instance
SQL Server Second Cluster Instance
Now we will go through the installation of a second clustered SQL instance to be prepared as another active instance on the passive node later.
3- Now open the disk management utility and create the active partition on this disk and format it using NTFS.
In the next part I will show you how to configure the two created SQL instances in an Active/Active SQL configuration.