Announcement

Collapse
No announcement yet.

SQL clustering

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

  • SQL clustering

    Is SQL clustering possible with 2 SAN clusters? Can you setup a cluster over a WAN to achieve a DR solution?

  • #2
    Re: SQL clustering

    AFAIK clustering is 2 hosts connected to 1 SAN -- not 2 SANs

    There is log shipping which give a copy dB at another site for DR purposes
    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 clustering

      does log shipping give you automatic failover? i didnt think it did. How are people creating automatic failover solutions for DR when equipment is in tow separate locations?

      Comment


      • #4
        Re: SQL clustering

        No, I don't think so either...
        I checked MS and SQL 2008 does offer geographical clustering:
        http://www.microsoft.com/sqlserver/2...ilability.aspx
        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


        • #5
          Re: SQL clustering

          Now thats interesting. Although Windows/SQL support Geographically Dispersed Failover Clustering it will not span different subnets. You need to cluster in the same LAN or VLAN. This solution also requires SAN replication, which is fine, but the subnet thing kills me, what company will have a DR site on the same subnet.

          Comment


          • #6
            Re: SQL clustering

            Originally posted by Stevenjwilliams83 View Post
            what company will have a DR site on the same subnet.
            Ours does, dark fiber between the sites. If our primary datacenter goes boom, we just have to flip the cluster HBAs at the DR site to a replicated secondary SAN and were back up and running.

            That said, a new feature of Windows Server 2008 Failover Clustering is support for cluster nodes on different subnets.

            From http://technet.microsoft.com/en-us/l...25(WS.10).aspx

            "Place clustered servers on different subnets: You can now place clustered servers on different IP subnets, which reduces the requirements for geographically dispersed clusters."

            Comment

            Working...
            X