Installing and upgrading to HP Insight Software 6.2 on Windows Server 2003 R2 MSCS for high availability

11
Function:
To act as the virtual server IP address and name for the Microsoft SQL Server 2008
Enterprise database software. This software is used to extract, manipulate, or back up the
Insight Software and
Systems Insight Manager
databases.
Suggested action:
The
Sys
tems Insight Manager
Open Database Connectivity (ODBC) data
source uses this virtual server IP address and name as the location where the CMS
Systems
Insight Manager
Data Source Name (DSN) points. In the examples discussed in this white
paper, the IP addre
ss is
140.110.240.63
and the name is
CMS
-
SQLSVR
.
4.
Microsoft
DTC
virtual server
IP address and name
Function:
To act as the virtual server IP address and name for the Microsoft
DTC
service. This
service co
ordinates transactions
across a cluster
group
.
Suggested action:
Microsoft DTC is installed with Microsoft SQL Server 2005. In the examples
discussed in this paper, the IP address is
140.110.240.65
and the name is
CMS
-
MS
DTC
.
Another two static IP addresses and names are needed for the primary and secon
dary systems.
5.
MSCS primary system IP address and name
Function:
To serve as the TCP/IP address and name of the specific Microsoft Windows server
host.
Suggested action:
Any software that references system
-
specific functions uses this address to
connect to
this
s
ystem. In the examples discussed in this paper, the IP address is
140.110.240.60
and the name is
CMS
-
HA1
.
6.
MSCS secondary system IP address and name
Function:
To serve as the TCP/IP address and name of the specific Microsoft Windows server
host.
Sugg
ested action:
Any software that references system
-
specific functions uses this address to
connect to this system. For the examples discussed in this white paper, the IP address is
140.110.240.61
and the name is
CMS
-
HA
2
.
The
140
.
network referenced above is
the public network used by clients to access cluster services.
MSCS
also requires that a private network be implemented for exchanging the cluster heartbeat.
The
MSCS
primary and secondary systems will also have static IP addresses on the private
network.
In this white paper, the
1
1
0.
network is used as the private network.
Cluster configuration
Figure 1
demonstrates how to configure a cluster for enhanced performance once all components
are installed. In this configuration, load i
s distributed by
designating that each cluster group works
on a separate system.
The purpose of the primary system is to run the
Systems Insight Manager
service and other Insight
Software components.
The purpose of the secondary system is to r
un the
Microsoft SQL Server 2005 Enterprise Edition
processes and to handle remote Microsoft SQL Server commands.