SQL 2008 Failover Cluster on Hyper-V Cluster -
09-22-2008
, 05:42 PM
Hi all! I am designing a virtualized "Always On" solution for a client using
SQL2k8 (Edition TBD) + Win2k8 Hyper-V.
I will have 8 boxes conforming a Windows 2008 Cluster where my VMs will be
hosted as a High Available service featuring Quick Migration. Now I need to
know how to provide HA to my virtulized SQL Server Service.
Is there any recommended reading regarding this? I have read many about SQL
virtualization but nothing about a HA environment.
My approach would be:
- Create 2 SQL VMs (SQL1, SQL2) hosted on different boxes (Host1, Host2).
- Host1 and Host2 are members of my Win2k8 Cluster
- Create a Fail-over cluster between SQL1 (active node) and SQL2.
Disaster
- SQL1 fails -> SQL Fail-over cluster moves control to the passive node
until recovery.
- Host1 fails -> Win2k8 Fail-over starts the VM on a Host3 and while Quick
migration takes place SQL Fail-over cluster moves control to the passive
node
How does it sound?
Any guidance will be appreciated,
Thanks a lot,
Beto. |