Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sohrab
Starting Member
3 Posts |
 Posted - 2006-02-14 : 16:14:15
|
My company is in the market to implement a High Availability Clustering (Replication) system for our MSSQL servers. The failover server must be remote. I have no problem recommending the reliable underdogs to my boss. I appreciate any comments or ideas. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-14 : 16:34:17
|
| If you are going to cluster over a WAN, it will be very, very expensive. You'll need to implement some sort of mirroring at the SAN level, whether it be softare or hardware mirroring. Here is our production setup:Active/Active/Active 3 node cluster in San DiegoDuplicate system in Las Vegas for disastery recoveryRedundant everythingWhoever your hardware vendor is, I'd have them propose a highly available solution. Have another vendor do the same to compare the costs and systems.Tara Kizeraka tduggan |
 |
|
|
bakerjon
Posting Yak Master
145 Posts |
Posted - 2006-02-14 : 17:18:22
|
| It is possible to do a geographically dispersed cluster with SAN mirroring (SRDF in EMC terms), but Tara is right, it's pricey. We looked at this a few years back, but did not implement it. I've heard some people have had some luck with SCSI over IP in Cisco switches, but I don't have experience with it.You could implement a local cluster with log shipping or database mirroring (2005) to another location. This would give you seemless redundancy for local hardware and OS related failures and an inexpensive solution off-site for larger disasters. You'd have to rename the server or re-point apps in the event you have to move to the warm-standby server, but it's not as expensive. Good luck.JonWhen your forehead becomes flat, find another wall to hit it against.http://www.sqljunkies.com/weblog/outerjoin |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-14 : 17:21:32
|
| Speaking of log shipping...I forgot to mention we log ship between San Diego and Las Vegas.Tara Kizeraka tduggan |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-02-14 : 19:06:18
|
| My experience here (specifically on sqlteam) has been that this kind of question comes up every so often. The "I want to implement a 5 nines solution..." is another good one along the same lines. Usually the person asking the question has no idea of what it all may cost, and once the costs of these solutions becomes clear, we never hear from them again.So, what kind of budget are you working with?-ec |
|
|
|
sohrab
Starting Member
3 Posts |
Posted - 2006-02-15 : 09:55:59
|
| Thanks Tara.Knowledgeable YAK, your answer is mucho grande! We already pay to Symantech and very dissatisfied! We are on 2000, and I am investigating advantages of 2005. I will find the solution and will post that too.Thanks everyone for the comments. |
|
|
|
|
|
|
|
|
High Availability Clustering