What will happen if one of the node down;
Create a cluster – clustertest.contso.com with 2 node :
SQL-C and SQL-D
Default Quorum : Node Majority
More information about quorum
WSFC Quorum Modes and Voting Configuration (SQL Server)http://msdn.microsoft.com/en-us/library/hh270280.aspx#QuorumModes
With Default Quorum (Node Majority) and 2 nodes cluster
Quorum Configuration warning
Node Majority - Warning: Failure of a node will cause the cluster to fail. Check the status of the nodes
Shutdown SQL-D, simulate SQL-D server fail
System event log at SQL-C
SQL Cluster is missing from Failover Cluster Manager
Bring SQL-D back online
Cluster service - Clustertest.Contso.com back online.
Cluster service will offline, if other node down.
Custer service will sustain with 0 node down.
No comments:
Post a Comment