Installing HP Insight Software 6.1 Update 1 on Windows Server 2008 R2 Failover Clusters with SQL Server 2008 for high availability
7
Figure 1:
Relationships among
Systems Insight Manager
, Insight Software, SQL Server 2008, and the cluster disks
Insight Software virtual server
HP SIM IP address: 16.92.155.186
SQL Server 2008 virtual server
IP address: 16.92.155.185
Failover Cluster primary system
IP Address: 16.92.155.179
Failover Cluster secondary system
IP Address: 16.92.155.180
SQL Server instance files
Insight Software files
Local connection
Remote connection
S: on shared storage V: on shared storage
Failover Cluster virtual server
IP Address: 16.92.155.183
The cluster monitors the services belonging to Insight Software and Microsoft SQL Server 2008.
If
a
service fail
s
, the cluster auto
matically presents that service
s shared storage to the other system, moves
the virtual server, and restarts the failed servic
e.
Getting started
This white paper documents how to install Insight Software on a new two
-
node Microsoft Failover
Cluster
1
.
The major steps are:
Set up the failover environment
Install SQL Server 2008 on the cluster
Install and validate Insight Software
on the cluster
If a clustered Microsoft SQL Server 2008 Enterprise named instance exists on a different cluster than
the one on which Insight Software is to run, you may use this instance and skip the installation of a
new SQL Server 2008 instance on the I
nsight Software cluster. In this case you may also skip the
allocation of the access point IP addresses and network names, and the shared disks for Microsoft
SQL Server and for Microsoft Distributed Transaction Coordinator.
Otherwise, the SQL Server instan
ce created below will be used to host the databases required for
Systems Insight Manager
and the Insight Software applications.
1
Windows Server 2008 R2 Enterprise supports Failover Clusters with up to 16 nodes. The number of supported nodes in a cluster
varies by
operating system version. For details, navigate to
http://support.microsoft.co
m
, and search for
Maximum number of supported nodes in a
cluster
.