Tuesday 8 April 2014

Installing Failover Clustering With Windows Server 2008 R2

Introduction:

Creating a Cluster with Windows Server 2003 was a little bit confusing for administrators.Now with Windows Server 2008, its much easier.In this article I will be showing you how to setup a cluster with two nodes using Windows Server 2008 R2 Failover Clustering feature.

Creating a failover cluster means you have atleast two servers connected to a shared storage.

Failover Clustering System Requirement:


  • Windows Server 2008 R2 - Failover Clustering feature is available with Windows Server 2008/R2 Enterprise/Data Center editions. You don't have this feature with the Standard edition of Windows Server 2008/R2.
  • Domain role - All servers in the cluster must be in the same Active Directory domain.
  • DNS - The servers in the cluster must be using Domain Name System (DNS) for name resolution.
  • Account for administering the cluster - When you create a cluster or add servers to it, you must be logged on to the domain with an account that has administrator rights on all servers in that cluster (if the account is not a Domain Admins account, the account must be given the Create Computer Objects and Read All Properties permission in the domain).
  • Servers - Two identical servers in brand, model and configuratons.
  • Device Controllers (HBA) - i/SCSI or Fiber, both also to be identical.
  • Storage - You must use shared storage that is compatible with Windows Server 2008 R2.
Now that you know the requirement for Failover Clustering, lets start

Configuration on Server A:

  1. To install Failover feature, open Server Manager, click on Start > All Programs > Administrative Tools > Server Manager
  2.  Expand Features, and then click on Add Feature.The list of available features will be listed, select the Failover Clustering and click NextClick Install
  3. The Failover Clustering feature will be installed.Click Close.

Configuration on Server B:

  1. Again on Server B, we will need to install Failover Clustering feature as well, so click Start > All Programs > Administrative Tools > Server Manager Click on Features and then click on Add Features
  2. Choose the Failover Clustering feature and click Next
  3. Confirm installing Failover Clustering by clicking on install Close the Add Feature Wizard once installation is completed Now that both servers have Failover Clustering feature installed on them, we can create the cluster on one of these server and join the other one to the cluster.
Now, we need to open and configure our cluster name, IP address and nodes.

To open Failover Clustering, click on Start > All Programs > Administrative Tools > Failover Cluster Manager
>> This need to be done on a single server only << 



      1. The first step in creating a successful failover clustering, is by validating the existing systems and shared storage. This is done by the option Validate a Configuration                                          When you click on Validate a Configuration, you will need to browse and add the cluster nodes, these are the servers that will be part of the cluster, the click next  Choose to Run all tests and click Next The available tests will be displayed in the confirmation window, click Next to begin validating you cluster.  Review the validation report, as you configuration might have few issues with it and needs to be addressed before setting up cluster. 
      2. Now that the configuration is validated and you are ready to setup your cluster. Click on the second option, Create a Cluster, the wizard will launch, read it and click Next 
      3. You need to add the names of the servers you want to have in the cluster. You can start creating your cluster with a single server and then add other nodes in the future. Browse to your servers and then once all the servers (nodes) are listed click Next 
      4. After the servers are selected, you need to type a name and IP for your cluster 
      5. On the Confirmation window, review your settings. The following will be displayed in this window: cluster name and IP address, selected servers name. If all info is proper, then click Next else click Previous and correct which setting needs to be adjusted.  After you click Next, creating the cluster will begin.
      6. The summary windows will be displayed after a successful setup of the cluster. 
      7. Open Failover Cluster Manager and you will see your nodes and setting inside the MMC. Here you can configure your cluster, add new nodes, remove nodes, add more disk storage and so on.

Summary:

In this article, we have created a two node cluster using Failover Clustering feature which is available with Windows Server 2008 R2 Enterprise and Data Core editions.

SQL Server Query Execution Plans for beginners – Clustered Index Operators

In this article we will continue discussing the various execution plan operators related to clustered indexes and what they do, when do the...