Clustering protects from localized hardware failure (for example a power supply failure on one node), but does
not protect from a power failure in the building supplying all nodes in the cluster. Geo-clustering can keep data in sync between two geographically dispersed servers, and should you experience a regional failure (a flood) your applications can reconnect to the DR site.
The challenge for VARs is to:
- Provide servers with hardware redundancy so that they will be as resilient to hardware failures localized to that node
- Provide clusters which will provide high availability so the cluster will be as resilient as possible to node failures (for example a unexpected SQL Server shutdown due to a program fault, or a planned outage for hardware servicing or a service pack). In a cluster you can take a node offline by failing over to other nodes in the cluster.
- Provide DR solutions which will protect the client's data against regional failure by keeping a DR site in sync with a near real time copy of your data.
Dig deeper on Database Management Products and Solutions
Related Q&A from Retired Expert - Hilary Cotter
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
Choose which SQL Server security services to offer your customers. Our DBA site expert outlines your options.continue reading
Compatibility problems might crop up in a migration from SQL Server to MySQL. Our DBA site expert Hilary Cotter helps you prepare for them.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.