Ask the Expert

Database clustering -- Is it right for your client?

When should I have my customer consider database clustering?

    Requires Free Membership to View

Prior to recommending clustering it is critical that VARs determine exactly what goals the customer is trying to achieve by clustering. For example, clustering does not offer improved performance.

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.

This was first published in January 2007

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: