2012-05-14 02:32 AM
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
iSCSI initiator ( well it´s on the control panel )
NetApp Host Configuration Utility
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
2012-05-15 07:33 AM
Hi and welcome to the Community!
- 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?
2012-05-15 08:17 AM
So this is a very tricky subject then.
For a starter, 'proper' iSCSI (via VMware stack) is not supported for Microsoft clusters:
VMware is hinting a workaround in vSphere 5 by using software iSCSI initiator inside a guest:
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.
2012-05-15 08:48 AM
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):
but I don't think any of them will match your exact requirement.
2012-05-18 08:26 AM
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 ?