My company currently has a 2 Node SQL 2008 Active / Passive cluster. Due to the sensitivity and ugency of our industry, we have to maintain a 100% uptime for our clients. The issue here is that we cannot do any maintenance that involves failovering the cluster
(patching, SPs, etc), because of the time it takes to failover (even a few seconds is critical).
We are considering going to a 3 Node Active / Active / Passive cluster, with the theory that since one Node will always be active, we can failover to the passive Node without any disruption. However, we're not sure if this would be the case, and if
it isn't, would there be something we can do instead to keep uptime at 100% w/o the risk of our environments being outdated?
Thank you all in advance,
Nick Gargano, Sr. DBA
View Complete Post