+ Reply to Thread
Results 1 to 20 of 20
  1. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #1

    Default Creating a Clustered SQL Server Test Lab

    I have added the first part of this to my blog: Creating a SQL Server 2008 Failover Cluster - Part I

    The purpose of this document is to assist people who are studying for the MCITP Database Administrator 2005 or 2008 certifications in the creation of a test lab with a 2 node failover SQL Server cluster. You can run this lab setup under Hyper-V, VMware ESXi, or your favorite virtualization platform. This setup file assumes you are using Hyper-V and your shared disk provider is iSCSI Cake.

    You may wish to read these articles as well.

    You will need the following:
    · Hardware that can easily run the required virtual infrastructure. When I set this lab up, I used a quad core system with 8 GB RAM and 4 hard drives.
    · Server 2008 Enterprise or Datacenter (Download a trial here)
    · SQL Server 2005 or 2008 (2005 Trial or 2008 Trial)
    · iSCSI Cake, StarWind, or another iSCSI Target that support persistent reservations (MOST Linux systems, such as OpenFiler, do not w/o a commercial plugin)
    · An Active Directory Domain

    1. Install and update the host system.
    2. Create 2 virtual hard drives that will be used as the disks for the shared storage.
    3. Install the iSCSI target on the host system and create the two iSCSI disks. If you are using iSCSI Cake you should follow these directions.
    4. Create the two virtual machines and install and update the OSes. (I personally create and update the first then copy it and run NewSID).
    5. Create and configure a second, private network for the cluster heart beat. Ensure you can ping the guests via this network.
    6. Join the two guests to the domain.
    7. Connect to the iSCSI target using the iSCSI Initiator under Administrative Tools on the guest systems. Click on the Discovery tab and add the host OS. Go to the Targets tab and select logon.
    8. On the first guest use Disk Manager to initialize and format the two disks.
    9. Initialize the disks on the second guest.
    10. Install Microsoft’s Failover Clustering on the two guests.
    11. Create the Cluster. Do not forget to add both guests to the cluster in the wizard. Once created the disks will appear as in this image.
    12. Run the SQL Server Installation Wizard. Do not forget to select the “create a cluster” option.
    13. Run the installation wizard on the second node.


    EDIT: bertieb's guide to setting up the SQL Server portion of the cluster . Covers 2000, 2005, 2008.
    http://www.techexams.net/forums/sql-...lustering.html

    EDIT 2: SQL Server 2008 is not compatible with with Windows Server 2008 R2. You should download the latest version of SQL Server 2008 R2 if you are using Windows Server 2008 R2 or attempt to slip stream SQL Server 2008 up to SP1.
    Last edited by RobertKaucher; 02-09-2010 at 03:51 PM.
    Reply With Quote Quote  

  2. SS -->
  3. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #2
    The above is a rough draft... No images yet, I would like your thoughts, please.
    Reply With Quote Quote  

  4. Senior Member
    Join Date
    Mar 2007
    Posts
    12,308
    #3
    Nice job dude

    Thanks for sharing!
    Reply With Quote Quote  

  5. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #4
    My pleasure. Did you see any thing I forgot or that is inaccurate?
    Reply With Quote Quote  


  6. Join Date
    Jun 2007
    Posts
    1,859
    #5
    This looks good to me...it's not quite what I did, but I had the benefit of having delivered a series of classes on SQL Server 2005 last year as well as access to the MOC and associated images.

    Although the volume of people doing SQL Server work on here is low, your post might make a good sticky.
    Reply With Quote Quote  

  7. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #6
    I was working in my lab today and realized I had not configured the quorum settings... I will need to add that to the "tutorial."
    Reply With Quote Quote  

  8. wibble! bertieb's Avatar
    Join Date
    Jun 2007
    Location
    Up and down the UK
    Posts
    1,029

    Certifications
    MCSE:CP&I, SI, MCITPx2, MCSAx2, MCTSx7, VCP6/5/4/3(DCV), EMCISA, Sec+, ITILv3F, legacy MS
    #7
    Looks like a good effort there Robert

    The following links are excellent resources for anyone building a Windows 2008/SQL2008 cluster. The SQL2008 install on a cluster is quite a bit different than previous versions, these help a great deal with working out the procedure.

    Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 1
    Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 2
    Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 3
    Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 4
    Reply With Quote Quote  

  9. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #8
    I edited my original post so that it has information regarding creating the cluster with Server 2008 R2. Once I got SQL Server 2008 slipstreamed to SP1 it was a pretty easy task to install and test the SQL Cluster.
    Reply With Quote Quote  

  10. Self-Described Huguenot blargoe's Avatar
    Join Date
    Nov 2005
    Location
    NC
    Posts
    4,088

    Certifications
    VCAP5-DCA; VCP 3/4/5/6 (DCV); EMCSA:CLARiiON; Linux+; MCSE:M 2000/2003; MCSE:S 2000/2003; MCTS:Exch2007; Security+; A+; CCNA (expired)
    #9
    There were a bunch of hoops to be jumped through to get it SQL 2005 Clustering installed on Windows 2008 R2 as well, do you have that documented? I have a document I created for work around here somewhere that I could put out if you'd like.
    IT guy since 12/00

    Recent: 3/22/2017 - Passed Microsoft 70-412; 2/11/2017 - Completed VCP6-DCV (passed 2V0-621)
    Working on: MCSA 2012 upgrade from 2003 (to heck with 2008!!), more Linux, AWS Solution Architect (Associate)
    Thinking about: VCP6-CMA, MCSA 2016, Python, VCAP6-DCD (for completing VCIX)
    Reply With Quote Quote  

  11. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #10
    Please feel free to post it! That would be a great idea. I didn't include anything for SQL Server 2005 because I am working on the 2008 exams at themoment.
    Last edited by RobertKaucher; 02-09-2010 at 03:39 PM.
    Reply With Quote Quote  

  12. Self-Described Huguenot blargoe's Avatar
    Join Date
    Nov 2005
    Location
    NC
    Posts
    4,088

    Certifications
    VCAP5-DCA; VCP 3/4/5/6 (DCV); EMCSA:CLARiiON; Linux+; MCSE:M 2000/2003; MCSE:S 2000/2003; MCTS:Exch2007; Security+; A+; CCNA (expired)
    #11
    I'll see if I can find it. I've got a test cluster in vSphere and a production cluster that I'm slowly migrating toward. Both are W2008R2 with multiple SQL 2008 (SP1 slipstream) and SQL 2005 SP3 database instances.
    IT guy since 12/00

    Recent: 3/22/2017 - Passed Microsoft 70-412; 2/11/2017 - Completed VCP6-DCV (passed 2V0-621)
    Working on: MCSA 2012 upgrade from 2003 (to heck with 2008!!), more Linux, AWS Solution Architect (Associate)
    Thinking about: VCP6-CMA, MCSA 2016, Python, VCAP6-DCD (for completing VCIX)
    Reply With Quote Quote  

  13. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #12
    Did you do a burn in with SQLIO or SQLIOSim/SQLIOStress on the VM?

    I would like to know what the starts were if you did - if you happen to recall, of course. I have a warm spare server running on VMWare ESXi that was getting horrible readings from these two when I was doing the install. I figure even a slow server is better than no server in a disaaster situation, though.
    Reply With Quote Quote  

  14. Self-Described Huguenot blargoe's Avatar
    Join Date
    Nov 2005
    Location
    NC
    Posts
    4,088

    Certifications
    VCAP5-DCA; VCP 3/4/5/6 (DCV); EMCSA:CLARiiON; Linux+; MCSE:M 2000/2003; MCSE:S 2000/2003; MCTS:Exch2007; Security+; A+; CCNA (expired)
    #13
    One of the links in bertieb's post that covered 2008 covered everything for 2008 R2, as far as I can tell.
    IT guy since 12/00

    Recent: 3/22/2017 - Passed Microsoft 70-412; 2/11/2017 - Completed VCP6-DCV (passed 2V0-621)
    Working on: MCSA 2012 upgrade from 2003 (to heck with 2008!!), more Linux, AWS Solution Architect (Associate)
    Thinking about: VCP6-CMA, MCSA 2016, Python, VCAP6-DCD (for completing VCIX)
    Reply With Quote Quote  

  15. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #14
    Yes, you are correct. I believe the only issue is the slip streaming. Id on't think that was covered in his links...
    Reply With Quote Quote  

  16. Self-Described Huguenot blargoe's Avatar
    Join Date
    Nov 2005
    Location
    NC
    Posts
    4,088

    Certifications
    VCAP5-DCA; VCP 3/4/5/6 (DCV); EMCSA:CLARiiON; Linux+; MCSE:M 2000/2003; MCSE:S 2000/2003; MCTS:Exch2007; Security+; A+; CCNA (expired)
    #15
    Quote Originally Posted by RobertKaucher View Post
    Did you do a burn in with SQLIO or SQLIOSim/SQLIOStress on the VM?

    I would like to know what the starts were if you did - if you happen to recall, of course. I have a warm spare server running on VMWare ESXi that was getting horrible readings from these two when I was doing the install. I figure even a slow server is better than no server in a disaaster situation, though.
    I didn't do the burn in on the VM, as it was intended to be a lightly used test SQL cluster and none of our apps are highly transactional. Performance has been good in the test cases we've run, but I'm using RDM's mapped to our CLARiiON CX4 over Fiber rather than using a software iSCSI target so the performance should be almost as good as my production physical cluster.
    IT guy since 12/00

    Recent: 3/22/2017 - Passed Microsoft 70-412; 2/11/2017 - Completed VCP6-DCV (passed 2V0-621)
    Working on: MCSA 2012 upgrade from 2003 (to heck with 2008!!), more Linux, AWS Solution Architect (Associate)
    Thinking about: VCP6-CMA, MCSA 2016, Python, VCAP6-DCD (for completing VCIX)
    Reply With Quote Quote  

  17. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #16
    Mine just uses VHDs on the ESXi server. No iSCSI.
    Reply With Quote Quote  

  18. One Man Wolfpac NetAdmin2436's Avatar
    Join Date
    Mar 2008
    Location
    Minnesota
    Posts
    1,077

    Certifications
    AAS in Computer Networking, MCSE 2003, Network+, Security+, A+
    #17
    Thanks gents, I'm going to have to bookmark this for later...
    Reply With Quote Quote  

  19. Junior Member
    Join Date
    May 2010
    Posts
    1
    #18
    @blargoe : I should mention that you are particularly correct about performance, but you should know that all bread is not baked in one oven: StarWind is showed great results, during it's SAN software was used in test, performed by Intel. You can Check results here:
    http://download.intel.com/support/ne...teliscsiwp.pdf

    As for the topic, please check follow:
    StarWind iSCSI SAN Solution for MS SQL Server Data Sheet
    How To Set Up SQL Server 2008 Cluster
    How To Create SQL Failover Cluster

    Regards
    Reply With Quote Quote  

  20. Member GagHalfrunt's Avatar
    Join Date
    Nov 2006
    Location
    Nr. Stratford-Upon-Avon, UK
    Posts
    81

    Certifications
    Win2008 EA & SA, SQL2008 MCITP, Win7 MCTS, CCA
    #19
    I did this with Hyper-V, 3 VMs with Starwind on the third. Perfectly good for playing with SQL clustering but I wouldn't do it that way on a "real" server. Good for practising mind.

    If I were I'd probably cluster at the VM level instead if it were me.
    Reply With Quote Quote  

  21. Senior Member
    Join Date
    Apr 2006
    Posts
    251

    Certifications
    Security+, CCNA, MCSE 2003: Security
    #20
    Great job! Thanks Robert!
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks