Clustering
-
My firm wants to install clustering Active/Pasive for one of there application.
That application does 200 Transaction per day, I mean 200 Update and insert will happen.
The database will grow say hardly 8% per year.
Do you thing it is worth to install Clustering on this box?
Nita
-
Nita Reddy (3/12/2008)
My firm wants to install clustering Active/Pasive for one of there application.That application does 200 Transaction per day, I mean 200 Update and insert will happen.
The database will grow say hardly 8% per year.
Do you thing it is worth to install Clustering on this box?
Nita
More important than how fast it will grow is how important it is to minimize down time. Active/Passive set up properly can ensure that you have virtually no downtime if one of the servers goes down. If it is important to have truly high availability than clustering is the way to go, on the other hand if that level of high availability is not necessary than it is probably not worth the time, effort, and hardware it would take.
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/ -
As I said only 8% grow in a year and only 200 per transaction per day
Do you think spending this much money is worth for clustering...or use log shipping or mirroring
-
What is the impact to the business if the database is unavailable for 24 hours or so? If the impact is minimal, then it isn't worth it.
Tommy
Follow @sqlscribe -
How about log shipping or mirroring is that the alternate choice for Clustering
-
Sure - you might want to start w/ an article Steve wrote a while back -
http://www.sqlservercentral.com/articles/Disaster+Recovery/sqlserver2005highavailability/2421/
Tommy
Follow @sqlscribe -
According to me choosing a type of HA option depends on how cruitial data you have and how much down time is allowed!!
Definately cluster would be good choice but its costly affair, log shipping, replication or database mirroring can be consider against cluster.
Hemantgiri S. Goswami | SQL Server Specialist & Consultant
SQL Server Citation[/url] | Follow me on Twitter -
I agree with karthikeyan! Mirroring with High-Safety Mode with Automatic Failover with be the best option for you.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply