Home All Groups Group Topic Archive Search About

Active/Active/Active Cluster question



Author
11 Dec 2008 1:51 PM
tolcis
Hi!
This is the first time I have to setup Active/Active/Active Cluster
and I am not sure on how many instances I have to install on each
node.
Because of the hardware constraints I have to build one node cluster
first, then in a week add another node in to the cluster and then
another.
Each physical node must be able to support all three instances at any
point.
When I build one node cluster first I will install three instances
(server1\sql1, server1\sql2, server1\sql3) of SQL Server. In one week
when I add another node (which will only have Windows OS installed) to
the cluster do I have to install three SQL Instances on that node or
they will automatically be created because the node is already in the
cluster?

T.

Author
11 Dec 2008 2:04 PM
Uri Dimant
Hi
SQL Instance is per node, thuse you will have to install  3 instances on the
second node too



Show quoteHide quote
"tolcis" <nytolly***@gmail.com> wrote in message
news:5ffb341d-801b-4008-a74c-e9ed039c5751@k36g2000pri.googlegroups.com...
> Hi!
> This is the first time I have to setup Active/Active/Active Cluster
> and I am not sure on how many instances I have to install on each
> node.
> Because of the hardware constraints I have to build one node cluster
> first, then in a week add another node in to the cluster and then
> another.
> Each physical node must be able to support all three instances at any
> point.
> When I build one node cluster first I will install three instances
> (server1\sql1, server1\sql2, server1\sql3) of SQL Server. In one week
> when I add another node (which will only have Windows OS installed) to
> the cluster do I have to install three SQL Instances on that node or
> they will automatically be created because the node is already in the
> cluster?
>
> T.
Are all your drivers up to date? click for free checkup

Author
11 Dec 2008 2:24 PM
tolcis
Show quote Hide quote
On Dec 11, 9:04 am, "Uri Dimant" <u***@iscar.co.il> wrote:
> Hi
> SQL Instance is per node, thuse you will have to install  3 instances on the
> second node too
>
> "tolcis" <nytolly***@gmail.com> wrote in message
>
> news:5ffb341d-801b-4008-a74c-e9ed039c5751@k36g2000pri.googlegroups.com...
>
>
>
> > Hi!
> > This is the first time I have to setup Active/Active/Active Cluster
> > and I am not sure on how many instances I have to install on each
> > node.
> > Because of the hardware constraints I have to build one node cluster
> > first, then in a week add another node in to the cluster and then
> > another.
> > Each physical node must be able to support all three instances at any
> > point.
> > When I build one node cluster first I will install three instances
> > (server1\sql1, server1\sql2, server1\sql3) of SQL Server. In one week
> > when I add another node (which will only have Windows OS installed) to
> > the cluster do I have to install three SQL Instances on that node or
> > they will automatically be created because the node is already in the
> > cluster?
>
> > T.- Hide quoted text -
>
> - Show quoted text -

From what I understand SQL Server is a cluster aware application and
it should install itself on the nodes in the cluster.  Is it not
correct?
Author
11 Dec 2008 2:48 PM
Kevin3NF
SQL 2000:
How to: Add or Remove Nodes in a SQL Server Failover Cluster (Setup)
http://technet.microsoft.com/en-us/library/ms191545.aspx

See link on that page for SQL 2005 if that is your version



--

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.

Twitter: Kevin3NF

Show quoteHide quote
"tolcis" <nytolly***@gmail.com> wrote in message
news:5e2e9b1a-e517-4138-8c81-c313bcc5f75f@q26g2000prq.googlegroups.com...
On Dec 11, 9:04 am, "Uri Dimant" <u***@iscar.co.il> wrote:
> Hi
> SQL Instance is per node, thuse you will have to install 3 instances on
> the
> second node too
>
> "tolcis" <nytolly***@gmail.com> wrote in message
>
> news:5ffb341d-801b-4008-a74c-e9ed039c5751@k36g2000pri.googlegroups.com...
>
>
>
> > Hi!
> > This is the first time I have to setup Active/Active/Active Cluster
> > and I am not sure on how many instances I have to install on each
> > node.
> > Because of the hardware constraints I have to build one node cluster
> > first, then in a week add another node in to the cluster and then
> > another.
> > Each physical node must be able to support all three instances at any
> > point.
> > When I build one node cluster first I will install three instances
> > (server1\sql1, server1\sql2, server1\sql3) of SQL Server. In one week
> > when I add another node (which will only have Windows OS installed) to
> > the cluster do I have to install three SQL Instances on that node or
> > they will automatically be created because the node is already in the
> > cluster?
>
> > T.- Hide quoted text -
>
> - Show quoted text -

From what I understand SQL Server is a cluster aware application and
it should install itself on the nodes in the cluster.  Is it not
correct?

Bookmark and Share