All,
I've setup a Windows 2003 Enterprise Edition cluster of 3 nodes.
Everything is attached to a san (CX500).
Just installed SQL 2005 and all works fine.
Is it possible to have this cluster with 2 active nodes and 1 passive
node?
i've setup a drive (r:\) and it's online but only avaiable from 1
resource. the other nodes sees it but can't access it. I want to setup
a cluster where 2 nodes can access the drive (to share sql databases)
and 1 node access it when it failovers..
is this a good setup or not? should i use 2 or 4 nodes instead of 3?
Or is it possible to add a SQL cluster resources to the same storage?
Also is it possible to setup a load balanced sql 2005 cluster? where i
can have 3 active nodes load balanced and also failover when 1 node
goes down?
Hope someone can help me out..
Thanx in advance.
> Is it possible to have this cluster with 2 active nodes and 1 passive
> node?
Yes, but not in the way you want, you can create another SQL instance and
run this on the other node. Still this instance has its own databases and
its own disks.
> i've setup a drive (r:\) and it's online but only avaiable from 1
> resource. the other nodes sees it but can't access it. I want to setup
> a cluster where 2 nodes can access the drive (to share sql databases)
> and 1 node access it when it failovers..
No, at any given time only ONE node can access a disk ( the node where the
cluster resource group is online ). You may not access an NTFS volume from
more than one server at any given time. This is an NTFS limitation. Hence
clustering is called "shared nothing" cluster model.
> Also is it possible to setup a load balanced sql 2005 cluster? where i
> can have 3 active nodes load balanced and also failover when 1 node
> goes down?
Same as above, you can have multiple instances running, but each of these
instances have their own disks and databases.
> Hope someone can help me out..
> Thanx in advance.
>
Rgds,
Edwin.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment