Re: A few questions on Failover

From: Dragon (NoSpam_Baadil_at_hotmail.com)
Date: 08/16/04 

Date: Mon, 16 Aug 2004 12:38:31 -0700

Thank you John for your reply.

What I have is 2 node failover cluster with SQL on it. Two groups created
one with SQL resources and one with Cluster's own resources. Both resources
have their own IP addresses. No teaming is in use/configured. My main
concern is to have false failovers (split brains may be) or 'no failover'
when in fact it should be a failover. I guess I don't understand how MS
Clusters really decide on split-brains.

"John Toner [MVP]" <jtoner@DIE.SPAM.DIE.mvps.org> wrote in message
news:OJDRWq6gEHA.1972@TK2MSFTNGP09.phx.gbl...
> ...Answers inline...
>
> "Dragon" <NoSpam_Baadil@hotmail.com> wrote in message
> news:%23vazi5HgEHA.3428@TK2MSFTNGP11.phx.gbl...
>> Hi,
>>
>> I am looking for some answers to the following questions regarding
>> Clustering on Win 2003.
>>
>> Is it possible to have the cluster check additional IP addresses (on the
>> network) before it decides that a failover is necessary?
>
> [JT] No. Cluster cannot be configured to check additional IP addresses
> before failing.
>
>>
>> I have a 2 node cluster in my lab and when I unplugged the network cable
>> (public) from one of the nodes, it did not failover but stayed online.
>> Any
>> guesses why?
>>
>
> [JT] Do you have teaming installed? Do you have any IP resources in MSCS
> owned by the node where you pulled the cable?
>
>> Should a node failover to the other node if the private link fails?
>>
>
> [JT] Maybe. If you have multiple networks and your public network is set
> to
> "mixed" mode, then you will not experience a failure. If you have your
> public network set to "client only" then your node that owns the quorum
> will
> remain online and the other node will shut itself down.
>
>> Can I add a custom script (bat or vbs) for the cluster to run
>> before/after
> a
>> failover?
>>
>
> [JT] You can setup a generic script/application in cluster. This
> script/app
> resource will run each time the group comes online. You can find more
> details in the following KB article:
> http://support.microsoft.com/?id=260527
>
>> Lastly, Could someone please recommend a good clustering book specific to
>> Win 2003 clustering?
>>
>
> [JT] I haven't read any so I can't make any recommendations.
>
>> Thank you.
>>
>>
>
>

Relevant Pages

  • Re: Unable to failover when public network cables are removed
    ... determining node failure and subsequent resource failover. ... > Can you provide a little more information here......Is the Public Network ... There is only 1 standard cluster group. ... There is no other resources. ...
    (microsoft.public.windows.server.clustering)
  • Re: file server clustering
    ... During the failover I get a message 'Delayed Write Failed'. ... You will have to declare all shares (cluster resources in this case, ... > I am building a clustered server that only provide drive access... ...
    (microsoft.public.windows.server.clustering)
  • Re: Why Cluster in a test Environment?
    ... If your apps are not failover aware, ... SQL Server 2000 then takes anywhere from 30 seconds to minutes before ... a cluster but not appear in a standalone server. ... A non-clustered environment would not allow accurate stress testing do ...
    (microsoft.public.sqlserver.clustering)
  • Re: Failed cluster node confusion!
    ... Blue exclamation marks usually means that the cluster service has terminated ... the second node did NOT failover the resources. ... of our nodes blue screened and the resources didn't failover. ...
    (microsoft.public.windows.server.clustering)
  • Re: cluster group
    ... > I need group 0 to be able to failover along with the cluster group when I ... But not when I place the resources in the group 0, ... >> access the data that is stored on it (e.g. IP address, Network Name, File ...
    (microsoft.public.windows.server.clustering)