MS SQL Server
  Home arrow MS SQL Server arrow Page 26 - System-Level Fault Tolerance (Clustering/N...
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
ASP Web Hosting  
ASP.NET Web Hosting 
Dedicated Servers 
Moblin 
JMSL Numerical Library 
Windows Web Hosting
 
IBM® developerWorks 
Sun Developer Network 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
MS SQL SERVER

System-Level Fault Tolerance (Clustering/Network Load Balancing)
By: Sams Publishing
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 4 stars4 stars4 stars4 stars4 stars / 15
    2004-09-22

    Table of Contents:
  • System-Level Fault Tolerance (Clustering/Network Load Balancing)
  • Choosing Networking Hardware for Fault Tolerance
  • Examining Windows Server 2003 Clustering Technologies
  • Active and Passive Clustering Modes
  • Choosing the Right Clustering Technology
  • Implementing Cluster Service
  • An MNS Cluster Scenario
  • Shared Storage Devices
  • Installing Cluster Service
  • Installing the First Node in the Cluster
  • Adding Additional Nodes to a Cluster
  • Cluster Group Failover Configuration
  • Testing Clusters
  • Maintaining Cluster Nodes
  • Creating Additional Cluster Groups and Resources
  • Removing a Node from a Cluster
  • Cluster Node Backup Best Practices
  • Backing Up the Cluster Node System State
  • Restoring a Single-Node Cluster When the Cluster Service Fails
  • Restoring a Single Node After a Complete Server Failure
  • Restoring an Entire Cluster to a Previous State
  • Restoring Cluster Nodes After a Cluster Failure
  • Installing Network Load Balancing Clusters
  • Using the Network Load Balancing Manager to Create a Cluster
  • Managing NLB Clusters
  • Summary and Best Practices

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    System-Level Fault Tolerance (Clustering/Network Load Balancing) - Summary and Best Practices


    (Page 26 of 26 )

    Windows Server 2003 clustering services enable organizations to create system-level fault tolerance and provide high availability for mission-critical applications and services. Although Cluster Service and network load balancing are each characteristically different and are best deployed on very different types of applications, between them they can increase fault tolerance for almost any application.

    Best Practices

    • Purchase quality server and network hardware to build a fault-tolerant system. The proper configuration of this hardware is equally important.

    • Create disk subsystem redundancy using RAID.

    • Don't attempt to run both MSCS and NLB on the same computer because Microsoft does not support them due to potential hardware-sharing conflicts.

    • Use cluster-aware applications so that the cluster service can monitor the application. A cluster-unaware application can run on a cluster, but the application itself it not monitored by Cluster Service.

    • Use active/passive clustering mode except in cases where performance is critical. Active/passive mode is easier to manage and maintain, and the licensing costs are generally lower.

    • Use NLB to provide connectivity to TCP/IP-based services such as Terminal services, Web sites, VPN services, and streaming media services.

    • Use Windows Server 2003 Cluster Services to provide server failover functionality for mission-critical applications such as enterprise messaging, databases, and file and print services.

    • Disable power management on each of the cluster nodes both in the motherboard BIOS and in the Power applet in the operating system's Control Panel to avoid unwanted failover.

    • Carefully choose whether to use a shared disk or a nonshared approach to clustering.

    • Always purchase one additional node when planning for an MNS cluster.

    • Be sure that both Microsoft and the software manufacturer certify that third-party software packages for Cluster Service will work on a Windows Server 2003 cluster; otherwise, support will be limited when troubleshooting is necessary.

    • Use multiple network cards in each node so that one card can be dedicated to internal cluster communication (private network) while the other can be used only for client connectivity (public network) or for both public and private communication (mixed network).

    • Configure the failback schedule to allow failback only during non-peak times or after hours to reduce the chance of having a group failing back to a node during regular business hours after a failure.

    • Thoroughly test failover and failback mechanisms.

    • Do not change the Cluster Service account password using the Active Directory Users and Computers snap-in or the Windows security box if logged in with that account.

    • Be sure that a majority of the nodes remain running to keep the cluster in a working state if you're removing a node from an MNS cluster.

    • Carefully consider backing up and restoring a cluster.

    • Perform ASR backups periodically and immediately following any hardware changes to a cluster node including changes on a shared storage device or local disk configuration.

    • Thoroughly understand the application that will be used before determining which clustering technology to use.

    • Create a port rule that allows only specific ports to the clustered IP address and an additional rule blocking all other ports and ranges.

    • Employ tools such as Robocopy.exe, which are located in the Windows Server 2003 resource kit or Application Center, to replicate data between NLB nodes.

    This chapter is from Microsoft Windows Server 2003 Unleashed, by Rand Morimoto, et al. (Sams Publishing, 2004, ISBN: 0672326671). Check it out at your favorite bookstore today.

    Buy this book now.



    DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

     

    MS SQL SERVER ARTICLES

    - Completing the Introduction to Transact-SQL
    - A Brief Introduction to Transact-SQL
    - Lookups and Blocking Bad Data
    - Field Validation Rules for Blocking Bad Data
    - Using Masks to Block Bad Data
    - Blocking Bad Data
    - Using @@ROWCOUNT and TABLE Variables for Dat...
    - How to Use Variables, IF and CASE in Databas...
    - Creating Important Aspects of Notification S...
    - Working wth Variables in Database Interactio...
    - Delving Deeper into Notification Services
    - Notification Services
    - Building a Multi-table Report with SQL 2005 ...
    - A Secure Way of Building Connection Strings
    - Transferring a Database Using the SSIS Desig...





    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway