Clustering can be an appropriate solution for high availability, but it is not always the best choice. For example, it is only a solution to solve local failures – it has a distance limitation – so it cannot be used for disaster recovery to a remote data center. Other high availability solutions may be more appropriate depending on the cost of downtime. On the other hand, clustering is one of the high availability technologies that will provide automatic failover and will not degrade the over all SQL Server performance.
Clustering requires a different skill set than most other DBA functions, so a customer implementing clustering should have the talent in-house to maintain the cluster. Applications using databases on a clustered server must be cluster aware -- they must have some logic built into them to prevent data loss which may occur during cluster failover.
With this in mind I would recommend clustering to a client when clustering meets their high availability requirements, they have a budget to justify its cost, the application is cluster aware and they have the skill set to support and maintain the cluster on site.
Dig Deeper on Database software management
Related Q&A from Hilary Cotter
Learn why Oracle VM would be chosen over Hyper-V or VMware and read an expert's recommendations for implementing Oracle VM. Continue Reading
SOA depicts how two services or programs can communicate with each other. Learn why SOA should catch the attention of service providers and the ... Continue Reading
Learn the new components of Windows XP SP3 including black hole router detection and network access protection. Compare XP SP3 features to Vista and ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.