Microsoft Virtualization Discussions

NetApp + Microsoft Cluster + SQL Cluster - HowTO

PLASTIQUE
10,002 Views

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

21 REPLIES 21

PLASTIQUE
9,921 Views

A hard nut to crack ?

radek_kubka
9,921 Views

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

PLASTIQUE
9,921 Views

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

SMSQL 5.0R1

SnapDrive 6.3.1R1

radek_kubka
9,921 Views

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.

PLASTIQUE
9,921 Views

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

radek_kubka
9,577 Views

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.

abhisek
9,921 Views

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

Regards,

Abhishek

PLASTIQUE
9,921 Views

So you think that it should work?

PLASTIQUE
9,921 Views

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 ?

radek_kubka
7,482 Views

SQL binaries should be on VMDK file in my view.

PLASTIQUE
7,481 Views

For this cluster, should I create separate volumes for Quorum, MSDTC and Data ? Like this ?:

Volume1, will be for LUN Quorum

Volume2, will be for LUN MSDTC

Volume3, will be for SQL Databases and logfiles

And question 2, shuld I Snapshot Quorum and MSDTC ? I guess not, and this is the case of not placing them on the same volume as the Snapped Volume3 for SQL Databases.

radek_kubka
7,481 Views

Hi,

One comment: normally you would separate SQL db & logs into separate volumes.

Regards,

Radek

PLASTIQUE
7,482 Views

Aha, why and exactly how do you mean ?

radek_kubka
7,482 Views

E.g. have a look at already mentioned TR: http://media.netapp.com/documents/tr-3941.pdf

It's about how SMSQL backup & recovery works.

PLASTIQUE
7,480 Views

When configuring SnapManager for SQL, should I install and configure this on both cluster nodes ? Anything special to consider ? Should each cluster node have it´s own SnapInfo-LUN, or should I have one and put it in the SQL Resource Group ?

thomas_glodde
5,586 Views

You must install SnapManager SQL on all nodes. Each instance should have as a minimum

DB Drive

DB Log Drive

System DB & Log Drive

Snapinfo Drive

So yes depending on your setup you might need to have more SnapInfo Disks. SM SQL can also deal with volume mountpoints if you run out of drive letters.

PLASTIQUE
5,586 Views

Thank you

I have:

Lun1: User Database and log

Lun2: System Database and log

Lun3: Temp Database and log

When configuring SMSQL, should I enter the Cluster name for SQL or each node in the initial screen

thomas_glodde
5,586 Views

You need to split Lun1

Lun1 User Database

Lun2 User Database Log

Lun3 Syste, Database and Log

Lun4 Temp Database and Log

Lun5 NetApp SMSQL SnapInfo

When configuring backup jobs enter the cluster name.

PLASTIQUE
5,587 Views

Aha

Can the Userdb and Userdblog LUN´s be on the same volume ?

abhisek
4,722 Views

Yes you can have userdb and userdblog on separate LUNs in the same volume.

Public