Home > Ask the Systems Channel Experts > Database Administration Services Questions & Answers > Database clustering secures data
Ask The Systems Channel Expert: Questions & Answers
EMAIL THIS

Database clustering secures data

Retired Expert - Hilary Cotter EXPERT RESPONSE FROM: Retired Expert - Hilary Cotter

Pose a Question
Other Systems Channel Categories
Meet all Systems Channel Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 16 April 2007
What is failover clustering? How can VARs use it to ensure that customer's data remains safe?

>
EXPERT RESPONSE
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.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
Database Administration Services
What opportunities are there for VARs in a SQL Server upgrade?
How to decide which disaster recovery strategy is right for customers?
Why outsource database management services to a VAR?
Offer SQL Server security services
Integrating Microsoft Office with SQL Server
What should I expect when migrating custom applications from SQL Server to MySQL?
SQL Server database security
SQL Server capacity planning
SQL Server 2005 business suite and Microsoft Office integration
Controlling Microsoft SQL Server sprawl

Database Clustering
Oracle RAC troubleshooting advice and application migration tips
What skill sets do I need to support a fault-tolerant, high-availability system?
Oracle RAC: Log directory structure in cluster ready services
Oracle RAC: Log directory structure in Oracle RDBMS
Oracle RAC: ON and OFF
Oracle RAC and the Lamport algorithm
Oracle RAC: Member voting
Oracle RAC: Debugging CRS and GSD using DTRACING
Oracle RAC: Cluster reconfiguration steps
Oracle RAC: Debugging node eviction issues

Database Backup and Recovery
Oracle DBA trends: Beyond basics
Database mirroring best practices for VARs
SQL Server 2005 practical troubleshooting: Introduction
SQL Server 2005 Practical Troubleshooting: Fundamentals
SQL Server 2005 Practical Troubleshooting: Product enhancements
SQL Server 2005 Practical Troubleshooting: Data recovery best practices
SQL Server 2005 Practical Troubleshooting: User database inaccessible
SQL Server 2005 Practical Troubleshooting: Data recovery
Web-based database support
DBA services can make VARs money

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

HomeTopicsITKnowledge ExchangeTipsMultimediaWhite PapersBlogsEvents
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2006 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts