Database Reference
In-Depth Information
The setup change for SQL Server 2008 needs to run the setup program on each node that
is involved as part of the failover cluster and also offers an option to create an enterprise
push node from the active node with a configuration file. Many of the SQL Server services
are cluster-aware, such as Analysis Services, Full-Text search, Integration Services, and
FILESTREAM. In this recipe, we will go through the important steps required to install and
configure the SQL Server 2008 R2 failover cluster services within the data platform.
Getting ready
Although there are no pre-configured hardware requirements defined to install the failover
clustering, it is essential to go through the following pre-installation list of components for the
hardware, operating system, and environment versions that are being deployed.
While the identical hardware is not essential for failover clustering, it is best practice to obtain
the following configuration to host the failover cluster services:
F
The system components such as CPU and Memory must be identical for all the nodes
within the failover cluster.
F
SAN configuration is a combination of one or more disks as a resource group in
Microsoft Cluster Services (MCSS) group.
F
A network name for failover cluster instances with the relevant IP Address.
F
Ensure that the operating system is installed properly and designed to support
failover clustering. It is essential that the operating system is equipped with latest
service pack on which SQL Server will run.
F
Ensure the following components for the SQL Server failover clustering are
configured:
IP Addresses on Windows Cluster machines
Network names
Disk drives on the shared drive array
SQL Server service accounts
Configure a unique IP address on the public network segment in the cluster
with a unique network name that is registered into DNS to resolve by name
F
Configure Microsoft Cluster Services (MSCS) on one node, which is supported if it is
installed on a hardware configuration that has been tested for compatibility with the
MSCS software.
Ensure all the hardware drivers for X64-bit such as
Network Interface Cards (NIC) and Host Bus Adapters
(HBA) are available from the vendor and installed.
F
Deploy the Windows servers and clusters on SAN shared storage devices.
Search WWH ::
Custom Search