some question about cluster

some question about cluster

Post by macchianer » Thu, 28 Apr 2005 06:39:23

Hi everydoby, i'm new in this ng :=)
I'm also new to cluster and i have little questions.
I have 2 node (identical, HP DL380) and a san MSA1500, redundant path FC,2
network card for private and public.SQL 2000 clustered.
These are my tests:
1. i try to unplug the cable (private connection, hbeat) but i don't know
what must happen. Is the main node that must remain up and running?
2.when i unplug the public cable all the group move to nodeB except the
group "Storage" where i put three physical disk, why? The physical disk have
no dependencies...i don't know this behavior :-\
3. i try to unplug the FC connection fro the server and the groups move from
nodeA to nodeB. When i plug into the FC connection the group remains on the
nodeB instead to move on nodeA. The failback setting are correct, because if
i power down nodeA or nodeB the "Cluster cycle" work correct: from A to B
and when A is online the resouce came back again to nodeA. It's seems "don't
hear" the change of state of the FC link...
There are some techicnal limitation that i don't know or there are some
setting to do?
Thanks a lot in advance!

some question about cluster

Post by Geoff N. H » Thu, 28 Apr 2005 10:58:13

Comments Inline

That's OK, I have been here for a while. Everybody starts at the beginning.

Probably nothing if you have configured everything correctly. The cluster
should use the public NICs as a backup communications path. This is
determined by the cluster configuration network settings. Since no resource
dependencies were lost AND the cluster nodes still have a communication
path, nothing changes.

This is normal. When you unplugged the public NIC, all IP addresses that
depend on that physical resource went offline. When each resource went
offline, the cluster moved the recource group it was part of to another host
in order to try and bring it online. Since the group "Storage" had no
network dependencies, it didn't go anywhere.

It may take a reboot to restore the disk connection via the Fibre Channel
connection. You may be able to rescan using the Disk Management tool and
get the system to see the disks again. Either way, a reboot after such a
disconnect is not the worst idea in the world.

Glad to help

Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator


some question about cluster

Post by Macchianer » Thu, 28 Apr 2005 16:20:26

Thank u very much for your help Geoff!
My many thing i have to learn... =:-)
Your explanation is perfectly clear for me, but about one thing im' not
The group "Storage" is composed by 3 physical disk only, is correct? In
other words, is correct that this group don't move from one node to the
other or i have to put in this group a dependencie (network, ip...)?
For the other points, they are very clear for me now.
Have u got a link for this type of troubleshooting or a book to suggest?
Thanks a lot again!

some question about cluster

Post by Geoff N. H » Thu, 28 Apr 2005 21:58:45

To use these disks for SQL, you will need to move each disk to the resource
group for whichever SQL instance you want to use it for. You will then have
to modify the dependencies of the SQL Server service to be dependent on that
disk. The SQL Service will have to be offline to make this change. Read
BOL on FAILOVER CLUSTERING for more details.

Geoff N. Hiten
Microsoft SQL Server MVP

some question about cluster

Post by macchianer » Fri, 29 Apr 2005 02:38:37

"Geoff N. Hiten" < XXXX@XXXXX.COM > ha scritto nel messaggio


Ok, now i know!
It's completely clear! :=)
Thanks a lot again!