Announcement

Collapse
No announcement yet.

SQL cluster

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL cluster

    I would like to know how SQL cluster build.

    Planning to use 2 2008 r2 servers with shared iSCSI storage.

    The servers will be used for Voice recognition system so physical phone cards will be installed.

    Please breifly describe server and storage config.
    ex. OS on servers and DB on shared storage?
    or any links

    THX
    Last edited by mla; 21st May 2011, 22:32.
    "When you hit a wrong note it's the next note that makes it good or bad". Miles Davis

  • #2
    Re: SQL cluster

    Anything helpful on ?
    http://www.google.co.uk/search?hl=en...meta=&aq=f&oq=
    You will need to do a lot of research, especially as you are linking it with your phone system -- although why does that have to be on the dB server?

    Note if it is purely a SQL server, then a virtual machine on a physical cluster may be an alternative way forward
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment


    • #3
      Re: SQL cluster

      Ossian,
      I read yesterday about SQL clustering... yes it is pretty complex - first Windows cluster should be build and then SQL cluster on top of it.
      Last night (kind of in the dream ) I came to conclusion that SQL cluster is really unnecessary...
      It was just a requirement of one important guy. And he insisted it shoud be like that. I created a new design for this system and can prove that SQL cluster is really not necessary. Beside two servers with phone cards the system will include 2 hypervised hosts (in cluster) with 4 VMs. One of them will be SQL server that will serve other 3 VMs. So the solution is right here... I can use the same SQL for boxes with phone cards. It's just misleading requirement and approach. But I have to prove that.

      Thanks for the input...
      Michael.
      Last edited by mla; 21st May 2011, 22:34.
      "When you hit a wrong note it's the next note that makes it good or bad". Miles Davis

      Comment


      • #4
        Re: SQL cluster

        wait.. so you're using two physical hosts, with the phone cards installed.

        then you plan to install several virtual guests on top of those hosts, and use these guests for your phone system.

        This begs te question:

        How will your virtual guests identify and use the hardware in the physical machine ?
        Please do show your appreciation to those who assist you by leaving Rep Point https://www.petri.com/forums/core/im.../icon_beer.gif

        Comment


        • #5
          Re: SQL cluster

          tehcamel,
          I guess you missed the line in the post:
          "Beside two servers with phone cards the system will include 2 hypervised hosts (in cluster) with 4 VMs".
          "When you hit a wrong note it's the next note that makes it good or bad". Miles Davis

          Comment


          • #6
            Re: SQL cluster

            my bad, sorry mate
            Please do show your appreciation to those who assist you by leaving Rep Point https://www.petri.com/forums/core/im.../icon_beer.gif

            Comment


            • #7
              Re: SQL cluster

              Here are some excellent videos from a clustering guy at MS I recorded for my site.

              http://midnightdba.itbookworm.com/Vi...lustering.aspx

              http://midnightdba.itbookworm.com/Vi...ustering2.aspx

              http://midnightdba.itbookworm.com/Vi...ustering3.aspx
              Sean McCown, SQL Server MVP

              See my FREE SQL Server training videos at:
              http://www.MidnightDBA.com

              Blog Author of:
              Database Underground -- http://infoworld.com/blogs/sean-mccown
              DBA Rant http://dbarant.blogspot.com

              Comment

              Working...
              X