Microsoft Virtualization Discussions

NetApp + Microsoft Cluster + SQL Cluster - HowTO

PLASTIQUE

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

A hard nut to crack ?

radek_kubka

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

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

SMSQL 5.0R1

SnapDrive 6.3.1R1

radek_kubka

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

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

radek_kubka

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

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

Regards,

Abhishek

PLASTIQUE

So you think that it should work?

PLASTIQUE

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

SQL binaries should be on VMDK file in my view.

PLASTIQUE

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

Hi,

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

Regards,

Radek

PLASTIQUE

Aha, why and exactly how do you mean ?

radek_kubka

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

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

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

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

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

Aha

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

abhisek

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

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public