Subscribe

NetApp + Microsoft Cluster + SQL Cluster - HowTO

Hello everyone


My Colleague is on hospital right now and he´s the best one handling the NetApp here. He won’t be back for 8 weeks so I have to get a new 2-node Active/Passive SQL Cluster up and running on my own..


What I have is Windows 2008 Server ENT, SQL Server 2008 R2 STD. And VMware ESX 4 with vSphere Virtual Center. And ofc  the NetApp Filers. I have today a big VMware environment up and running with some 400 VM´s on the NetApp, but no Windows Clusters.
I would like to have some guidance where it comes to installation order of all components and some on configuration of those:

Microsoft Cluster Services
MPIO
iSCSI initiator ( well it´s on the control panel )
NetApp Host Configuration Utility
NetApp SnapManager
NetApp SnapManager for SQL
Microsoft SQL Server

And where and from what I create and bind the LUN:s, resources in the right order for the cluster services.


I haven’t found any real help on the internet for this scenario, and since my colleague is on hospital, everything has to happen right now, a thousand things to do..

The only thing I found that I have been thinking about is this scenario: https://communities.netapp.com/community/netapp-blogs/msenviro/blog/2011/02/18/install-order-for-hyper-v-clusters But i Don’t know if I need to have MPIO, Host Configuration Utility and so on.

Can you help me with some guidance please

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

A hard nut to crack ?

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

Hi and welcome to the Community!

Few questions:

- are you talking about clustered SQL nodes running on physical hardware, or as VMs on top of vSphere?

- what version of SMSQL are we talking about?

- what version of SnapDrive?

Regards,

Radek

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

Yes two Windows 2008 cluster nodes with SQL 2008R2 on top of VmWare

SMSQL 5.0R1

SnapDrive 6.3.1R1

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

So this is a very tricky subject then.

For a starter, 'proper' iSCSI (via VMware stack) is not supported for Microsoft clusters:

http://www.vmware.com/pdf/vsphere4/r40/vsp_40_mscs.pdf, p12

VMware is hinting a workaround in vSphere 5 by using software iSCSI initiator inside a guest:

http://pubs.vmware.com/vsphere-50/topic/com.vmware.ICbase/PDF/vsphere-esxi-vcenter-server-50-mscs-guide.pdf, p9

But this is not the recommended setup on the NetApp side - all recent best practices suggest using VMware iSCSI stack, which brings us to square 1: MSCS not supported.

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

My intention is to use Windows iSCSI initiator withing windows for the LUN:s used by SQL

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

A a bit risky scenario - especially if you have no extensive experience with NetApp (if I understand your initial post correctly).

You can easily find some best practices documents here (limit search to Technical Reports):

http://www.netapp.com/library/

but I don't think any of them will match your exact requirement.

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

Please look through TR 3941 for helping you on the deployment and prerequisites.Also read through TR 3785 .

Regards,

Abhishek

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

So you think that it should work?

Re: NetApp + Microsoft Cluster + SQL Cluster - HowTO

Where should i install the SQL binaries ? Can i put those on a VMDK-file and have the binaries only there, or do I have to put the binaries on a LUN together with the system databases ?