Hi, we have a 2 node cluster running Server 2003 with a single instance of
SQL 2005. We are looking to migrate as many apps as possible to SQL 2005,
but will likely need to keep a SQL2000 instance. In addition, we want to
isolate some of the SQL databases that are web accessible and will setup an
instance for that. So, are there any reservations running this:
(2) SQL 2005 instances
(1) SQL 2000 instance
on the same cluster? We have Enterprise edition of the OS and SQL Server.
We plan to run a multi instance setup with an active and passive node so all
3 instances would run on the same node. The hardware should be able to
handle all 3 instances.
Also, any special steps to install SQL service packs in this scenario?
Thanks,
TJ
TJ,
There is no issue running SQL 2000 and SQL 2005 on the same machine. I have
done so in Production with no issues. Infact I currently have SQL 2000, SQL
2005 and SQL 2008 installed on my laptop side by side.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration /
Microsoft Office SharePoint Server 2007: Configuration)
MCITP (dbadmin, dbdev)
"TJ" wrote:
> Hi, we have a 2 node cluster running Server 2003 with a single instance of
> SQL 2005. We are looking to migrate as many apps as possible to SQL 2005,
> but will likely need to keep a SQL2000 instance. In addition, we want to
> isolate some of the SQL databases that are web accessible and will setup an
> instance for that. So, are there any reservations running this:
> (2) SQL 2005 instances
> (1) SQL 2000 instance
> on the same cluster? We have Enterprise edition of the OS and SQL Server.
> We plan to run a multi instance setup with an active and passive node so all
> 3 instances would run on the same node. The hardware should be able to
> handle all 3 instances.
> Also, any special steps to install SQL service packs in this scenario?
> Thanks,
> TJ
>
Showing posts with label node. Show all posts
Showing posts with label node. Show all posts
Friday, March 30, 2012
Wednesday, March 28, 2012
Multiple instances in SQL Cluster
Hi All,
I have joined a company recently. They are having mutiple servers of SQL
Server 2000. And one of them is a two node SQL server cluster. It is having
a Active/Active configuration. That means on one node we have one instance
and other have the second instance with failover on to each other. I am
planning to install a third instance on that cluster.
But I am totally confused at online help that says, I cannot have more than
one instance per server in a cluster, at the same time it says -we can have
upto 16 servers in cluster. What does it mean? Can't I have more than two
instances with two nodes?
Thanks a lot,
VM
you can have up to 16 instances installed but even by adding the 3rd you
have to be careful that if a node fails the the remaining Node has enough
memory to run all instances. See Memory Configuration section below
http://www.microsoft.com/technet/pro.../failclus.mspx
cheers,
Andy.
"VM" <VM@.discussions.microsoft.com> wrote in message
news:AAC5F30B-B27B-489E-9311-DD9E18F169D0@.microsoft.com...
> Hi All,
> I have joined a company recently. They are having mutiple servers of SQL
> Server 2000. And one of them is a two node SQL server cluster. It is
> having
> a Active/Active configuration. That means on one node we have one
> instance
> and other have the second instance with failover on to each other. I am
> planning to install a third instance on that cluster.
> But I am totally confused at online help that says, I cannot have more
> than
> one instance per server in a cluster, at the same time it says -we can
> have
> upto 16 servers in cluster. What does it mean? Can't I have more than
> two
> instances with two nodes?
> Thanks a lot,
> VM
|||> But I am totally confused at online help that says, I cannot have more than
> one instance per server in a cluster, at the same time it says -we can have
> upto 16 servers in cluster. What does it mean? Can't I have more than two
That means you can have one SQL instance per virtual server in a cluster,
and a cluster cna have multiple virtual servers. A virtual server in this
context refers to an IP address and its related network name, and after you
have installed the SQL instance, that IP and network name will be what you
use to connect to the SQL instance. If you examine the cluster using Cluster
Administrator, each virtual server is wrapped up in a resource group. It's
okay to have multiple IPs and network names for the same virtual server. In a
cluster, you can have multiple virtual servers in their separate groups. For
SQL2000, Microsoft supports up to 16 such cluster resource groups (i.e. 16
SQL virtual servers), each of which supports a separate SQL instance.
In theory, each cluster virtual server could support multiple SQL instances
by identifying the SQL instances with different ports. But that is not how
SQL2000 is actually implemented by Microsoft in a Windows cluster.
Linchi
"VM" wrote:
> Hi All,
> I have joined a company recently. They are having mutiple servers of SQL
> Server 2000. And one of them is a two node SQL server cluster. It is having
> a Active/Active configuration. That means on one node we have one instance
> and other have the second instance with failover on to each other. I am
> planning to install a third instance on that cluster.
> But I am totally confused at online help that says, I cannot have more than
> one instance per server in a cluster, at the same time it says -we can have
> upto 16 servers in cluster. What does it mean? Can't I have more than two
> instances with two nodes?
> Thanks a lot,
> VM
|||Linchi and Andy,
Thankyou so much for your replies. Not it makes more sense to me.
Warm regards,
VM
"Linchi Shea" wrote:
[vbcol=seagreen]
> That means you can have one SQL instance per virtual server in a cluster,
> and a cluster cna have multiple virtual servers. A virtual server in this
> context refers to an IP address and its related network name, and after you
> have installed the SQL instance, that IP and network name will be what you
> use to connect to the SQL instance. If you examine the cluster using Cluster
> Administrator, each virtual server is wrapped up in a resource group. It's
> okay to have multiple IPs and network names for the same virtual server. In a
> cluster, you can have multiple virtual servers in their separate groups. For
> SQL2000, Microsoft supports up to 16 such cluster resource groups (i.e. 16
> SQL virtual servers), each of which supports a separate SQL instance.
> In theory, each cluster virtual server could support multiple SQL instances
> by identifying the SQL instances with different ports. But that is not how
> SQL2000 is actually implemented by Microsoft in a Windows cluster.
> Linchi
> "VM" wrote:
I have joined a company recently. They are having mutiple servers of SQL
Server 2000. And one of them is a two node SQL server cluster. It is having
a Active/Active configuration. That means on one node we have one instance
and other have the second instance with failover on to each other. I am
planning to install a third instance on that cluster.
But I am totally confused at online help that says, I cannot have more than
one instance per server in a cluster, at the same time it says -we can have
upto 16 servers in cluster. What does it mean? Can't I have more than two
instances with two nodes?
Thanks a lot,
VM
you can have up to 16 instances installed but even by adding the 3rd you
have to be careful that if a node fails the the remaining Node has enough
memory to run all instances. See Memory Configuration section below
http://www.microsoft.com/technet/pro.../failclus.mspx
cheers,
Andy.
"VM" <VM@.discussions.microsoft.com> wrote in message
news:AAC5F30B-B27B-489E-9311-DD9E18F169D0@.microsoft.com...
> Hi All,
> I have joined a company recently. They are having mutiple servers of SQL
> Server 2000. And one of them is a two node SQL server cluster. It is
> having
> a Active/Active configuration. That means on one node we have one
> instance
> and other have the second instance with failover on to each other. I am
> planning to install a third instance on that cluster.
> But I am totally confused at online help that says, I cannot have more
> than
> one instance per server in a cluster, at the same time it says -we can
> have
> upto 16 servers in cluster. What does it mean? Can't I have more than
> two
> instances with two nodes?
> Thanks a lot,
> VM
|||> But I am totally confused at online help that says, I cannot have more than
> one instance per server in a cluster, at the same time it says -we can have
> upto 16 servers in cluster. What does it mean? Can't I have more than two
That means you can have one SQL instance per virtual server in a cluster,
and a cluster cna have multiple virtual servers. A virtual server in this
context refers to an IP address and its related network name, and after you
have installed the SQL instance, that IP and network name will be what you
use to connect to the SQL instance. If you examine the cluster using Cluster
Administrator, each virtual server is wrapped up in a resource group. It's
okay to have multiple IPs and network names for the same virtual server. In a
cluster, you can have multiple virtual servers in their separate groups. For
SQL2000, Microsoft supports up to 16 such cluster resource groups (i.e. 16
SQL virtual servers), each of which supports a separate SQL instance.
In theory, each cluster virtual server could support multiple SQL instances
by identifying the SQL instances with different ports. But that is not how
SQL2000 is actually implemented by Microsoft in a Windows cluster.
Linchi
"VM" wrote:
> Hi All,
> I have joined a company recently. They are having mutiple servers of SQL
> Server 2000. And one of them is a two node SQL server cluster. It is having
> a Active/Active configuration. That means on one node we have one instance
> and other have the second instance with failover on to each other. I am
> planning to install a third instance on that cluster.
> But I am totally confused at online help that says, I cannot have more than
> one instance per server in a cluster, at the same time it says -we can have
> upto 16 servers in cluster. What does it mean? Can't I have more than two
> instances with two nodes?
> Thanks a lot,
> VM
|||Linchi and Andy,
Thankyou so much for your replies. Not it makes more sense to me.
Warm regards,
VM
"Linchi Shea" wrote:
[vbcol=seagreen]
> That means you can have one SQL instance per virtual server in a cluster,
> and a cluster cna have multiple virtual servers. A virtual server in this
> context refers to an IP address and its related network name, and after you
> have installed the SQL instance, that IP and network name will be what you
> use to connect to the SQL instance. If you examine the cluster using Cluster
> Administrator, each virtual server is wrapped up in a resource group. It's
> okay to have multiple IPs and network names for the same virtual server. In a
> cluster, you can have multiple virtual servers in their separate groups. For
> SQL2000, Microsoft supports up to 16 such cluster resource groups (i.e. 16
> SQL virtual servers), each of which supports a separate SQL instance.
> In theory, each cluster virtual server could support multiple SQL instances
> by identifying the SQL instances with different ports. But that is not how
> SQL2000 is actually implemented by Microsoft in a Windows cluster.
> Linchi
> "VM" wrote:
Multiple instances in SQL Cluster
Hi All,
I have joined a company recently. They are having mutiple servers of SQL
Server 2000. And one of them is a two node SQL server cluster. It is having
a Active/Active configuration. That means on one node we have one instance
and other have the second instance with failover on to each other. I am
planning to install a third instance on that cluster.
But I am totally confused at online help that says, I cannot have more than
one instance per server in a cluster, at the same time it says -we can have
upto 16 servers in cluster. What does it mean? Can't I have more than two
instances with two nodes?
Thanks a lot,
VMyou can have up to 16 instances installed but even by adding the 3rd you
have to be careful that if a node fails the the remaining Node has enough
memory to run all instances. See Memory Configuration section below
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
cheers,
Andy.
"VM" <VM@.discussions.microsoft.com> wrote in message
news:AAC5F30B-B27B-489E-9311-DD9E18F169D0@.microsoft.com...
> Hi All,
> I have joined a company recently. They are having mutiple servers of SQL
> Server 2000. And one of them is a two node SQL server cluster. It is
> having
> a Active/Active configuration. That means on one node we have one
> instance
> and other have the second instance with failover on to each other. I am
> planning to install a third instance on that cluster.
> But I am totally confused at online help that says, I cannot have more
> than
> one instance per server in a cluster, at the same time it says -we can
> have
> upto 16 servers in cluster. What does it mean? Can't I have more than
> two
> instances with two nodes?
> Thanks a lot,
> VM|||> But I am totally confused at online help that says, I cannot have more than
> one instance per server in a cluster, at the same time it says -we can have
> upto 16 servers in cluster. What does it mean? Can't I have more than two
That means you can have one SQL instance per virtual server in a cluster,
and a cluster cna have multiple virtual servers. A virtual server in this
context refers to an IP address and its related network name, and after you
have installed the SQL instance, that IP and network name will be what you
use to connect to the SQL instance. If you examine the cluster using Cluster
Administrator, each virtual server is wrapped up in a resource group. It's
okay to have multiple IPs and network names for the same virtual server. In a
cluster, you can have multiple virtual servers in their separate groups. For
SQL2000, Microsoft supports up to 16 such cluster resource groups (i.e. 16
SQL virtual servers), each of which supports a separate SQL instance.
In theory, each cluster virtual server could support multiple SQL instances
by identifying the SQL instances with different ports. But that is not how
SQL2000 is actually implemented by Microsoft in a Windows cluster.
Linchi
"VM" wrote:
> Hi All,
> I have joined a company recently. They are having mutiple servers of SQL
> Server 2000. And one of them is a two node SQL server cluster. It is having
> a Active/Active configuration. That means on one node we have one instance
> and other have the second instance with failover on to each other. I am
> planning to install a third instance on that cluster.
> But I am totally confused at online help that says, I cannot have more than
> one instance per server in a cluster, at the same time it says -we can have
> upto 16 servers in cluster. What does it mean? Can't I have more than two
> instances with two nodes?
> Thanks a lot,
> VM|||Linchi and Andy,
Thankyou so much for your replies. Not it makes more sense to me.
Warm regards,
VM
"Linchi Shea" wrote:
> > But I am totally confused at online help that says, I cannot have more than
> > one instance per server in a cluster, at the same time it says -we can have
> > upto 16 servers in cluster. What does it mean? Can't I have more than two
> That means you can have one SQL instance per virtual server in a cluster,
> and a cluster cna have multiple virtual servers. A virtual server in this
> context refers to an IP address and its related network name, and after you
> have installed the SQL instance, that IP and network name will be what you
> use to connect to the SQL instance. If you examine the cluster using Cluster
> Administrator, each virtual server is wrapped up in a resource group. It's
> okay to have multiple IPs and network names for the same virtual server. In a
> cluster, you can have multiple virtual servers in their separate groups. For
> SQL2000, Microsoft supports up to 16 such cluster resource groups (i.e. 16
> SQL virtual servers), each of which supports a separate SQL instance.
> In theory, each cluster virtual server could support multiple SQL instances
> by identifying the SQL instances with different ports. But that is not how
> SQL2000 is actually implemented by Microsoft in a Windows cluster.
> Linchi
> "VM" wrote:
> > Hi All,
> >
> > I have joined a company recently. They are having mutiple servers of SQL
> > Server 2000. And one of them is a two node SQL server cluster. It is having
> > a Active/Active configuration. That means on one node we have one instance
> > and other have the second instance with failover on to each other. I am
> > planning to install a third instance on that cluster.
> >
> > But I am totally confused at online help that says, I cannot have more than
> > one instance per server in a cluster, at the same time it says -we can have
> > upto 16 servers in cluster. What does it mean? Can't I have more than two
> > instances with two nodes?
> >
> > Thanks a lot,
> > VMsql
I have joined a company recently. They are having mutiple servers of SQL
Server 2000. And one of them is a two node SQL server cluster. It is having
a Active/Active configuration. That means on one node we have one instance
and other have the second instance with failover on to each other. I am
planning to install a third instance on that cluster.
But I am totally confused at online help that says, I cannot have more than
one instance per server in a cluster, at the same time it says -we can have
upto 16 servers in cluster. What does it mean? Can't I have more than two
instances with two nodes?
Thanks a lot,
VMyou can have up to 16 instances installed but even by adding the 3rd you
have to be careful that if a node fails the the remaining Node has enough
memory to run all instances. See Memory Configuration section below
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
cheers,
Andy.
"VM" <VM@.discussions.microsoft.com> wrote in message
news:AAC5F30B-B27B-489E-9311-DD9E18F169D0@.microsoft.com...
> Hi All,
> I have joined a company recently. They are having mutiple servers of SQL
> Server 2000. And one of them is a two node SQL server cluster. It is
> having
> a Active/Active configuration. That means on one node we have one
> instance
> and other have the second instance with failover on to each other. I am
> planning to install a third instance on that cluster.
> But I am totally confused at online help that says, I cannot have more
> than
> one instance per server in a cluster, at the same time it says -we can
> have
> upto 16 servers in cluster. What does it mean? Can't I have more than
> two
> instances with two nodes?
> Thanks a lot,
> VM|||> But I am totally confused at online help that says, I cannot have more than
> one instance per server in a cluster, at the same time it says -we can have
> upto 16 servers in cluster. What does it mean? Can't I have more than two
That means you can have one SQL instance per virtual server in a cluster,
and a cluster cna have multiple virtual servers. A virtual server in this
context refers to an IP address and its related network name, and after you
have installed the SQL instance, that IP and network name will be what you
use to connect to the SQL instance. If you examine the cluster using Cluster
Administrator, each virtual server is wrapped up in a resource group. It's
okay to have multiple IPs and network names for the same virtual server. In a
cluster, you can have multiple virtual servers in their separate groups. For
SQL2000, Microsoft supports up to 16 such cluster resource groups (i.e. 16
SQL virtual servers), each of which supports a separate SQL instance.
In theory, each cluster virtual server could support multiple SQL instances
by identifying the SQL instances with different ports. But that is not how
SQL2000 is actually implemented by Microsoft in a Windows cluster.
Linchi
"VM" wrote:
> Hi All,
> I have joined a company recently. They are having mutiple servers of SQL
> Server 2000. And one of them is a two node SQL server cluster. It is having
> a Active/Active configuration. That means on one node we have one instance
> and other have the second instance with failover on to each other. I am
> planning to install a third instance on that cluster.
> But I am totally confused at online help that says, I cannot have more than
> one instance per server in a cluster, at the same time it says -we can have
> upto 16 servers in cluster. What does it mean? Can't I have more than two
> instances with two nodes?
> Thanks a lot,
> VM|||Linchi and Andy,
Thankyou so much for your replies. Not it makes more sense to me.
Warm regards,
VM
"Linchi Shea" wrote:
> > But I am totally confused at online help that says, I cannot have more than
> > one instance per server in a cluster, at the same time it says -we can have
> > upto 16 servers in cluster. What does it mean? Can't I have more than two
> That means you can have one SQL instance per virtual server in a cluster,
> and a cluster cna have multiple virtual servers. A virtual server in this
> context refers to an IP address and its related network name, and after you
> have installed the SQL instance, that IP and network name will be what you
> use to connect to the SQL instance. If you examine the cluster using Cluster
> Administrator, each virtual server is wrapped up in a resource group. It's
> okay to have multiple IPs and network names for the same virtual server. In a
> cluster, you can have multiple virtual servers in their separate groups. For
> SQL2000, Microsoft supports up to 16 such cluster resource groups (i.e. 16
> SQL virtual servers), each of which supports a separate SQL instance.
> In theory, each cluster virtual server could support multiple SQL instances
> by identifying the SQL instances with different ports. But that is not how
> SQL2000 is actually implemented by Microsoft in a Windows cluster.
> Linchi
> "VM" wrote:
> > Hi All,
> >
> > I have joined a company recently. They are having mutiple servers of SQL
> > Server 2000. And one of them is a two node SQL server cluster. It is having
> > a Active/Active configuration. That means on one node we have one instance
> > and other have the second instance with failover on to each other. I am
> > planning to install a third instance on that cluster.
> >
> > But I am totally confused at online help that says, I cannot have more than
> > one instance per server in a cluster, at the same time it says -we can have
> > upto 16 servers in cluster. What does it mean? Can't I have more than two
> > instances with two nodes?
> >
> > Thanks a lot,
> > VMsql
Multiple instances in SQL Cluster
Hi All,
I have joined a company recently. They are having mutiple servers of SQL
Server 2000. And one of them is a two node SQL server cluster. It is havin
g
a Active/Active configuration. That means on one node we have one instance
and other have the second instance with failover on to each other. I am
planning to install a third instance on that cluster.
But I am totally confused at online help that says, I cannot have more than
one instance per server in a cluster, at the same time it says -we can have
upto 16 servers in cluster. What does it mean? Can't I have more than two
instances with two nodes?
Thanks a lot,
VMyou can have up to 16 instances installed but even by adding the 3rd you
have to be careful that if a node fails the the remaining Node has enough
memory to run all instances. See Memory Configuration section below
http://www.microsoft.com/technet/pr...n/failclus.mspx
cheers,
Andy.
"VM" <VM@.discussions.microsoft.com> wrote in message
news:AAC5F30B-B27B-489E-9311-DD9E18F169D0@.microsoft.com...
> Hi All,
> I have joined a company recently. They are having mutiple servers of SQL
> Server 2000. And one of them is a two node SQL server cluster. It is
> having
> a Active/Active configuration. That means on one node we have one
> instance
> and other have the second instance with failover on to each other. I am
> planning to install a third instance on that cluster.
> But I am totally confused at online help that says, I cannot have more
> than
> one instance per server in a cluster, at the same time it says -we can
> have
> upto 16 servers in cluster. What does it mean? Can't I have more than
> two
> instances with two nodes?
> Thanks a lot,
> VM|||> But I am totally confused at online help that says, I cannot have more than">
> one instance per server in a cluster, at the same time it says -we can hav
e
> upto 16 servers in cluster. What does it mean? Can't I have more than two[/vbcol
]
That means you can have one SQL instance per virtual server in a cluster,
and a cluster cna have multiple virtual servers. A virtual server in this
context refers to an IP address and its related network name, and after you
have installed the SQL instance, that IP and network name will be what you
use to connect to the SQL instance. If you examine the cluster using Cluster
Administrator, each virtual server is wrapped up in a resource group. It's
okay to have multiple IPs and network names for the same virtual server. In
a
cluster, you can have multiple virtual servers in their separate groups. For
SQL2000, Microsoft supports up to 16 such cluster resource groups (i.e. 16
SQL virtual servers), each of which supports a separate SQL instance.
In theory, each cluster virtual server could support multiple SQL instances
by identifying the SQL instances with different ports. But that is not how
SQL2000 is actually implemented by Microsoft in a Windows cluster.
Linchi
"VM" wrote:
[vbcol=seagreen]
> Hi All,
> I have joined a company recently. They are having mutiple servers of SQL
> Server 2000. And one of them is a two node SQL server cluster. It is hav
ing
> a Active/Active configuration. That means on one node we have one instanc
e
> and other have the second instance with failover on to each other. I am
> planning to install a third instance on that cluster.
> But I am totally confused at online help that says, I cannot have more tha
n
> one instance per server in a cluster, at the same time it says -we can hav
e
> upto 16 servers in cluster. What does it mean? Can't I have more than tw
o
> instances with two nodes?
> Thanks a lot,
> VM|||Linchi and Andy,
Thankyou so much for your replies. Not it makes more sense to me.
Warm regards,
VM
"Linchi Shea" wrote:
[vbcol=seagreen]
> That means you can have one SQL instance per virtual server in a cluster,
> and a cluster cna have multiple virtual servers. A virtual server in this
> context refers to an IP address and its related network name, and after yo
u
> have installed the SQL instance, that IP and network name will be what you
> use to connect to the SQL instance. If you examine the cluster using Clust
er
> Administrator, each virtual server is wrapped up in a resource group. It's
> okay to have multiple IPs and network names for the same virtual server. I
n a
> cluster, you can have multiple virtual servers in their separate groups. F
or
> SQL2000, Microsoft supports up to 16 such cluster resource groups (i.e. 16
> SQL virtual servers), each of which supports a separate SQL instance.
> In theory, each cluster virtual server could support multiple SQL instance
s
> by identifying the SQL instances with different ports. But that is not how
> SQL2000 is actually implemented by Microsoft in a Windows cluster.
> Linchi
> "VM" wrote:
>
I have joined a company recently. They are having mutiple servers of SQL
Server 2000. And one of them is a two node SQL server cluster. It is havin
g
a Active/Active configuration. That means on one node we have one instance
and other have the second instance with failover on to each other. I am
planning to install a third instance on that cluster.
But I am totally confused at online help that says, I cannot have more than
one instance per server in a cluster, at the same time it says -we can have
upto 16 servers in cluster. What does it mean? Can't I have more than two
instances with two nodes?
Thanks a lot,
VMyou can have up to 16 instances installed but even by adding the 3rd you
have to be careful that if a node fails the the remaining Node has enough
memory to run all instances. See Memory Configuration section below
http://www.microsoft.com/technet/pr...n/failclus.mspx
cheers,
Andy.
"VM" <VM@.discussions.microsoft.com> wrote in message
news:AAC5F30B-B27B-489E-9311-DD9E18F169D0@.microsoft.com...
> Hi All,
> I have joined a company recently. They are having mutiple servers of SQL
> Server 2000. And one of them is a two node SQL server cluster. It is
> having
> a Active/Active configuration. That means on one node we have one
> instance
> and other have the second instance with failover on to each other. I am
> planning to install a third instance on that cluster.
> But I am totally confused at online help that says, I cannot have more
> than
> one instance per server in a cluster, at the same time it says -we can
> have
> upto 16 servers in cluster. What does it mean? Can't I have more than
> two
> instances with two nodes?
> Thanks a lot,
> VM|||> But I am totally confused at online help that says, I cannot have more than">
> one instance per server in a cluster, at the same time it says -we can hav
e
> upto 16 servers in cluster. What does it mean? Can't I have more than two[/vbcol
]
That means you can have one SQL instance per virtual server in a cluster,
and a cluster cna have multiple virtual servers. A virtual server in this
context refers to an IP address and its related network name, and after you
have installed the SQL instance, that IP and network name will be what you
use to connect to the SQL instance. If you examine the cluster using Cluster
Administrator, each virtual server is wrapped up in a resource group. It's
okay to have multiple IPs and network names for the same virtual server. In
a
cluster, you can have multiple virtual servers in their separate groups. For
SQL2000, Microsoft supports up to 16 such cluster resource groups (i.e. 16
SQL virtual servers), each of which supports a separate SQL instance.
In theory, each cluster virtual server could support multiple SQL instances
by identifying the SQL instances with different ports. But that is not how
SQL2000 is actually implemented by Microsoft in a Windows cluster.
Linchi
"VM" wrote:
[vbcol=seagreen]
> Hi All,
> I have joined a company recently. They are having mutiple servers of SQL
> Server 2000. And one of them is a two node SQL server cluster. It is hav
ing
> a Active/Active configuration. That means on one node we have one instanc
e
> and other have the second instance with failover on to each other. I am
> planning to install a third instance on that cluster.
> But I am totally confused at online help that says, I cannot have more tha
n
> one instance per server in a cluster, at the same time it says -we can hav
e
> upto 16 servers in cluster. What does it mean? Can't I have more than tw
o
> instances with two nodes?
> Thanks a lot,
> VM|||Linchi and Andy,
Thankyou so much for your replies. Not it makes more sense to me.
Warm regards,
VM
"Linchi Shea" wrote:
[vbcol=seagreen]
> That means you can have one SQL instance per virtual server in a cluster,
> and a cluster cna have multiple virtual servers. A virtual server in this
> context refers to an IP address and its related network name, and after yo
u
> have installed the SQL instance, that IP and network name will be what you
> use to connect to the SQL instance. If you examine the cluster using Clust
er
> Administrator, each virtual server is wrapped up in a resource group. It's
> okay to have multiple IPs and network names for the same virtual server. I
n a
> cluster, you can have multiple virtual servers in their separate groups. F
or
> SQL2000, Microsoft supports up to 16 such cluster resource groups (i.e. 16
> SQL virtual servers), each of which supports a separate SQL instance.
> In theory, each cluster virtual server could support multiple SQL instance
s
> by identifying the SQL instances with different ports. But that is not how
> SQL2000 is actually implemented by Microsoft in a Windows cluster.
> Linchi
> "VM" wrote:
>
Monday, March 26, 2012
Multiple Instance cluster
Hi,
I am going to setup 2 instances of SQL Server 2000 in a 2-nodes clustered
environment with each instance running on each node in a normal operation.
Each node will act as a failover of the other node. I am not very certain
that I understand how to do it. Here's what I am going to do.
1) Setup the 2 nodes cluster.
2) Create 2 SQL Cluster group2 with each group having their own resources
(e.g. disk, IP, DTC, etc)
3) Install the 1st instance and assign it with a virtual name.
4) Install the 2nd instance and assgin another virtual name.
Do I miss out anything or anything that I need to take note?
Thanks You,
Alex
Looks like you are well on your way. Make sure and set the correct
preferred nodes order on the cluster administration tool so that each
instance knows where it wants to live under 'normal' operating conditions.
Also, make sure you don't overcommit memory. You will need to leave enough
memory so you can 'stack' both instances on a single server in a failure
condition.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Alex" <Yukon@.nospam.nospam> wrote in message
news:%231IbTEUrEHA.3848@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I am going to setup 2 instances of SQL Server 2000 in a 2-nodes clustered
> environment with each instance running on each node in a normal operation.
> Each node will act as a failover of the other node. I am not very certain
> that I understand how to do it. Here's what I am going to do.
> 1) Setup the 2 nodes cluster.
> 2) Create 2 SQL Cluster group2 with each group having their own resources
> (e.g. disk, IP, DTC, etc)
> 3) Install the 1st instance and assign it with a virtual name.
> 4) Install the 2nd instance and assgin another virtual name.
> Do I miss out anything or anything that I need to take note?
>
> Thanks You,
> Alex
>
|||Thanks for the advice :o)
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uwY11RUrEHA.3288@.TK2MSFTNGP12.phx.gbl...
> Looks like you are well on your way. Make sure and set the correct
> preferred nodes order on the cluster administration tool so that each
> instance knows where it wants to live under 'normal' operating conditions.
> Also, make sure you don't overcommit memory. You will need to leave
> enough
> memory so you can 'stack' both instances on a single server in a failure
> condition.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Alex" <Yukon@.nospam.nospam> wrote in message
> news:%231IbTEUrEHA.3848@.TK2MSFTNGP14.phx.gbl...
>
|||Hi,
FIrst of all, I would show my gratidute for MVP Geoff N. Hiten's
suggestions!
Additionally, I would love to show some useful documents for your reference
and hope this helps
SQL Server 2000 Failover Clustering White Paper
http://www.microsoft.com/technet/pro.../failclus.mspx
Support WebCast: Introduction to Microsoft SQL Server 2000 Clustering
http://support.microsoft.com/default...b;en-us;325106
INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
http://support.microsoft.com/?id=260758
Installation order for SQL Server 2000 Enterprise Edition on Microsoft
Cluster Server
http://support.microsoft.com/?id=243218
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Thanks Mingqing.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:jBO9LobrEHA.2500@.cpmsftngxa06.phx.gbl...
> Hi,
> FIrst of all, I would show my gratidute for MVP Geoff N. Hiten's
> suggestions!
> Additionally, I would love to show some useful documents for your
> reference
> and hope this helps
> SQL Server 2000 Failover Clustering White Paper
> http://www.microsoft.com/technet/pro.../failclus.mspx
> Support WebCast: Introduction to Microsoft SQL Server 2000 Clustering
> http://support.microsoft.com/default...b;en-us;325106
> INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
> http://support.microsoft.com/?id=260758
> Installation order for SQL Server 2000 Enterprise Edition on Microsoft
> Cluster Server
> http://support.microsoft.com/?id=243218
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||Hi Alex,
Thanks for your prompt updates!
If you encountered any questions or concerns on setup or configuration
multiple instances clustering environment. Don't hesitate to let me know.
We are always here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
I am going to setup 2 instances of SQL Server 2000 in a 2-nodes clustered
environment with each instance running on each node in a normal operation.
Each node will act as a failover of the other node. I am not very certain
that I understand how to do it. Here's what I am going to do.
1) Setup the 2 nodes cluster.
2) Create 2 SQL Cluster group2 with each group having their own resources
(e.g. disk, IP, DTC, etc)
3) Install the 1st instance and assign it with a virtual name.
4) Install the 2nd instance and assgin another virtual name.
Do I miss out anything or anything that I need to take note?
Thanks You,
Alex
Looks like you are well on your way. Make sure and set the correct
preferred nodes order on the cluster administration tool so that each
instance knows where it wants to live under 'normal' operating conditions.
Also, make sure you don't overcommit memory. You will need to leave enough
memory so you can 'stack' both instances on a single server in a failure
condition.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Alex" <Yukon@.nospam.nospam> wrote in message
news:%231IbTEUrEHA.3848@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I am going to setup 2 instances of SQL Server 2000 in a 2-nodes clustered
> environment with each instance running on each node in a normal operation.
> Each node will act as a failover of the other node. I am not very certain
> that I understand how to do it. Here's what I am going to do.
> 1) Setup the 2 nodes cluster.
> 2) Create 2 SQL Cluster group2 with each group having their own resources
> (e.g. disk, IP, DTC, etc)
> 3) Install the 1st instance and assign it with a virtual name.
> 4) Install the 2nd instance and assgin another virtual name.
> Do I miss out anything or anything that I need to take note?
>
> Thanks You,
> Alex
>
|||Thanks for the advice :o)
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uwY11RUrEHA.3288@.TK2MSFTNGP12.phx.gbl...
> Looks like you are well on your way. Make sure and set the correct
> preferred nodes order on the cluster administration tool so that each
> instance knows where it wants to live under 'normal' operating conditions.
> Also, make sure you don't overcommit memory. You will need to leave
> enough
> memory so you can 'stack' both instances on a single server in a failure
> condition.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Alex" <Yukon@.nospam.nospam> wrote in message
> news:%231IbTEUrEHA.3848@.TK2MSFTNGP14.phx.gbl...
>
|||Hi,
FIrst of all, I would show my gratidute for MVP Geoff N. Hiten's
suggestions!
Additionally, I would love to show some useful documents for your reference
and hope this helps
SQL Server 2000 Failover Clustering White Paper
http://www.microsoft.com/technet/pro.../failclus.mspx
Support WebCast: Introduction to Microsoft SQL Server 2000 Clustering
http://support.microsoft.com/default...b;en-us;325106
INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
http://support.microsoft.com/?id=260758
Installation order for SQL Server 2000 Enterprise Edition on Microsoft
Cluster Server
http://support.microsoft.com/?id=243218
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Thanks Mingqing.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:jBO9LobrEHA.2500@.cpmsftngxa06.phx.gbl...
> Hi,
> FIrst of all, I would show my gratidute for MVP Geoff N. Hiten's
> suggestions!
> Additionally, I would love to show some useful documents for your
> reference
> and hope this helps
> SQL Server 2000 Failover Clustering White Paper
> http://www.microsoft.com/technet/pro.../failclus.mspx
> Support WebCast: Introduction to Microsoft SQL Server 2000 Clustering
> http://support.microsoft.com/default...b;en-us;325106
> INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
> http://support.microsoft.com/?id=260758
> Installation order for SQL Server 2000 Enterprise Edition on Microsoft
> Cluster Server
> http://support.microsoft.com/?id=243218
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||Hi Alex,
Thanks for your prompt updates!
If you encountered any questions or concerns on setup or configuration
multiple instances clustering environment. Don't hesitate to let me know.
We are always here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Multiple Instance cluster
Hi,
I am going to setup 2 instances of SQL Server 2000 in a 2-nodes clustered
environment with each instance running on each node in a normal operation.
Each node will act as a failover of the other node. I am not very certain
that I understand how to do it. Here's what I am going to do.
1) Setup the 2 nodes cluster.
2) Create 2 SQL Cluster group2 with each group having their own resources
(e.g. disk, IP, DTC, etc)
3) Install the 1st instance and assign it with a virtual name.
4) Install the 2nd instance and assgin another virtual name.
Do I miss out anything or anything that I need to take note?
Thanks You,
AlexLooks like you are well on your way. Make sure and set the correct
preferred nodes order on the cluster administration tool so that each
instance knows where it wants to live under 'normal' operating conditions.
Also, make sure you don't overcommit memory. You will need to leave enough
memory so you can 'stack' both instances on a single server in a failure
condition.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Alex" <Yukon@.nospam.nospam> wrote in message
news:%231IbTEUrEHA.3848@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I am going to setup 2 instances of SQL Server 2000 in a 2-nodes clustered
> environment with each instance running on each node in a normal operation.
> Each node will act as a failover of the other node. I am not very certain
> that I understand how to do it. Here's what I am going to do.
> 1) Setup the 2 nodes cluster.
> 2) Create 2 SQL Cluster group2 with each group having their own resources
> (e.g. disk, IP, DTC, etc)
> 3) Install the 1st instance and assign it with a virtual name.
> 4) Install the 2nd instance and assgin another virtual name.
> Do I miss out anything or anything that I need to take note?
>
> Thanks You,
> Alex
>|||Thanks for the advice :o)
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uwY11RUrEHA.3288@.TK2MSFTNGP12.phx.gbl...
> Looks like you are well on your way. Make sure and set the correct
> preferred nodes order on the cluster administration tool so that each
> instance knows where it wants to live under 'normal' operating conditions.
> Also, make sure you don't overcommit memory. You will need to leave
> enough
> memory so you can 'stack' both instances on a single server in a failure
> condition.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Alex" <Yukon@.nospam.nospam> wrote in message
> news:%231IbTEUrEHA.3848@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I am going to setup 2 instances of SQL Server 2000 in a 2-nodes clustered
>> environment with each instance running on each node in a normal
>> operation.
>> Each node will act as a failover of the other node. I am not very
>> certain
>> that I understand how to do it. Here's what I am going to do.
>> 1) Setup the 2 nodes cluster.
>> 2) Create 2 SQL Cluster group2 with each group having their own resources
>> (e.g. disk, IP, DTC, etc)
>> 3) Install the 1st instance and assign it with a virtual name.
>> 4) Install the 2nd instance and assgin another virtual name.
>> Do I miss out anything or anything that I need to take note?
>>
>> Thanks You,
>> Alex
>>
>|||Hi,
FIrst of all, I would show my gratidute for MVP Geoff N. Hiten's
suggestions!
Additionally, I would love to show some useful documents for your reference
and hope this helps
SQL Server 2000 Failover Clustering White Paper
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
Support WebCast: Introduction to Microsoft SQL Server 2000 Clustering
http://support.microsoft.com/default.aspx?scid=kb;en-us;325106
INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
http://support.microsoft.com/?id=260758
Installation order for SQL Server 2000 Enterprise Edition on Microsoft
Cluster Server
http://support.microsoft.com/?id=243218
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Thanks Mingqing.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:jBO9LobrEHA.2500@.cpmsftngxa06.phx.gbl...
> Hi,
> FIrst of all, I would show my gratidute for MVP Geoff N. Hiten's
> suggestions!
> Additionally, I would love to show some useful documents for your
> reference
> and hope this helps
> SQL Server 2000 Failover Clustering White Paper
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
> Support WebCast: Introduction to Microsoft SQL Server 2000 Clustering
> http://support.microsoft.com/default.aspx?scid=kb;en-us;325106
> INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
> http://support.microsoft.com/?id=260758
> Installation order for SQL Server 2000 Enterprise Edition on Microsoft
> Cluster Server
> http://support.microsoft.com/?id=243218
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Alex,
Thanks for your prompt updates!
If you encountered any questions or concerns on setup or configuration
multiple instances clustering environment. Don't hesitate to let me know.
We are always here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
I am going to setup 2 instances of SQL Server 2000 in a 2-nodes clustered
environment with each instance running on each node in a normal operation.
Each node will act as a failover of the other node. I am not very certain
that I understand how to do it. Here's what I am going to do.
1) Setup the 2 nodes cluster.
2) Create 2 SQL Cluster group2 with each group having their own resources
(e.g. disk, IP, DTC, etc)
3) Install the 1st instance and assign it with a virtual name.
4) Install the 2nd instance and assgin another virtual name.
Do I miss out anything or anything that I need to take note?
Thanks You,
AlexLooks like you are well on your way. Make sure and set the correct
preferred nodes order on the cluster administration tool so that each
instance knows where it wants to live under 'normal' operating conditions.
Also, make sure you don't overcommit memory. You will need to leave enough
memory so you can 'stack' both instances on a single server in a failure
condition.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Alex" <Yukon@.nospam.nospam> wrote in message
news:%231IbTEUrEHA.3848@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I am going to setup 2 instances of SQL Server 2000 in a 2-nodes clustered
> environment with each instance running on each node in a normal operation.
> Each node will act as a failover of the other node. I am not very certain
> that I understand how to do it. Here's what I am going to do.
> 1) Setup the 2 nodes cluster.
> 2) Create 2 SQL Cluster group2 with each group having their own resources
> (e.g. disk, IP, DTC, etc)
> 3) Install the 1st instance and assign it with a virtual name.
> 4) Install the 2nd instance and assgin another virtual name.
> Do I miss out anything or anything that I need to take note?
>
> Thanks You,
> Alex
>|||Thanks for the advice :o)
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uwY11RUrEHA.3288@.TK2MSFTNGP12.phx.gbl...
> Looks like you are well on your way. Make sure and set the correct
> preferred nodes order on the cluster administration tool so that each
> instance knows where it wants to live under 'normal' operating conditions.
> Also, make sure you don't overcommit memory. You will need to leave
> enough
> memory so you can 'stack' both instances on a single server in a failure
> condition.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Alex" <Yukon@.nospam.nospam> wrote in message
> news:%231IbTEUrEHA.3848@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I am going to setup 2 instances of SQL Server 2000 in a 2-nodes clustered
>> environment with each instance running on each node in a normal
>> operation.
>> Each node will act as a failover of the other node. I am not very
>> certain
>> that I understand how to do it. Here's what I am going to do.
>> 1) Setup the 2 nodes cluster.
>> 2) Create 2 SQL Cluster group2 with each group having their own resources
>> (e.g. disk, IP, DTC, etc)
>> 3) Install the 1st instance and assign it with a virtual name.
>> 4) Install the 2nd instance and assgin another virtual name.
>> Do I miss out anything or anything that I need to take note?
>>
>> Thanks You,
>> Alex
>>
>|||Hi,
FIrst of all, I would show my gratidute for MVP Geoff N. Hiten's
suggestions!
Additionally, I would love to show some useful documents for your reference
and hope this helps
SQL Server 2000 Failover Clustering White Paper
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
Support WebCast: Introduction to Microsoft SQL Server 2000 Clustering
http://support.microsoft.com/default.aspx?scid=kb;en-us;325106
INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
http://support.microsoft.com/?id=260758
Installation order for SQL Server 2000 Enterprise Edition on Microsoft
Cluster Server
http://support.microsoft.com/?id=243218
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Thanks Mingqing.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:jBO9LobrEHA.2500@.cpmsftngxa06.phx.gbl...
> Hi,
> FIrst of all, I would show my gratidute for MVP Geoff N. Hiten's
> suggestions!
> Additionally, I would love to show some useful documents for your
> reference
> and hope this helps
> SQL Server 2000 Failover Clustering White Paper
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
> Support WebCast: Introduction to Microsoft SQL Server 2000 Clustering
> http://support.microsoft.com/default.aspx?scid=kb;en-us;325106
> INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
> http://support.microsoft.com/?id=260758
> Installation order for SQL Server 2000 Enterprise Edition on Microsoft
> Cluster Server
> http://support.microsoft.com/?id=243218
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Alex,
Thanks for your prompt updates!
If you encountered any questions or concerns on setup or configuration
multiple instances clustering environment. Don't hesitate to let me know.
We are always here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Saturday, February 25, 2012
Multiple Clusters with shared passive nodes
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.
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@.gmail.com> wrote in message
news:1128006737.120461.270030@.g49g2000cwa.googlegr oups.com:
> 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.
|||So in this architecture then I take it that each instance of SQL will
have to be in its own cluster group right?
So in cluster administrator I would have SQL1 Group, SQL2 Group, SQL3
Group and SQL4 Group? Each with its own SQL IP address and its own
drives? But also have a main Cluster Group that contains the Quorum
drive and Cluster management IP?
Thanks
|||Yup, that's exactly what I was thinking.
Tony
"onefastmustang" <onefastmustang@.gmail.com> wrote in message
news:1128010958.220046.38020@.g14g2000cwa.googlegro ups.com:
> So in this architecture then I take it that each instance of SQL will
> have to be in its own cluster group right?
> So in cluster administrator I would have SQL1 Group, SQL2 Group, SQL3
> Group and SQL4 Group? Each with its own SQL IP address and its own
> drives? But also have a main Cluster Group that contains the Quorum
> drive and Cluster management IP?
> Thanks
|||There are a couple of Got'chas. What Tony is referring to is called a
"Round Robin" multi-instanced cluster. The one you described is referred to
as an "N + I" multi-instanced cluster. Both are supported; however, only
SS2K 64-bit allows more than 4 nodes in a SQL Server cluster. Windows 2K
Advanced Server only allows 2-node clusters. 2K Datacenter Edition supports
4-node clusters. Both Windows 2K3 Enterprise and Datacenter Editions
support 8-node clusters, but 32-bit SQL Server 2K does not unless the you
use the IA-64 edition.
PRB: Virtual SQL Server 2000 installation fails on cluster that has eight
nodes
http://support.microsoft.com/default...b;en-us;811054
Windows Server 2003 Server Cluster Architecture
http://www.microsoft.com/windowsserv...ercluster.mspx
Good luck.
Sincerely,
Anthony Thomas
"Tony Sebion" <tony@.sebion.com> wrote in message
news:3q2j44Fctu5kU1@.individual.net...
Yup, that's exactly what I was thinking.
Tony
"onefastmustang" <onefastmustang@.gmail.com> wrote in message
news:1128010958.220046.38020@.g14g2000cwa.googlegro ups.com:
> So in this architecture then I take it that each instance of SQL will
> have to be in its own cluster group right?
> So in cluster administrator I would have SQL1 Group, SQL2 Group, SQL3
> Group and SQL4 Group? Each with its own SQL IP address and its own
> drives? But also have a main Cluster Group that contains the Quorum
> drive and Cluster management IP?
> Thanks
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.
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@.gmail.com> wrote in message
news:1128006737.120461.270030@.g49g2000cwa.googlegr oups.com:
> 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.
|||So in this architecture then I take it that each instance of SQL will
have to be in its own cluster group right?
So in cluster administrator I would have SQL1 Group, SQL2 Group, SQL3
Group and SQL4 Group? Each with its own SQL IP address and its own
drives? But also have a main Cluster Group that contains the Quorum
drive and Cluster management IP?
Thanks
|||Yup, that's exactly what I was thinking.
Tony
"onefastmustang" <onefastmustang@.gmail.com> wrote in message
news:1128010958.220046.38020@.g14g2000cwa.googlegro ups.com:
> So in this architecture then I take it that each instance of SQL will
> have to be in its own cluster group right?
> So in cluster administrator I would have SQL1 Group, SQL2 Group, SQL3
> Group and SQL4 Group? Each with its own SQL IP address and its own
> drives? But also have a main Cluster Group that contains the Quorum
> drive and Cluster management IP?
> Thanks
|||There are a couple of Got'chas. What Tony is referring to is called a
"Round Robin" multi-instanced cluster. The one you described is referred to
as an "N + I" multi-instanced cluster. Both are supported; however, only
SS2K 64-bit allows more than 4 nodes in a SQL Server cluster. Windows 2K
Advanced Server only allows 2-node clusters. 2K Datacenter Edition supports
4-node clusters. Both Windows 2K3 Enterprise and Datacenter Editions
support 8-node clusters, but 32-bit SQL Server 2K does not unless the you
use the IA-64 edition.
PRB: Virtual SQL Server 2000 installation fails on cluster that has eight
nodes
http://support.microsoft.com/default...b;en-us;811054
Windows Server 2003 Server Cluster Architecture
http://www.microsoft.com/windowsserv...ercluster.mspx
Good luck.
Sincerely,
Anthony Thomas
"Tony Sebion" <tony@.sebion.com> wrote in message
news:3q2j44Fctu5kU1@.individual.net...
Yup, that's exactly what I was thinking.
Tony
"onefastmustang" <onefastmustang@.gmail.com> wrote in message
news:1128010958.220046.38020@.g14g2000cwa.googlegro ups.com:
> So in this architecture then I take it that each instance of SQL will
> have to be in its own cluster group right?
> So in cluster administrator I would have SQL1 Group, SQL2 Group, SQL3
> Group and SQL4 Group? Each with its own SQL IP address and its own
> drives? But also have a main Cluster Group that contains the Quorum
> drive and Cluster management IP?
> Thanks
Subscribe to:
Posts (Atom)