Tuesday, March 20, 2012

3 server active cluster

Does anyone have any thoughts on how to setup and configure a SQL cluster of
three ACTIVE servers. I'm familiar with a 2 node, active/passive and
active/active cluster but have not seen much published on a 3 or 4 node
active(n) cluster. Thanks! - Mike
Hi
No different to a 2 node. The big descision you have to make is onto which
machine an instance can fail over. If you were to allow enough resouces for
one machine to handle all 3 server's instances, you have a lot of unused
resources.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike" wrote:

> Does anyone have any thoughts on how to setup and configure a SQL cluster of
> three ACTIVE servers. I'm familiar with a 2 node, active/passive and
> active/active cluster but have not seen much published on a 3 or 4 node
> active(n) cluster. Thanks! - Mike
|||I have another 3 server cluster. I want an active/passive and then a dev as a last resort for failover. The dev box is going to have either VMWare or Virtual Server because I am using this as a last resort for failover for Exchange, too.
You can call me crazy but will this work?
Kami

Quote:

Originally posted by Mike Epprecht (SQL MVP)
Hi
No different to a 2 node. The big descision you have to make is onto which
machine an instance can fail over. If you were to allow enough resouces for
one machine to handle all 3 server's instances, you have a lot of unused
resources.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike" wrote:

> Does anyone have any thoughts on how to setup and configure a SQL cluster of
> three ACTIVE servers. I'm familiar with a 2 node, active/passive and
> active/active cluster but have not seen much published on a 3 or 4 node
> active(n) cluster. Thanks! - Mike

No comments:

Post a Comment