up vote 2 down vote favorite
3
share [g+] share [fb]

I currently have an ASP.NET web app running on a cluster in a data center talking to a SQL Server DB. I need to make this setup redundant with a hot-hot DB in another data center as well as a replicated web cluster.

What architectural options are available to setup this type of fail-over?

link|improve this question
56% accept rate
feedback

4 Answers

up vote 3 down vote

Sure, gotcha, I apologize, i'm a bit new here, this is an awesome site!

For the proposed solution I would recommend 3 tiers of redundancy in a multi-threaded setup.

Database- Continue to use SQL in a cluster configuration, 2 nodes with a DRBD RAID10 pair of storage systems to keep the data up and running. In the event of Datacenter failure (worst possible case) have a 3rd tier passive replica at another datacenter with transaction logs being shipped.

Web- 2 Web servers, local data stored on a seperate set of drives RAID1 or RAID10 depending on size and I/O. Replicate data via Robocopy. Added performance and requirement for 100%, incorporate dedicated load balancers in a pair. Additional replica web server at a seperate datacenter.

link|improve this answer
feedback
up vote 1 down vote

it depends on how current you want your data and how much data you will be transfering.

link|improve this answer
The idea is to keep two hot-hot SQL Server DB's at different physical locations so that if one goes down there is no interruption in service. Is this even possible? – Guy Jul 28 '09 at 15:11
real time synchronization isn't likely without high expenses, especially if you have a lot of data transferring around. clustered failover servers w/ a quality san and reliable backup routines would be a much easier solution to implement. – Keith Jul 28 '09 at 21:22
feedback
up vote 1 down vote

noneil, I think the point of the site is to encourage community problem solving. Lets have some open discussion so other people can benefit from having this question answered here.

link|improve this answer
1  
Please keep comments in the comments fields. This has nothing to do with the actual question. – phuzion Jul 28 '09 at 21:33
1  
bien, wasnt sure how to add these before. Thanks! – dubRun Jul 29 '09 at 12:45
feedback
up vote -1 down vote

I do a lot of work involving these kind of solutions and meeting high levels of redundancy and compliance. I can do you a solid and offer recommendations.

let me know if you want to chat, have a good one.

link|improve this answer
1  
I'm looking for community discussion/problem solving on this one. – Guy Jul 28 '09 at 15:12
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.