Re: setup custer - one node already in production

The current production node has replication setup. The second node to be
built will has its own replication setup with has nothing to do with the
first node.

Using active-active mode saves money - that's the only reason to go this way.

Your suggestion of 2 x 1 N + I cluster configuration caught my interest.
Have you done this? I have experience with 2-node cluster, but know nothing
about 2+ cluster. Currently trying to find info on this.

Claudia

"Anthony Thomas" wrote:

So, you are going to use replication and make the second instance a
reporting server? How do you plan on "fully using" the hardware?

Keep in mind, that either due to server failure or during maintenance, you
will move all instances to a single host and will degrade performance if you
have not pre-limited the configuration. In this case, then you would
specify to use only 1/2 of the resources on any node, but then, logically,
you have the same thing as an Active/Passive configuration where you fully
used the hardware on 1 node.

You would be better off creating a 2 x 1 N + I cluster configuration, then
you would have 2 fully utilized nodes with one passive giving you 2/3
utilization overall (which is better than 1/2), but still maintain full
functionality during sever failure and maintenance. It would take a
concurrent 2 server failure before you would be back in the same performance
condition as the Active/Active configuration.

Sincerely,


Anthony Thomas


--

"Claudia" <Claudia@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:152D1698-2B32-41F5-894B-CC731DB55DBF@xxxxxxxxxxxxxxxx
Anthony,
Because one node is already in production, and it also involves
replication
which will break with new virtual name, I will not try MSCS directly and
upgrade sql between the two nodes.

Active-active setup is to fully use the hardware.

"Anthony Thomas" wrote:

You could just install MSCS and form a cluster between the to nodes.

Then, you could use SQL Server setup to upgrade the stand alone instance
to
a single-instanced clustered instance.

http://msdn2.microsoft.com/en-us/library/ms191295.aspx

By the way, why do you want to consider Active/Active (a.k.a.,
multi-instanced) clustering when single-instanced will provide
sufficient
high availability?

Sincerely,


Anthony Thomas


--

"Claudia" <Claudia@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3F0496AB-4736-4272-B44E-525270678299@xxxxxxxxxxxxxxxx
Thank Geoff and Russ for quick response.

The second hardware set for the second node is the same as the first
one,
and both are cluster compatible.

Both of your responses tell me that keeping the current sql instance
is
impossible. I have to build a single node cluster first and migrate
dbs +
replication.

Thanks again for the direction.

Claudia

"Russ Kaufmann [MVP]" wrote:

"Claudia" <Claudia@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:97F0E951-21F8-4A68-A9D4-251C3A86EB2F@xxxxxxxxxxxxxxxx
I need to setup an active-active cluster with win2003 and sql2005,
64-bit.

One node (sql2005, standard edition, using SAN as storage) is
already
in
production. For now, it's purely a stand-alone machine with no
Microsoft
Cluster Service. I need to add another node to build an
active-active
cluster. Because it's a mission critical production server, I have
to
be
extra cautious. Has anybody done this and know the steps to
accomplish
this?
Any document/links that explain it in detail?

You have to configure the cluster service first. Only after the
service
is
installed can you install SQL on top of the cluster and have it work
properly.

In your case, build a separate cluster, install SQL and then migrate
your
databases to it.


--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
Denver starting Feb 12th
NYC starting Feb 19th









.

Relevant Pages

  • Replication and Data Access Option
    ... Had replication setup using a cluster called 'Cluster' ... Now have replication setup and the name of the new cluster is 'NewCluster' ... Every Publisher has the 'NewCluster' listed as a REMOTE SERVER under the ...
    (microsoft.public.sqlserver.replication)
  • Re: Problem adding node
    ... cluster. ... Getting Access Denied error on the second node error: ... I have deleted the second server from the domain and re ... MVP - Windows Server - Clustering ...
    (microsoft.public.windows.server.clustering)
  • Move from stand alone server to active/passive cluster
    ... cluster will run Windows 2008 R2. ... Setup a single node cluster and restore the system databases. ... stop SQL on the existing server and change the LUNs ... Then ugrade the old server and bring it in as the second node. ...
    (microsoft.public.sqlserver.clustering)
  • Move from stand alone server to active/passive cluster
    ... cluster will run Windows 2008 R2. ... Setup a single node cluster and restore the system databases. ... stop SQL on the existing server and change the LUNs ... Then ugrade the old server and bring it in as the second node. ...
    (microsoft.public.sqlserver.clustering)
  • Migrating stand alone server to active/passive cluster
    ... cluster will run Windows 2008 R2. ... Setup a single node cluster and restore the system databases. ... stop SQL on the existing server and change the LUNs ... Then ugrade the old server and bring it in as the second node. ...
    (microsoft.public.sqlserver.clustering)
Loading