Monday, December 1, 2014

Installing SQL 2008 R2 Cluster Step-By-Step

Deploying SQL 2008 Cluster
This is a step by step Guide on deploying SQL 2008 Cluster
Let’s begin with the pre-requisites

Pre-requisites

In order to plan everything ahead, we need to prepare some IPs and names as well as Network Configuration
During the deployment you will be using IPs and Names for the following
1- Windows Cluster
2- DTC
3- SQL
You can plan for those and document them for use ahead of time, just to save yourself some time
This is what I made
DescriptionHostnameIP AddressSubnet MaskDefault Gateway
Cluster IP AddressXXCLUSTER172.21.XX.XX255.255.255.128N/A
SQL Instance IP AddressXX2010SQL172.21.XX.XX255.255.255.128N/A
MSDTC Virtual IPXX2010SQLDtc172.21.XX.XX255.255.255.128N/A
SQL Cluster Node 1Node1172.21.XX.XX255.255.255.0172.21.X.1
SQL Cluster Node 2Node 2172.21.XX.XX255.255.255.0172.21.X.1
We then need to setup 2 Network Interfaces to be used in production and the other as a heartbeat
clip_image002
We need to configure the HeartBeat interface on each node as follows:
Node 1
clip_image004clip_image006
clip_image008clip_image010
Node 2
clip_image011clip_image013
clip_image014clip_image015
We do a little test and make sure they can communicate
clip_image016
Now the heart beat has been configured, you need to Assign IPs to the Production interfaces, those are the interfaces that will communicate with the servers.
Now that the networking part is out of the way, let’s go ahead and start the Failover Cluster Role installation

Windows Failover Cluster installation

The following steps need to be performed on both database tier machines.
1. Click on Server Manager > Features Add Features
clip_image018
2.
clip_image020
2. Check the Failover Clustering checkbox and click Next
3. Click on Install to install the feature
clip_image021
4. Click Close to conclude the installation wizard
clip_image022

Host Validation Tests

Now we need to run the validation tests to make sure our nodes are correctly configured
clip_image024
1. Click on Validate Configuration
clip_image026
2. Click Next at the validation wizard’s intro screen
clip_image028
3. Click Browse in the Select Servers or a cluster window
clip_image030
4. Set the Object Types to Computers and search for the two cluster nodes
clip_image032
5. Once the two cluster nodes have been selected click on Next to proceed
clip_image034
6. Leave radio button at its default position (Run all tests) and then click Next
clip_image036
7. The validation wizard summary will be displayed. Review it and click Next to initiate the cluster validation
clip_image037
8. If the validation wizard returns any errors review and resolve them before proceeding. Errors need to be resolved before creating the cluster. Ensure that you review warnings.

Creating Windows 2008 Cluster

SQL Server 2008 R2 clustering requires a windows cluster to be setup prior to creating the SQL node. To create the windows cluster perform the following steps:
1. In the Failover Clustering Console click on Create a cluster
clip_image039
2. Click Next at the welcome screen
clip_image041
3. Click Browse and select the appropriate cluster nodes
clip_image043
4. Click Next to run pre-configuration validation (essentially the same validation as before, but recommended to run again right before the cluster setup).
clip_image044
5. Enter the following information in the Access point for Administering the Cluster window:
a. Cluster Name: SPCLUSTER
b. IP Address: 172.21.X.X
clip_image045
6. Review the summary in the confirmation window and click Next to proceed with the cluster installation
clip_image046
7. If any warnings/errors were generated review them and retry if necessary. If none were generated click onFinish to close the wizard.

Verifying Cluster Storage and Quorum

Now in windows server 2008 R2, the cluster Quorum and storage will be configured automatically, we need to check on that
clip_image048
And this seems right, now we need to check on the Quorum type to make sure that it is set to Node and Disk Majority
clip_image050

Configuring Windows 2008 (R2) Application Server

We now need to start deploying the application server role on both the nodes
clip_image052
clip_image054
clip_image056
clip_image058
clip_image060
clip_image062
clip_image064
clip_image066
clip_image068
clip_image070

Configuring MSDTC

clip_image072
clip_image074
clip_image076
clip_image078
clip_image080
clip_image081
clip_image083
clip_image084
clip_image086
clip_image087

Installing the SQL 2008 R2 Cluster

Now we are about to start the installation of the First node in the cluster
clip_image089
Enter your product key
clip_image091
Install the Support Files
clip_image093
Install Features
clip_image095
Configure the Network Name ( this is going to be the cluster name ) and instances
clip_image096
clip_image098
Choose your Cluster Resource Group ( I left it at default )
clip_image099
clip_image101
clip_image103
clip_image105
Configure the Service accounts Users and Password ( Best Practice is to use individual accounts )
clip_image107
clip_image109
Configure Your Locations ( Best practice is to Separate Database Files from Log Files)
clip_image111
The Install, But do not configure is the only option available as we haven’t installed the pre-requisites for Reporting Service.
clip_image113
Make Sure everything passes on the Cluster installation Rules
clip_image115
Review your install Summary and Click Install
clip_image116
Now wait for the installation to finish
clip_image118
Now after the installation finishes
Make sure your resources are up
clip_image120
Now that all is good and Green we need to start the installation on the second node
So fire up the Setup and choose
clip_image121
Install Support rules and Make Sure all passes
clip_image123
Enter your product key
clip_image124
clip_image126
You will see that setup has detected the current Single node cluster from above, click Next
clip_image128
Enter the same Accounts and passwords
Make sure everything is Green
clip_image129
Review your installation
clip_image131
Click on install and wait for the installation to finish
clip_image133

Verifying The Cluster

Now if you go to the SQL Server Clustered application properties you now see both nodes added
clip_image135
Hope that helps

No comments:

Post a Comment