Q

Database clustering secures data

Database clustering is a good tool for you to use to keep a client's data safe and available constantly.

What is failover clustering? How can VARs use it to ensure that customer's data remains safe?
Failover clustering is when two or more servers with specialized hardware and software share resources and appear to client applications as a single server (called a virtual server) with a different name and IP address than the individual servers which form the cluster. If something happens to one of the servers, the cluster will failover to another node and the client will experience minimum downtime during the failover and can reconnect to the virtual server.

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.
This was first published in April 2007

Dig deeper on Database Management Products and Solutions

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

MicroscopeUK

SearchCloudProvider

SearchSecurity

SearchStorage

SearchNetworking

SearchCloudComputing

SearchConsumerization

SearchDataManagement

SearchBusinessAnalytics

Close