Installing and upgrading to HP Insight Software 6.2 on Windows Server 2008 R2 Failover Clusters with SQL Server 2008 for high availability

10
4.
Mi
c
rosoft
Distributed
Transa
c
tion
Coordinator virtu
a
l server and a
c
cess point
Function:
To
ac
t as the virtual
server IP
a
ddr
e
ss and name for the
Mi
c
rosoft Distributed
Trans
a
ction
C
oordinator se
r
vice. T
h
is ser
v
ice
co
o
r
dinates
trans
a
c
tions that
are
distributed
a
c
ross
a
c
l
u
ster.
Sugges
t
ed ac
t
ion:
Mi
c
rosoft
Distributed
T
r
ansa
c
tion
Coord
i
nator is i
n
stalled with
Microsoft SQL
Server 2008.
In the examples
discussed
in t
h
is white
p
aper, the IP address is 16
.
92.155.184
and the name is CMS
-
C2
-
D
TC.
Another two static IP addresses and names are nee
d
ed for the primary and se
c
on
d
ary syste
m
s.
5.
Failover
Cluster primary
system IP address and name
Function:
To serve as the TCP/IP address and name
of the specific
Microsoft Windows
ser
v
er host.
Sugges
t
ed ac
t
ion:
Any software that references
system
-
s
pecific fun
c
tions uses this
address
to
c
onne
c
t to this system.
In the
examples
discu
s
sed in this white paper,
the IP address
is
16.92.155.
1
79 and the name is CMS
-
C2
-
N1.
6.
Failover
Cluster se
c
ondary
system IP address
and na
m
e
Function:
To serve as the TCP/IP address and name
of the specific
Microsoft Windows
ser
v
er host.
Sugges
t
ed ac
t
ion:
Any software that references
system
-
s
pecific fun
c
tions uses this
address
to
c
onne
c
t to this system. For the examples
discu
s
sed in this white paper,
the IP address is
16.92.155.
1
80 and the name is CMS
-
C2
-
N2.
The “16
.
” ne
t
wo
r
k re
f
ere
nc
ed
above is
the
public network u
s
ed
by
c
l
i
ents to a
c
c
e
ss c
lu
ster
s
erv
i
c
e
s.
Failover
Clus
t
ering also re
q
u
i
r
es
a private
network to
be implemen
t
ed for e
x
changing the cl
u
s
t
er
heartbeat.
T
h
e Failover Cluster primary
a
nd sec
o
n
dary syste
m
s will
also have static IP
addresses on
the private networ
k
.
In this
white paper, the “10.”
network is used
as the private
network.
If you are im
p
lementing sh
a
red storage with an
iSCSI SAN,
in addition
to the above network
resou
r
c
e
s you will need an additional
dedi
c
a
ted
network
adaptor
on
each
c
l
u
s
ter
system
and,
possibly IP a
d
dre
s
s
e
s for t
h
e target. (The
target is the
storage
c
ontro
ll
er to wh
i
c
h the c
l
us
t
er sys
te
ms
con
n
ect to
ac
c
e
ss SAN r
es
ou
r
c
e
s
.
)
Cluster
configuration
Fi
g
ure
1
demonstrates
how to configu
r
e
a clus
t
er f
o
r
e
nhanced per
f
ormance once all compo
n
ents are
installed. In this acti
v
e
-
ac
t
ive co
n
fi
g
urati
o
n, load
is distributed
by running Insight Software and
S
QL
Server on dif
f
erent s
y
ste
m
s.
The pur
p
o
s
e of the primary
system
i
s to run the HP SIM s
e
rvice and other Insi
gh
t
Software
c
o
m
ponents.
The pur
p
ose of the sec
o
ndary system
i
s to run the Mic
r
os
o
ft SQL Se
r
ver 2008 pr
o
c
esses and to
handle remo
t
e Microsoft
S
QL Server commands.
Set
up
the
failover
environment
This
section
covers
setti
n
g up the c
l
us
t
er environment
i
n
preparation for installi
n
g SQL Server
2
008
and Insight Software. At
this time,
Win
d
ows 2008
R2
Enterprise
should be installed
on the primary
and se
c
ondary syste
m
s, the public and private
net
w
o
r
k
s sh
o
u
ld be confi
g
u
r
ed on each, the sys
t
ems
should be members
of the
domain which
is to h
o
st
the
c
luster,
and
a
l
l other network and
storage
reso
u
r
c
e
s des
c
ribed
above
sho
u
ld
have
been provisioned
and are
a
vailable.