Can I use virtual machines to test windows cluster failover and migration?

Hello,
I was wondering if it is possible to use virtual machines for testing windows cluster - breaking and moving into another domain.
So, in our production we have a phisical cluster with two nodes. The goal is to break the cluster and to migrate them into another domain.

So, I have a checklist and would like it to test the procedure in the test lab first. Please let me know if I could use VMware machines for that.
If not, could you please let me know the hardware requirements I would need for the test lab.


Thank you so much
creative555Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

creative555Author Commented:
Below is additional info for the OS for our existing servers. So, I want to setup a test lab so that I could get similar results as I would be migrating production servers. Please let me know what would I need for the test lab and if I could use for virtual machines or I need to use only physical servers, etc?

Server01      Microsoft(R) Windows(R) Server 2003, Enterprise Edition Enterprise Edition. (SQL 2005)
Server02       Microsoft(R) Windows(R) Server 2003, Enterprise Edition Enterprise Edition. (SQL 2005)
Server03       Microsoft Windows Server 2008 R2 Enterprise R2 Enterprise. (SQL 2012)
Server04       Microsoft Windows Server 2008 R2 Enterprise R2 Enterprise. (SQL 2012)
0
Sajid Shaik MSr. System AdminCommented:
you can do it excellently over windows 2012 R2

fully supports vm migration..
create a machine as storage server ... create 2 volumes on it..one for 1 gb (quorum disk) one drive for Database storage ( 20 gb) depens up on requirements.
following is the best article
http://www.windowsnetworking.com/articles-tutorials/windows-server-2012/first-look-windows-server-2012-r2-storage-part1.html

then create 2 virtual machines   mount both drives with Iscsi connector.

now create the cluster following the article

http://www.pythian.com/blog/how-to-install-a-clustered-sql-server-2012-instance-step-by-step-part-1/

all the best
0
pjamCommented:
In the Microsoft class 20412d, in Module 11 we definitely used Hyper-V to set up and test failover cluster.  So should be no problem for you.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Yes, you can do everything in a virtual machine, which you can do in a physical server.

See Failover Clustering Guides here

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ryan McCauleyData and Analytics ManagerCommented:
You can for sure cluster virtual machines - though I haven't had great experience doing it in production (we tend to have failovers more often that we should as a result of latency), it possible and easy to do in your testlab. My favorite cluster walkthrough uses VMs and even shows you how to set up virtual shared storage:

https://dbperf.wordpress.com/2010/07/10/walkthrough-cluster-setup-sql-win-2008/

 It's a walkthrough for clustering SQL Server, so ignore the second half if you don't want to do that (though it seems you do), and you can just focus on the Windows portion.
0
creative555Author Commented:
Oh. Thank you so much!! Thats great news!!! So we need to request four VMs for two clusters? Is there anything esle we need other than four VMs?

Current environment:
One cluster
Server01      Microsoft(R) Windows(R) Server 2003, Enterprise Edition Enterprise Edition. (SQL 2005)
Server02       Microsoft(R) Windows(R) Server 2003, Enterprise Edition Enterprise Edition. (SQL 2005)


SEcond Cluster
Server03       Microsoft Windows Server 2008 R2 Enterprise R2 Enterprise. (SQL 2012)
Server04       Microsoft Windows Server 2008 R2 Enterprise R2 Enterprise. (SQL 2012)
0
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Yes, Raw Device Mapped LUNs for Clustering!

e.g. shared storage, unless you do Cluster in a box, see the Guide I posted!
0
creative555Author Commented:
Hi,
THank you so much again.
SO we have two options - VMs or Hyper- V lab

I see that we can test any version of SQL clustering in VMware, how about Hyper-V?

In the link I see testing for Windows 2012 and SQL 2012 versions.

We need to test Windows Server 2003 cluster with SQL 2005. Can we also do it in Hyper-V too 2012?

One cluster
 Server01      Microsoft(R) Windows(R) Server 2003, Enterprise Edition Enterprise Edition. (SQL 2005)
 Server02       Microsoft(R) Windows(R) Server 2003, Enterprise Edition Enterprise Edition. (SQL 2005)


 SEcond Cluster
 Server03       Microsoft Windows Server 2008 R2 Enterprise R2 Enterprise. (SQL 2012)
 Server04       Microsoft Windows Server 2008 R2 Enterprise R2 Enterprise. (SQL 2012)
0
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
VMware vSphere or Microsoft Hyper-V, either will do.
0
creative555Author Commented:
Thank you ALL for such great responses!!! All answers were great.
0
Philip ElderTechnical Architect - HA/Compute/StorageCommented:
If you need to simulate a WAN link between the clusters this tool is the best: WANem: The Wide Area Network emulator.
1
creative555Author Commented:
Thank you very much!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2012

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.