I will be installing SQL Server Cluster setup on 2 nodes and it will be a 2 part exercise-
- New instance installation in one of the nodes.
- Add the other node to the existing clustered instance.
A clustered instance is a SQL Server instance installed over a Windows Failover Cluster (WFC) service. WFC service helps us to protect from hardware failure scenarios. In a scenario of a cluster with two nodes, we are talking about two servers, with similar hardware configuration, connected by a Failover Cluster service. Out of the 2 nodes, one of them will be serving as ‘Active Node’ while the other will be in Idle state. WFC accepts shared storage, which means that we need a SAN to store the database files (logs and data).
Before we start the installation, we need to assure that we have the following items ready to be used:
- A virtual hostname or SQL Server Network Name – “MyVIPName″ (Outside world or the applications will be knowing your SQL Server via this name. It will further take it to the current Active Node).
- A virtual IP, a.k.a vIP. We will use: 192.168.1.6.
- Available shared storage.
- Windows Server Nodes – W2K8R2N1 and W2K8R2N2.
- Windows Cluster Name – WIN2K8R2CLUSTER
- Service Accounts: One for SQL Server Engine and another for SQL Server Agent. We will use the following accounts: SQL2K8WKS\SQL2K8R2SVC and SQL2K8WKS\SQLAgent2K8R2SVC. These service accounts are domain accounts. We have no other choice, to build a cluster we need to be part of a domain.
We shall first be starting with the setup on Node 1->
1) With the SQL Server installation binaries available, click “Setup”:
2) Click ‘Installation’ and it will take you to a new window:
3) Select ‘New SQL Server Failover Cluster Installation’:
4) At this step, the setup support files will be extracted and installed, click “Install”:
5) Verification of Setup Support Rules:
6) Installation of Setup Support Files-
7) Finally, we have all the setup files installed. Another check will run in order to validate if problems might occur when SQL Server files is installed.
Its recommended to have Clustered MS DTC Resource (http://blogs.msdn.com/b/cindygross/archive/2009/02/22/how-to-configure-dtc-for-sql-server-in-a-windows-2008-cluster.aspx)
8) Select “I accept the license terms” and click “Next”:
9) Select the features you want to install:
10) Here we will define the instance network name or the Virtual Name (one of our prerequisites). Also, here we can opt to use either a default or named instance.
11) This step confirms if the disk space requirements are being met. Click “Next”:
12) This is related to the Cluster Resource Group name to be used. The installation suggests a name, but you can change it.
This window also shows the reserved and already used Resource Group names. Change the Resource Group name if you are not satisfied with the suggestion and click “Next”:
13) At this step, we will have the information of all available storage to be used on our new clustered instance.
I am going to use – SQL2008R2Base as my shared disk.
14) Unmark the DHCP column and fill the address column with the value of the IP. And… “Next”
15) Use the recommended settings here-
16) Fill the information about the SQL Server Engine and Agent service account (login and password). For a clustered instance, the “Startup Type” for the services should be as “Manual”. The Cluster Service will manage this for us.
17) In Account Provisioning, I am going to use ‘Mixed Mode’. The options are either “Windows Authentication”, which will take benefit from domain and local server logins, or “Mixed Mode”, which accepts Domain/Windows logins as well as logins created and managed by SQL Server.If you pick “Mixed Mode” a login called “sa”, member of the “Sysadmin” role will be enabled.
For the disk strategy, Isolate the TempDB in a faster disk and segregate the Data/Log Files in another directories.
18) Here you have an option to send error reports or not. Click “Next”
19) This step will determine if the installation process be blocked.
20) Installation has begun-
21) Voila! Installation succeeded on the first Node-
We shall be covering the installation on second node in Part -2 of this series.
Till then, happy learning.