Jun 24

How to create RDM mappings for SQL Clustering with MSCS on VMware 6.0

How to create RDM mappings for SQL Clustering with MSCS on VMware 6.0

Using vSphere 6.0

For the sake of this discussion, we’re building two VMs for use in a two node failover MSCS cluster for SQL 2012.  We’ll simply call them A and B.

We will be using the Web Client for this, since that’s the direction VMware is pushing. However, the Fat (C#) client is faster for this task as it takes fewer steps.  For example, on the fat client, when you create the first RDM mapping, it will automatically create a new, second SCSI controller. When on the web client, you have to manually create the SCSI controller first, then start building the RDM drives.

The documentation in the 6.0 documents is very sparse, and I don’t think it’s even complete or accurate so this took a bit of effort to figure out and get set up.

Add a new SCSI Controller (we had issues with other “types” and use VMware Paravirtual exclusively now)
mscs2mscs1

Add a new disk;
mscs3Select the target LUN by LUN ID;
mscs4

Choose your new SCSI controller 1 (not like picture) and pick an unused SCSI ID.
mscs5

 

This shows the proper SCSI controller and ID selection.
mscs6

After creating this, go to the Windows OS on A, bring disk online, initialize, format, name, label, etc.

Now go to server Node B and add a RDM pointing to that exact same file.
mscs7

You told it to store the VMDK pointer “with the server” so go to that datastore and fine the VMDK that was created by the new drive creation on A. When you create this drive in VMware on B, then you can go into the OS on the B node and the drive should show up there labeled and formatted and drive lettered.

If you keep track of it as you go, you can add several drives at once on A (2,3,4,5,6,7…) and it will create them all at once, then go over to B and add/create them all at once. But you have to keep your VMDK names and LUN IDs straight so you know which one is which. Doing one at a time is slower but less confusing.

 

How to tell (after it’s created) which VMDK file a new RDM is using on A, so you can find the correct VMDK when you create B;

Go to “Edit Settings” then at the top there is a “Manage other disks”
mscs8

Open that button, then drop down the details on the disk you’re looking at and it will show you the VMDK and datastore. This VMDK is just a “pointer” or “mapping” file to the LUN.
mscs9

mscs10

mscs11

Pick the SAME SCSI controller and port that you did on A;
mscs6
ISSUES ENCOUNTERED;

Set LUNS as “perennially reserved”.  If this is not set right, the ESX HOST will take HOURS to boot, depending on how many RDMs it has to scan. Ours took 2.75 to boot. When this was set right via esxcli, they would boot in about 6 minutes, counting the HP specific boot processes. This is addressed in this KB, scroll down to the “perennially reserved” section. ESXi/ESX hosts with visibility to RDM LUNs being used by MSCS nodes with RDMs may take a long time to start or during LUN rescan (1016106)

 

EXPANDING RDM sizes. 

PARAVIRTUAL driver

Jun 05

Links from HP Discover 2015

Water cooled server racks; APOLLO; http://www8.hp.com/us/en/products/servers/high-performance-computing/apollo/apollo8000-product-portfolio.html

Video explanation of the APOLLO water cooled system; this is the Peregrine system they talked about that is being used to heat the sidewalks with excess heat from the datacenter; https://youtu.be/9Ih3R84Corg

The MACHINE; the HP Labs folks running this section were real genius types;  http://www.hpl.hp.com/research/systems-research/themachine/

MEMRISTOR; http://www8.hp.com/hpnext/tags/memristor#.VXGmJc9VhBc

StoreVirtual VSA; virtual array storage and servers in single appliance; http://www8.hp.com/us/en/products/data-storage/storevirtual-vsa.html

VPV; http://www8.hp.com/us/en/software-solutions/vpv-server-virtualization-management/

SiteScope; http://www8.hp.com/us/en/software-solutions/sitescope-application-monitoring/

Operations Manager; http://www8.hp.com/us/en/software-solutions/operations-manager-infrastructure-monitoring/

 

HP Moonshot; lots of buzz, very flexible, and very dense; http://www8.hp.com/us/en/products/servers/moonshot/#products

HP Vertica; SQL on Hadoop; http://www.vertica.com/hp-vertica-products/sqlonhadoop/

Hadoop with Cloudera or Hortonworks; http://www8.hp.com/us/en/products/servers/high-performance-computing/hadoop.html

Helion; huge buzz about Helion the Cloud Infrastructure / Openstack offering; http://www8.hp.com/us/en/cloud/hphelion-openstack-overview.htmlhttps://docs.hpcloud.com/helion/openstack/1.1/. Supports Chef, Puppet, etc., etc., etc.

Internet Giants; this was running, just kind of interesting; http://pennystocks.la/battle-of-internet-giants/