Groups | Blog | Home
all groups > sql server clustering > february 2007 >

sql server clustering : sql 2005 active/active cluster


andyz
2/28/2007 7:16:08 PM
I have a consultant telling me that there is no such thing as an
active/active sql cluster. I want to install 2 seperate instances on 2
seperate sql 2005 servers in a cluster.

The consultant is telling me that this is active passive because only 1
instance is active at a time on 1 server. I do not beleive this to be correct
but I am no database expert. Can someone please give me some clsrity here..


Geoff N. Hiten
2/28/2007 10:51:15 PM
You and your consultant have your terminology crossed.

You want a multi-instance cluster in a 2x2 configuration. (2 instances on 2
nodes). The active and passive terminology refers to a specific SQL 7.0
clustering technology that is no longer relevant or even possible.

IMHO, if you and your consultant are butting heads over definitions, you
might want to rethink this relationship. I have lived on both sides of the
table and expect better either way.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP


[quoted text, click to view]
burt_king
3/1/2007 7:56:08 PM
A rose by any other name.....

You're correct active/active is two nodes, each with it's own instance.

Nothing is shared in this configuration... That means the data partitions
and the data on them....
--
databaseadmins.com
Remote DBA Services


[quoted text, click to view]
AddThis Social Bookmark Button