General discussion


sql cluster multiple instance

By analoggers ·
Can someone explain to me how SQL 2000 with multiple instance (active/active) clustering on Windows 2003 works?

Also, is there any way

I have an active/passive SQL cluster with a SAN right now and understand that. From what I've read it sounds like multiple nodes do not access the same resource simoultaneously but rather they have a local copy of a seperate instance. I must be mis-understanding this because it just doesn't make sense.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -


by analoggers In reply to sql cluster multiple inst ...

After posting this, I came to the realization that Microsoft doesn't offer true active/active SQL clustering like Oracle and MySQL. That's why they're calling it Multiple Instance because 2 nodes cannot access the same instance at the same time (which is what active/active clustering is). I am very disappointed.
Does anyone know of a 3rd party solution that would allow MS SQL clustering to work with active/active?

Related Discussions

Related Forums