Wednesday, March 28, 2012

Is it possible to install the third instance?

Hi everyone,
I have active-passive two node cluster server, it's already installed two
instances with associated two network names and IP addresses. Is there
possible to install the third instance in this cluster server, if give the
specific network name and IP address but no physical node 3?
Regards,
-Chen
Yes. The Active-Passive, Active-Active nomenclature is left over from SQL
7.0 and no longer accurately represents the clustering capabilities of SQL
Server 2000. The short version is you can have up to 16 instances on a
cluster, regardless of the number of nodes. You can choose which instances
should be on which nodes during normal operating conditions. You do have to
have a unique network name, IP address, and disk resource for each instance.
You also need to make sure you have enough physical resources (memory, CPU,
IO capacity) on each node to handle the work load, even during a failover
condition.
The correct current terms are single-instance and multiple-instance
clusters.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:430C357E-407A-4F73-8764-DDAFD3203DC2@.microsoft.com...
> Hi everyone,
> I have active-passive two node cluster server, it's already installed two
> instances with associated two network names and IP addresses. Is there
> possible to install the third instance in this cluster server, if give the
> specific network name and IP address but no physical node 3?
> Regards,
> -Chen
>
sql

No comments:

Post a Comment