Re: ..newbie.. cluster multi-istance..


<marco.crespi@xxxxxxxxx> wrote in message
news:1170322227.120566.94730@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,
I must install M$ SQL2005 standard on two node in cluster enviroment.
I wanna know some best practices to resolve the installation in the
better way.

The server is based on two blade dual processor dual core. I've a SAN
configured with 4 LUN, each with 1 partition (eventually a can
reconfigure the SAN).

I've some question:

a) SQL2005 is defined by M$ only active/passive on a cluster. This
means that can I work with two nodes, with two cluster groups each one
working with one instance?


Yes, one and only one instance per group, you can have multiple groups


In other words, in which way can I
configure cluster's groups (or group)? Can I use only a group with two
instance?


One instance per group


Can I use two groups?


yes, you will have two instances


I can obtain a failover enviroment
relative to one instance with two active nodes?


An instance (group) is only online / "running" on one node. (Always on one
node only)
A Group (instance) is NEVER "running" on two nodes.


(SQL2005 is active/
active on nodes, but each instance is active/passive on nodes?)


One instance/group is only online on one node. when you have two groups,
then you can have one group online on one node and the second group online
on the second node. If a node fails, the surviving node is now running all
groups.


I
prefer obtain the failover option vs. load balance across two nodes,
but I must know the possibilities for future decision.


Clustering is fail-over, not load balancing.



b) An istance SQL2005 is based on an installation path for the engine
of the instance and several paths for data files. On a cluster based
on SAN where I can/must install the instance?


follow the instructions, the executables are in the default places, and data
goes on your clustered disks (on a SAN)


I've a local disk
partitioned with two logical unit (c: and d:). Also I've have one or
more units on SAN. C: contains Windows2003 and D: is empty. I must
install the instance on the local disk of the node or I use the unit
(one or more) on SAN?.


follow instructions, books on line is a good place to start
or here : http://msdn2.microsoft.com/en-us/library/ms179530.aspx


I know that on a normal enviroment it's better
use some different fisical disks/units (The best it's split/organize
datafile in order of cpu capabilities - e.g.: dual processor/dual core
tempdb on 4 files..) but with a SAN?


yes, depending on your application / IO patterns, but general rule is data
files and log files on different spindles


It's also a best practice define
several LUN on a SAN in order of obtain an optimized architecture?.


Absolutely, every SAN need to be configured properly, every LUN will have to
be created with certain parameters. However this is so dependent on the SAN
you have, you should contact your SAN vendor to get the best practices
(mention it is for SQL 2005).


Or
can I use only a large disk with several files? I need install 4
instances and I want obtain the best architectural solution.


As above, more spindles = more IO = better performance (this is the general
rule)



c) With the first installation I will make one instance on two nodes.
In which way I will install the other 3 instances (on a cluster
enviroment)?


as per documentation



If you can, tell me more infos about these tasks.


If you have little experience with clusters, I would suggest to read up
about this as much as possible.
Install a cluster, A cluster with Virtual Machine Nodes will do, and
practice the setup. Make sure you are familiar with the tools, interfaces,
configurations, failover/back.
Practice and test first how all this works.

HTH,
_Edwin.



oecre.at.hotmail.dot.com



.

Relevant Pages

  • ..newbie.. cluster multi-istance..
    ... I must install M$ SQL2005 standard on two node in cluster enviroment. ... I've a SAN ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster over DC
    ... I don't want cluster Active Directory. ... if it is possible install the service of cluster in two servers with ... problem in install a cluster over two DC??? ... Application incompatibilities, and security best practices. ...
    (microsoft.public.windows.server.clustering)
  • Re: Clustering Newbie - SAN Advice
    ... A SAN generally has gigabtes of cache and uses large internal block sizes ... The SAN or Smart array will dictate what internal connection the disks have. ... Senior SQL Infrastructure Consultant ... single-instance cluster. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Pervasive SQL Clustering
    ... So, in effect, I've got services running on the cluster and both nodes. ... Is it possible to install and application to the cluster rather than the ... > setting up a Generic Service resource, you might find this topic from Help ... > or application highly available using Generic Service or Generic Application ...
    (microsoft.public.windows.server.clustering)
  • Re: sql 2005 cluster setup questions
    ... Thanks again, Geoff. ... Here is the official instructions on how to rip SQL 2005 out by the roots. ... to 2nd node to install work station component, ... want to take Microsoft recommended approach not to cluster SSIS but I ...
    (microsoft.public.sqlserver.clustering)