How to create a SQL 2012 Failover cluster using VMs?

  • APA0876

    Hall of Fame

    Points: 3853

    Hi thanks before everything!, I have the following question that I hope you can oriented me:

    How to create a SQL 2012 Failover cluster using VMs?

    Thanks

    APA

  • @SQLFRNDZ

    SSCrazy Eights

    Points: 9095

    If you are trying to achieve HA then make sure your 2 VMs are from different hosts. then configuring will be almost same as you configure the physical clustering.

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

  • free_mascot

    One Orange Chip

    Points: 27168

    You can create the ISCSI drive on VM which shares the drive similar to SAN and proceed further. Also you can create two identical hardware for cluster and try always on.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • jasona.work

    SSC-Forever

    Points: 49954

    My question would be, what is this for? Is this for a learning sandbox so you can get a feel for / practice setting up a fail-over cluster, or is this a QA environment at your workplace, or is this for a production system?

    Each of those three will have a different answer, and more questions...

    If it's just a learning / practice sandbox, then it depends on the hardware you have available...

    It's possible to do this entirely within the hypervisor, if you have access to the right OS. Three VMs, two for SQL, one to function as an iSCSI Target for the shared storage. Or, if you have an external NAS device which supports iSCSI, you could do it with 2 VMs.

    If this is for a work environment, now you need to find out what hardware is available, what sort of SLA are you looking at, etc.

    Details matter...

    The more details you provide, the more someone can help you.

    One of my nieces requires a powerchair to get around and is trying to raise the funds to buy one:
    https://www.gofundme.com/f/get-breezy-a-new-wheelchair?utm_source=customer&utm_medium=copy_link-tip&utm_campaign=p_cp+share-sheet

  • Perry Whittle

    SSC Guru

    Points: 233804

    APA0876 (5/5/2014)


    Hi thanks before everything!, I have the following question that I hope you can oriented me:

    How to create a SQL 2012 Failover cluster using VMs?

    Thanks

    APA

    Check my guide on this site at the following links

    Part1[/url]

    Part2[/url]

    Part3[/url]

    -----------------------------------------------------------------------------------------------------------

    [font="Tahoma"]"Ya can't make an omelette without breaking just a few eggs"[/font] 😉

  • APA0876

    Hall of Fame

    Points: 3853

    Hi yes I agree,

    This is going to be a production cluster, this company bought a software and the vendor is recommending to create a Virtual SQL Cluster, on Production .

    what is the difference on the creation of a SQL cluster on sql server 2008 R2 and SQL Server 2012?

    Thanks

  • Perry Whittle

    SSC Guru

    Points: 233804

    APA0876 (5/6/2014)


    what is the difference on the creation of a SQL cluster on sql server 2008 R2 and SQL Server 2012?

    Thanks

    The installer is pretty much the same with some slight differences for sql 2012, they both use a Windows Server Failover Cluster, so essentially no difference.

    Have you checked my links for more detail?

    -----------------------------------------------------------------------------------------------------------

    [font="Tahoma"]"Ya can't make an omelette without breaking just a few eggs"[/font] 😉

  • APA0876

    Hall of Fame

    Points: 3853

    Yes I'm reviewing them

    Thanks

  • Perry Whittle

    SSC Guru

    Points: 233804

    APA0876 (5/6/2014)


    Yes I'm reviewing them

    Thanks

    OK, well if you're putting this into production ensure the hosts are well specced.

    -----------------------------------------------------------------------------------------------------------

    [font="Tahoma"]"Ya can't make an omelette without breaking just a few eggs"[/font] 😉

  • humbleDBA

    Hall of Fame

    Points: 3440

    Perry Whittle (5/6/2014)


    Check my guide on this site at the following links

    Part1[/url]

    Part2[/url]

    Part3[/url]

    Wow :w00t: ...missed this set of guides. At first glance, looks great - and I've used Starwind's free iSCSI SAN for a number of years now for development and testing, so good stuff.

    Nice job Perry. 🙂

  • Perry Whittle

    SSC Guru

    Points: 233804

    Keep an eye out for part 4 later this month , you'll love it.

    Please don't forget to rate the articles if you found them useful

    -----------------------------------------------------------------------------------------------------------

    [font="Tahoma"]"Ya can't make an omelette without breaking just a few eggs"[/font] 😉

Viewing 11 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply