Setting up a SQL cluster under MS VS2005 R2 Part2

  • Perry Whittle

    SSC Guru

    Points: 233859

    Comments posted to this topic are about the item Setting up a SQL cluster under MS VS2005 R2 Part2

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • alen teplitsky

    SSC-Dedicated

    Points: 30014

    not that i'll ever run SQL under VS 2005 in production, but isn't one of the benefits of virtualization that you don't need to set up MS clusters? the servers that host your virtual environment should be clustered so there is no reason to set up VM's that are clusters

  • Perry Whittle

    SSC Guru

    Points: 233859

    thanks for your reply. The document does specify you should only use for test\educational purposes and that options such as VMWare HA make this redundant. Its more for people who want to learn or test, you cant generally play around with live clusters 😉

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • lfguzman_25

    SSC Veteran

    Points: 251

    Hi this are good instructions to make a windows clustering. I already made a cluster in Virtual Server 2005 with 3 nodes, and my configuration are 2 active nodes and one passive node. I can mount the volumes so i can have more scsi disks to implement clustering.

    This procedure can not be done in Production environment. Has to be for development.

    Greetings and good post.

    😉

  • alen teplitsky

    SSC-Dedicated

    Points: 30014

    is there any benefit to setting up a dev/qa cluster? we have clustered SQL servers but our dev and qa are on standalone sql servers and we have never had a problem

  • mojo-168709

    SSCommitted

    Points: 1825

    SQL Noob (5/15/2009)


    is there any benefit to setting up a dev/qa cluster?

    The benefits are plenty. We use QA SQL cluster to test service pack installs; we also test the effect of failover to the applications so that the app developers would retry the connection when the failover occurs, instead of generating nasty app errors to the users.

  • noeld

    SSC Guru

    Points: 96590

    SQL Noob (5/15/2009)


    is there any benefit to setting up a dev/qa cluster? we have clustered SQL servers but our dev and qa are on standalone sql servers and we have never had a problem

    In addition there are components like replication, logshipping and mirroring that you may want to test while you combine multiple technologies and this not only applies to clustering but to any thing you want to test that could be possibly difficult to emulate on a real system.

    "VM" should, In my opinion be the King of QA and DEV


    * Noel

  • Perry Whittle

    SSC Guru

    Points: 233859

    SQL Noob (5/15/2009)


    is there any benefit to setting up a dev/qa cluster?

    as i said above, you can play to your hearts content without fear of retribution. Mojo pointed out the most obvious use. As VM's you can snapshot then install SP's or hotfixes, etc. As VM's you can revert back to the snapshot (you have to take copies of the virtual clustered disks too where the databases reside).

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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