Post reply

Creating a 2 Node SQL Server 2008 Virtual Cluster Part 1

  • July 10, 2011 at 11:59 pm

    #243869

    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" 😉

  • July 11, 2011 at 3:09 am

    #1350945

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

    M&M

  • July 11, 2011 at 3:18 am

    #1350954

    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" 😉

  • July 11, 2011 at 9:09 am

    #1351150

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

    Paul

  • July 11, 2011 at 9:31 am

    #1351165

    Great Article Perry,

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

    Thanks,

    Gary

  • July 11, 2011 at 11:03 am

    #1351221

    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.

  • July 11, 2011 at 12:58 pm

    #1351287

    parts 2 and 3 follow shortly 😉

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

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

  • July 11, 2011 at 3:11 pm

    #1351346

    Good work, Perry:-)

  • July 11, 2011 at 3:26 pm

    #1351351

    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" 😉

  • July 11, 2011 at 7:09 pm

    #1351392

    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

  • July 12, 2011 at 12:39 pm

    #1351812

    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]

    MCITP, Database Administrator
    A hodgepodge of Information Technology and Life
    LinkedIn Profile
    My Twitter

  • July 12, 2011 at 1:27 pm

    #1351840

    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" 😉

  • July 12, 2011 at 1:59 pm

    #1351864

    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?

  • July 12, 2011 at 2:24 pm

    #1351881

    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" 😉

  • July 12, 2011 at 2:38 pm

    #1351889

    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 55 total)

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