July 31, 2009 at 9:40 am
Hi
Here is the scenariio. The db takes approximately 60 calls (INSERTs / SELECTs) per second.
1. For such a database what precautions would i need to take?
2. How does cluster failover affect this? What will happen to the existing sessions? Will they all be disconnected?
TIA
=========================================================================
An Intelligent man is not one who knows the answers, but knows how to find them - Amartya Sen
=========================================================================
August 3, 2009 at 7:34 pm
It could take several minutes for a the cluster to failover if the active node should crash. All sessions would be disconnected during that time.
Not sure what you could do to mitigate the lose of time during the failover, but it does sound like an interesting topic to research. I think I may just do that as it may be worthwhile for my work as well.
I think that would make an interesting article.
August 4, 2009 at 2:30 am
instead of a failover cluster, consider a mirrored database with a witness server
Wilfred
The best things in life are the simple things
August 4, 2009 at 7:06 am
If using SQL 2005 or 2008 mirroring is something to look into, its easy to set up and maintain and with almost zero down time
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply