Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Network Card Reset Triggers a Failover? Expand / Collapse
Author
Message
Posted Thursday, December 12, 2013 11:37 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 1:51 PM
Points: 30, Visits: 409
Hello,

We have a two-node active/active SQL Server 2008 Std Cluster on Windows 2008 on Production.

After a network maintenance, the network card (not heart-beat) of one node has no gateway ip. We want to fix it without causing a failover.

I assume when we set gateway ip, the network card will be reset, and the ip will be temporarily unavailable, then fail-over happens. Am I right?

Is there a way to play with dependencies not to initiate failover during fixing network card?

Thanks,

Kuzey
Post #1522438
Posted Thursday, December 12, 2013 7:35 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 11:37 PM
Points: 2,956, Visits: 2,563
Kuzey (12/12/2013)
Hello,

We have a two-node active/active SQL Server 2008 Std Cluster on Windows 2008 on Production.

After a network maintenance, the network card (not heart-beat) of one node has no gateway ip. We want to fix it without causing a failover.

I assume when we set gateway ip, the network card will be reset, and the ip will be temporarily unavailable, then fail-over happens. Am I right?

Is there a way to play with dependencies not to initiate failover during fixing network card?

Thanks,

Kuzey


Since you are not changing anything on the NIC used for the heartbeat, you should not get a failover. I would expect that the users may get a break because their connections may be severed but the failover wouldn't be initiated because the standby node can still communicate with the active node.



Post #1522551
Posted Thursday, December 12, 2013 9:55 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
Off the top of my head there will probably not be a fail-over. Your users may experience some lost connections.

But as I think about it I don't think the network card will be reset at all, the default gateway is a function of routing which is handled at a windows layer and not the NIC specifically. If affects the routing tables.. So the more I think about it the less I think you will have an issue.

CEWII
Post #1522566
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse