SaffronThePuppy
asked on
2-node HA MS SQL on Hyper-V without shared storage (SAN)
I have 2 pizza boxes, each with 2 nics and have a mind to run Hyper-V on each one in order to set up a Windows and SQL Cluster for HA.
I have no shared SAN available. I understand that Windows 2012 / SQL 2012 can do this?
Can anyone describe the shared components or link me to some procedures/recipes online please?
I only need 1 DB synced between the pair.
Config is:
2x Hyper-V Hosts with local disk and heartbeat crossover cable and seperate 1Gb link to LAN.
1x Windows VM with 1x SQL instance per Host.
Much appreciated!
Kevin
I have no shared SAN available. I understand that Windows 2012 / SQL 2012 can do this?
Can anyone describe the shared components or link me to some procedures/recipes online please?
I only need 1 DB synced between the pair.
Config is:
2x Hyper-V Hosts with local disk and heartbeat crossover cable and seperate 1Gb link to LAN.
1x Windows VM with 1x SQL instance per Host.
Much appreciated!
Kevin
ste5an
Why not building a Windows cluster and running SQL Server as cluster? I don't see the advantage in using Hyper-V here.
ASKER
I am also running a Domain Controller VM and possibly another service on one of the nodes, or both. So there may be 3 or more VM's. This question is specifically "How to I get around using a CSV to do Hyper-V Clustering? Can it be done with local disk somehow. What about the Quorum? Can all this be done with on-board DAS? I can't use iSCSI or SMB or FC storage.
More simply put: How can I setup Windows 2012 Hyper-V Clustering with 2 physical boxes and no external storage?
More simply put: How can I setup Windows 2012 Hyper-V Clustering with 2 physical boxes and no external storage?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This confirms. Thank you.