Creating an Active/Active SQL Cluster using Hyper-V: Part1 Virtualized Storage

Article
04/10/2012

Introduction

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.

Solution Architecture

The solution is fairly simple as per the below configuration.

Preparation

You need to create three virtual machines as illustrated above. One as the AD and storage server and another two as the SQL server nodes that will act as Active/Active nodes.

These are all windows 2008 R2 servers and we have created the domain and joined all servers to this domain. You need also to setup two network cards in each machine to function as normal LAN connection and another one for the cluster heartbeat. It would be advisable also to separate the storage usage to another network if you have heavy usage. The configuration given here is all static with normal local IPs assigned on all network cards.

Virtualized SAN Steps

In this section we will go through the needed steps to create the virtual storage server based SAN.

Configuring the iSCSI Target

1- Download the required iSCSI target software from https://www.microsoft.com/download/en/details.aspx?id=19867.

2- Copy the software to the storage server UK-LIT-AD in this case.

3- Double click the file to start the installation.

4- After it completes it will take you to a web page

5- Scroll down and click as below

8- Click install

10- Now open server manager and you will find a new tree as below

11-

12- Give the new target a name (Just any name)

13- In the initiator list just click advanced and enter all the domain names of the servers that will have access to this target. In our case this is UK-LIT-DB1 and UK-LIT-DB2.

14- If it displays a warning about the multiple initiators just accept it.

15- Click finish. And now you have completed the creation of your iSCSI target and what remains is to add the required virtual disks to it.

16-

17- Place the new VHD and give it a name.

18- Choose the disk size

19- Click finish and this would create the fixed size disk.

20- You will need to create the following disks so just follow the same approach

Disk	Purpose
Quorum	Cluster Quorum
DTC1	DTC cluster 1 log disk
DTC2	DTC cluster 2 log disk
SQL1	SQL cluster 1 shared disk
SQL2	SQL cluster 2 shared disk