MS SQL Server
  Home arrow MS SQL Server arrow Page 10 - 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  
Silverlight  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
Mobile Linux 
App Generation ROI 
IBM® developerWorks 
ASP Web Hosting  
ASP.NET Web Hosting 
Windows Web Hosting
 
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) - Installing the First Node in the Cluster


    (Page 10 of 26 )

    When a cluster is built, the first system to be built is considered the first node in the cluster. This system needs to be initially prepared as the primary system. When the primary system has been configured, additional nodes can be added to the cluster.

    To install the first node in the cluster, follow these steps:

    1. Shut down both the cluster nodes and shared storage devices.

    2. Connect cables as required between the cluster nodes and shared storage devices.

    3. Connect each node's NICs to a network switch or hub using appropriate network cables.

    4. If a shared storage device is being used, power on the shared storage device and wait for the startup sequence to complete.

    5. Start the first node in the cluster. If a shared disk will be used, configure the adapter card's ID on each cluster node to a different number. For example, use ID 6 for node 1 and ID 7 for node 2.

    6. Log on with an account that has Local Administrator privileges.

    7. If the server is not a member of a domain, add the server to the correct domain and reboot as necessary.

    8. Configure each network card in the node with the correct network IP address information.

      Network cards that will be used only for private communication should have only an IP address and subnet mask configured. Default Gateway, DNS, NetBIOS-related services (such as Client for Microsoft Networks), and WINS should not be configured. Also, uncheck the Register This Connection's Address in DNS box, as shown in Figure 31.4, on the DNS tab of the Advanced TCP/IP Settings page.

      Morimoto

      Figure 31.4 TCP/IP DNS configuration settings.

      For network cards that will support public or mixed networks, configure all TCP/IP settings as they would normally be configured.

    9. If you're not already logged in, log on to the server using an account that has Local Administrator privileges.

    10. Click Start, Administrative Tools, Cluster Administrator, as shown in Figure 31.5.

      Morimoto

      Figure 31.5 Launching the Cluster Administrator utility.

    11. When the Cluster Administrator opens, choose the Create New Cluster action and click OK.

    12. Click Next on the New Server Cluster Wizard Welcome screen to continue.

    13. Choose the correct domain from the Domain pull-down menu.

    14. Type the cluster name in the Cluster Name text box and click Next to continue.

    15. Type the name of the cluster node and click Next to continue. The wizard defaults to the local server, but clusters can be configured remotely. The cluster analyzer analyzes the node for functionality and cluster requirements, as shown in Figure 31.6. A detailed log containing any errors or warnings that can stop or limit the installation of the Cluster server is generated.

    16. Review the log and make changes as necessary; then click Re-analyze or click Next to continue.

      Morimoto

      Figure 31.6
      Cluster analyzer utility operations.

    17. Enter the cluster IP address and click Next.

    18. Enter the Cluster Service account name and password and choose the correct domain. Click Next to continue.


      Note - The Cluster Service account needs to be only a regular domain user, but specifying this account as the Cluster Service gives this account Local Administrator privileges on the cluster node and also delegates a few user rights, including the ability to act as a part of the operating system and add computers to the domain.


    19. On the Proposed Cluster Configuration page, review the configuration and choose the correct quorum type by clicking the Quorum button, as shown in Figure 31.7.

      Morimoto

      Figure 31.7
      Choosing the cluster quorum configuration.

      • To create an MNS cluster, click the Quorum button on the Proposed Cluster Configuration page, choose Majority Node Set, and click OK.

      • If a SAN is connected to the cluster node, the Cluster Administrator will automatically choose the smallest basic NTFS volume on the shared storage device. Make sure the correct disk has been chosen and click OK.

      • If you're configuring a single-node cluster with no shared storage, choose the Local Quorum resource and click OK.

    20. Click Next to complete the cluster installation.

    21. After the cluster is created, click Next and then Finish to close the New Server Cluster Wizard and return to the Cluster Administrator.

    Alternatively, you can create a cluster by using Cluster.exe. You can use the following to create a cluster called cluster1 on the server named Server1. This example uses a Cluster Service account called clustersvc@companyabc.com, using the 192.168.100.10 IP address and a class C subnet mask. Also the network card is renamed Cluster Mix Nic at a command prompt. The command is as follows:

    Cluster.exe /CLUSTER:cluster1 /CREATE /NODE:server1 /USER:clustersvc@companyabc.com
    /PASSWORD:password /IPADDRESS:192.168.100.10,255.255.255.0, "Cluster Mix Nic"

    Then press Enter to create the cluster.

    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.

    More MS SQL Server Articles
    More By Sams Publishing


     

    MS SQL SERVER ARTICLES

    - Windows Server 2008 as a Workstation OS
    - An Overview of Windows Server 2008 R2
    - LINQ to MySQL, Oracle and PostgreSQL Provide...
    - 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





    © 2003-2009 by Developer Shed. All rights reserved. DS Cluster 5 Hosted by Hostway
    For more Enterprise Application Development news, visit eWeek