Not sure if you've seen this, but here's the guide I used for several Windows 
clusters on ESX 5.5 -

http://pubs.vmware.com/vsphere-55/topic/com.vmware.ICbase/PDF/vsphere-esxi-vcenter-server-55-setup-mscs.pdf




Thank you,

Brad DeHart
Kern Health Systems
Senior Network Systems Administrator
Phone: 661-664-5068
Fax: 661-664-5410
mailto:[email protected]
http://www.kernfamilyhealthcare.com



-----Original Message-----
From: [email protected] [mailto:[email protected]] On 
Behalf Of Michael Leone
Sent: Thursday, November 3, 2016 10:33 AM
To: [email protected]
Subject: Re: [NTSysADM] OT - Advice about setting up a SQL 2008 R2 cluster on 
VMware ESXi 5.5

Thanks, I have seen that. But no, it doesn't, unfortunately. Not for me, anyway.

On Thu, Nov 3, 2016 at 11:51 AM, Sean Martin <[email protected]> wrote:
> I don't have any experience setting up a SQL cluster in vSphere, but
> it appears this article may answer most of your questions:
>
> https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&;
> cmd=displayKC&externalId=1037959
>
> - Sean
>
> On Thu, Nov 3, 2016 at 5:04 AM, Michael Leone <[email protected]> wrote:
>>
>> Sorry for the OT, but I haven't received any answers on the VMware forums.
>>
>> I need to set a 2 node Win2008 R2/SQL 2008 R2 cluster on ESXi 5.5 U3b.
>> This will be only for testing; I have a production cluster on 2
>> physical nodes already, but what I need to do is test making some
>> changes to the configuration, so I thought I would test the procedure
>> on a couple VMs, rather than barrel ahead on the production
>> machine.What I need to test is first removing one of the SQL
>> instances, then removing one of the nodes completely.
>>
>> I know this cluster is supported on my ESXi; what I don't have is a
>> specific step-by-step HOWTO. My production cluster is 2 nodes SQL
>> 2008
>> R2 cluster, and it has 2 SQL instances. What I need to test is first
>> removing one of the instances, then removing one of the nodes
>> completely.
>>
>> From what I've read, this should be one of those "cluster-in-a-box"
>> configurations.
>>
>> I know I need 2 NICs, one for the heartbeat, one for the public IP of
>> the node. I'm pretty sure I know how to handle the heartbeat: a
>> virtual switch that has no physical NICs assigned to it, and have the
>> heartbeat NIC use it; that way, the only thing it can reach is only
>> on that private vswitch, i.e., the other node. I've done similar in
>> the past.
>>
>> I only need like a 2G shared disk (I'm not really going to have any
>> data on it, I just need it to exist as a cluster shared storage), but
>> I know it has to be shared between both VMs. It doesn't have to be
>> RDM, right? I can do this with a regular virtual disk? Do I need a
>> special SCSI adapter for each VM? And just tell node #2 to reuse an
>> existing virtual disk? (I've found an article that says that, but I
>> don't know if that's still required?).
>>
>> I'm searching, but getting confused at what I am finding. Anyone know
>> of a good step-by-step article to follow, along with GOTCHAs? As I
>> said, what I need to do is test the process of removing a SQL
>> instance from a SQL cluster (leaving the other, named instance alone,
>> as that's still in production), and then removing the SQL node from
>> the SQL cluster, and then removing that same node from the Windows cluster.
>> I'm pretty sure I know how to do the last 2, it's the remove an
>> instance without screwing up the remaining instance I am leery about
>> ...
>>
>>  Thanks. As I said, a bit OT, but this list seems to have people who
>> have done every sort of imaginable configuration before, so I'm
>> hoping someone has ... :-)
>>
>>
>



________________________________

Kern Health Systems Confidentiality Statement:

This email and any attachments are legally privileged and can contain business 
proprietary and/or confidential information intended for a specific individual 
and purpose. This information is intended only for the use of the individual or 
entity named above. The authorized recipient of this information is prohibited 
from disclosing this information to any other party unless required to do so by 
law or regulation and is required to destroy the information after its stated 
need has been fulfilled.

If you are not the intended recipient, you are hereby notified that any 
disclosure, copying, distribution, or action taken in reliance on the contents 
of these documents is strictly prohibited. If you have received this 
information in error, please notify the sender immediately and arrange for the 
return or destruction of these documents.

Reply via email to