SQL Server Performance

SQL Clustering across 2 Data Centres

Discussion in 'SQL Server Clustering' started by martith, Jan 18, 2005.

  1. martith New Member

    Hi,

    I am looking at the feasability of clustering SQL Server 2000 across a WAN between 2 remote dada centres. We would be looking at using Windows 2003 Server and SQL server 2000.

    Firstly, is this achievable? Are there any caveats, especially around the use of SAN/NAS technology?

    Thanks,



    Martin Thompson
    Technical Architect
  2. bradmcgehee New Member

    Be default, in SQL Server clustering, there are two or more nodes, and a single shared array. With this in mind, do you want to have a node and one shared array on one location, and then the other node (with no shared cluster) in the other location? Probably not. The ideal solution would be to have nodes and shared arrays in both locations. In SQL Server 2000, this is not yet feasible, but SQL Server 2005 will offer this. In that case, you will need to wait until late this year for it.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  3. martith New Member

    Thanks Brad, I'l bear these points in mind. I think the SQL 2005 option will be what we will have to look at.

    Many Thanks

    Martin Thompson
    Technical Architect
  4. RickBrunner New Member

    Martin,
    Until recently I would have given you the same response that Brad has given you, however there is a Microsoft Certified solution that Unisys is introducing this QTR to allow customers to utilize MSCS to cluster across datacenters in a geographically dispersed environment. It is the only certified long distance cluster solution at this time. It can be used to create intercontinental clusters if needed. In addition this solution will give customers the ability to do point in time (roll back) recovery to resolve issues of data corruption. If you are interested in investigating let me know and I can facilitate

    -rick
    Rick Brunner
    MCSE, MCSA, MCP+I,CCA, CTE
    Project Manager

Share This Page