RE: Cluster Configurations

Thanks for reply; if I may ask will those the following configuration seem
sound to you for 8-Node Cluster with 6A-2P.

Node 1: Default Instance -> Failover to Node 4
Node 2: Named Instance -> Failover to Node 4
Node 3: Named Instance -> Failover to Node 4
Node 5: Named Instance -> Failover to Node 8
Node 6: Named Instance -> Failover to Node 8
Node 7: Named Instance -> Failover to Node 8

So in worst case Node 4/8 could each have 3 instances running if everything
fails,

Thanks again for help.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Linchi Shea" wrote:

No, you cannot have two default SQL Server instances in the same cluster. So
your configuration A doesn't work.

Linchi

"Mohit K. Gupta" wrote:

Hi,

We are currently looking at setting up 3-Node Cluster with
Active/Active/Passive configuration. I am sorry clustering is my weakness
and I not very good at it, so if the question sounds wrong please let me know.

Configuration we are aiming for (Configuration A):
Node 1: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3
Node 2: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3

Configuration I was thinking we should do (Configruation B):
Node 1: Default Instance (SQL2005
-> Set Fail Over to Node 3
Node 2: Named Instance (NI01)
-> Set Fail Over to Node 3

Could someone please tell me if Configuration A is possible? Or do we have
to choose Configuration B as main route?

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/
.

Relevant Pages

  • RE: Cluster Configurations
    ... We have two nodes configured in an active/pasive, using a named instance. ... 'entsqlprod' with a virtual server of the same. ... I think we decided the 8-node configuration to better use the hardware. ... Default Instance -> Failover to Node 4 ...
    (microsoft.public.sqlserver.clustering)
  • RE: Cluster Configurations
    ... Default Instance -> Failover to Node 4 ... Named Instance -> Failover to Node 4 ... Active/Active/Passive configuration. ... -> Set to Fail Over to Node 3 ...
    (microsoft.public.sqlserver.clustering)
  • Re: [SLE] Looking for a book that describes highly available DHCP setups
    ... I'm looking for a book that explains reliable and manageable DHCP setups. ... it should cover installations with failover and load balancing configurations of dhcpd. ... Without such a second server, all clients would not work any more after the lease expired. ... I'm not interested in technology explanation and configuration examples. ...
    (SuSE)
  • Re: updating to 2003
    ... > i'm faced with the task of updating windows 2000 advanced server ... > (with 2 active directory/fileservers clustered together in failover ... > configuration). ...
    (microsoft.public.win2000.networking)
  • Re: CISCO ASA 5505 Failover
    ... I ended up setting the seconday back to the factory default settings ... I then uploaded the configuration from the primary ... I set the failover to be secondary (failover lan ... You can use any unused Ethernet interface on the device as the ...
    (comp.dcom.sys.cisco)
Loading