Re: Multiple Clusters with shared passive nodes



Sort of - I'd create all 5 servers as members of a single cluster, then set up 4 instances of SQL Server with cluster server member 1 configured to be able to run instance 1, member 2 to run instance 2, member 3 to run instance 3, member 4 to run instance 4, and member 5 to run instances 1 2 3 and 4.

While you are able to have cluster member 5 be the failover for all the other instances, there might be a better way to set which member servers can run each instance, but its not difficult to change this at a later date - it might not be an optimal configuration if all the instances are of different memory needs or if you want to handle a situation where more than one cluster member might be unavailable at a time.

Good luck,
Tony Sebion


"onefastmustang" <onefastmustang@xxxxxxxxx> wrote in message news:1128006737.120461.270030@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:


Is it possible to take 5 servers and make 4 individual clusters and
share the 5th server amongst all of them as the failover node? These
clusters would be running SQL 2000 and attached to a SAN enviroment.

.



Relevant Pages

  • Re: Connecting to cluster instance from .NET
    ... Virtual IP addresses for the cluster resource groups. ... SQL Server will listen on only those IP addresses ... IP addresses for each of the following cluster resource groups: ...
    (microsoft.public.sqlserver.clustering)
  • Re: Differences in clustered system dbs vs standalone system dbs
    ... rely on the SQL Server name, not the cluster or server name. ... >> - Stop SQL on the standalone server ...
    (microsoft.public.sqlserver.clustering)
  • Re: Request for information
    ... Two node Cluster for your mail and SQL. ... The under dog is DISK IOPS!! ... How to cluster Microsoft SQL Server 2005 by using ... Microsoft Virtual Server ...
    (microsoft.public.windows.server.clustering)
  • Re: Request for information
    ... The under dog is DISK IOPS!! ... So It is not only the hardware and software a cluster design / infrastructure design is more the a pile of boxes but use x64 where you can! ... How to cluster Microsoft SQL Server 2005 by using Microsoft Virtual Server ...
    (microsoft.public.windows.server.clustering)
  • Re: upgrading sql2k cluster to sql2005
    ... It ain't that simple for SQL Server. ... that databases get locked off in the current cluster and then properly ...
    (microsoft.public.sqlserver.clustering)