Creating a 2 Node SQL Server 2008 Virtual Cluster Part 1

  • Comments posted to this topic are about the item Creating a 2 Node SQL Server 2008 Virtual Cluster Part 1

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

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

  • Thanks Perry, I am going to try this one. I also have your PDF document which you had shared with me before.

    M&M

  • Hi Mohammed

    no problem, if you hit any problems feel free to post back here and ask (or create a new thread in the forum).

    This is actually a 3 part guide, i'll have to contact Steve Jones and ask him to edit that for me

    🙁

    Regards

    Perry

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

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

  • Ive just started writing an article exactly on this very same subject! You seem to have beat me to it. Good work.

    Paul

  • Great Article Perry,

    Is it possible to achieve the same result using ORacle VM VirtuaBox instead of VM ware?

    Thanks,

    Gary

  • Wow... popular topic... I had actually just written similar procedures to test and then publish 🙂

    Yes you can do similar using HyperV, VirtualBox and VMWare ESX and Workstation.

  • parts 2 and 3 follow shortly 😉

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

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

  • Good work, Perry:-)

  • gary.strange-sqlconsumer (7/11/2011)


    Great Article Perry,

    Is it possible to achieve the same result using ORacle VM VirtuaBox instead of VM ware?

    Thanks,

    Gary

    Never used Oracle virtual box so i wouldnt know unfortunately. I do have an ESX4i system running a 2 node windows 2008 cluster, a 2 node windows 2003 cluster and a 2 node Veritas Cluster Services cluster. ESX offers better manageability and performance than VMWare server 2.0, but then there is a vast difference between the platforms. You could use Hyper-V but i personally prefer VMWare

    Parts 2 and 3 get down to the nitty gritty.

    Part 2 covers creating the VMs and attaching the LUNs over iSCSI to the new Windows 2008 VMs with a nice little section on manually partition aligning a new drive

    Part 3 covers creating the cluster and installing SQL Server

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

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

  • Simply brilliant!

    Thank you for sharing such a great article.

    Looking forward to the other parts.

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • Looks interesting and I'll probably walk through it first chance I get.

    Check the link for the FreeNAS download:

    http://sourceforge.net/projects/freenas/files/FreeNAS-8/[/url]

  • thats the latest version which i'm not using in the tutorial and there is a vast difference. try this link for v7 stable release

    http://sourceforge.net/projects/freenas/files/FreeNAS-7-Stable/[/url]

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

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

  • Why would you want to do this? What does this achieve? I feel like the article takes for granted that we already know what MS Cluster services is used for.

    Any comparison to db replication or other SQL server scale-out technologies?

  • tobyteel (7/12/2011)


    Why would you want to do this? What does this achieve?

    I thought that was clear from the introduction, thanks for your feedback

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

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

  • tobyteel (7/12/2011)


    Why would you want to do this? What does this achieve?

    The reason why you would want to do this, is that basically every business using SQL seriously does exactly this - we have several active/active active/passive clusters - some on hardware, some failing over to VM's, some SQL boxes soley on VM. Having a copy of your work environment at home to work on, try out stuff and basically learn keeps you at the top of your game. Buying Technet, WMWare workstation, a decent i7 machine and a large external drive will cost you loads less than a training course and you will learn so much more. Im currently working working towards my MCITP 2011 for when it finally comes out. And I did exactly the same for when the 2008 exams came out - which I got within a few weeks of the exams becoming available.

    Again nice article Perry. Maybe when Ive nocked mine up you could give it a once over?

    Cheers

    P

Viewing 15 posts - 1 through 15 (of 56 total)

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