SQL Server TechCenter >
SQL Server Forums
>
SQL Server Disaster Recovery and Availability
>
SQL High Availablity Options
SQL High Availablity Options
We currently have the SQL 2005 on Win2k3 setup with the MSCS and SQL clustering within a datacenter.
And between the active-passive datacenter we are using the log shipping to replicate the data.
However, I would like to know if there's any available/proven options create a better HA environment (for both inter and intra). One of our major concern is that when we apply the SQL patches/hotfixes, there is a risk of brining down the entire cluster. Also, whenever we failover to the passive datacenter it takes about 20mins outage.:- SQL Clustering - with SQL 2008 on Win2k8 what kind of advantages you are getting over SQL 2005/Win2k3 (or even SQL 2008 and Win2k3)? - for example, when you apply the SLQ patches in a cluster environment, doe is create a lesser down time?
- SQL Replication - can any SQL replications such as peer-to-peer replication or mirroring improve the situation?
- 3rd party replication/clustering - can any non-MS solutions help us to create the SQL HA environment (I have used the Veritas Cluster for my previous projects and had some advantages)
Thank you.
All Replies
- Hi JK
See the following links:
Win2008/SQL2008 clustering benefits
http://sqlcat.com/top10lists/archive/2008/11/20/six-failover-clustering-benefits-realized-from-migrating-to-sql-server-2008.aspx
HA in SQL2008, by Paul Randal
http://msdn.microsoft.com/en-us/library/ee523927.aspx
Mirroring and Replication
http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/ReplicationAndDBM.docx
HTH
Ewan
If you have found this post helpful, please click the 'Vote as Helpful' link (the green triangle and number on the top-left).
If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution. - My company, SteelEye Technology, has a few offerings that may be of interest. One is SteelEye DataKeeper Cluster Edition, which is basically a replication engine that allows you to extend your MSCS or WSFC cluster across data centers. The other option is the SteelEye Protection Suite for SQL, which is a cluster alternative that also includes replication and rewind functionality. If you are interested in learning more, you can request some information at http://www.steeleye.com/getinfo/
Here is a blog post that describes in detail how to implement a WSFC multi-site SQL 2008 cluster.
David A. Bermingham, Director of Product Management, SteelEye Technology - Hi,
I guess you should use DB Mirroring instead of Log Shipping.
Answer to your Q1 is - No, it won't.
Q2. Peer-to-Peer replication is for load balancing, it depends that what server you are patching and what tables are there which are write enable.
Q3. If I remember, Red-Gate has some software to create LS/Mirroring/
Hemantgiri S. Goswami | http://www.sql-server-citation.com/ | http://www.surat-user-group.org/ -- Surat SQL Server User Group
