Hi all,
Background - my current client wants to move to clustering, they are on Standard Edition therefore only likely to be able to use 2-node clusters. We have approx. 150k executions/day (9-5), most RW, proposed topology will be N+1, in our case 3 clusters of 2 nodes each, a load balancer splits traffic evenly across 2 clusters, if both nodes fail for a cluster then a load balancer will send requests to the 3rd cluster. All clusters are on the same subnet (I hope to configure a fourth cluster offsite, logshipped, for DR).
I want to help them implement these clusters, and reduce the momentary downtime they would experience if one of the cluster's nodes suffered a failure, and the cluster fails over, to the minimum possible with the above topology. I know with Windows 2K8/2012 you can configure the delay between heartbeats and the number of hearbeats attempted before the cluster deems the node to have failed, and fail over to the other.
Would appreciate advice about delay/# of attempts to a minimum.
Cheers,
JB