Re: sql 2005 cluster setup questions
- From: "Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx>
- Date: Fri, 5 Oct 2007 13:40:48 -0400
Funny you should ask. I just wrote a blog post on that topic:
http://weblogs.sqlteam.com/geoffh/archive/2007/10/04/To-Cluster-or-Not-to-Cluster-That-SSIS-the-Question.aspx
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Li" <Li@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:402FF650-45D5-4D0D-89F8-48ABF1459A77@xxxxxxxxxxxxxxxx
I installed SSIS on Active node of SQL Server 2005 Std, Active/Passive
Cluster. Do I need to install it on Passive node too if I don't need SSIS to
be configures as a cluster resource? What will be the disadvantages for not
having SSIS on 2nd node?
Thanks.
"Geoff N. Hiten" wrote:
The usual "It depends" answer applies.
I have been putting SSIS in a separate resource group, but only on
single-instance clusters. I haven't experimented with clustering SSIS for
multiple instances. I suggest unclustered for this many nodes, that way,
there is always a local copy for each instance to use. If you only use SSIS
on one instance, then I would cluster around that instance.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Ellie" <Ellie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F87915F6-4B88-44D8-92CB-2758872CC0B9@xxxxxxxxxxxxxxxx
> Thanks so much for valuable information.
>
> what will be the best for consolidated sql envitonment on active/active
> cluster with 4 instances
>
> 1. to install it SSIS on all nodes to leave it unclustered
> 2. to configure SSIS in all sql resource groups (dont know if that
> possible
> at all)
> 3. to cluster SSIS in different cluster group
>
>
>
> "Geoff N. Hiten" wrote:
>
>> By default, SSIS only does a local install. You can install it on >> each
>> node
>> and cluster it "by hand" afterwards. Here is the article on how to do
>> it:
>> http://msdn2.microsoft.com/en-us/library/ms345193.aspx
>>
>> The installer should start from the node that currently owns the disk
>> resource you wish to use for that particular SQL instance. >> Personally, I
>> prefer to run the installer on each node and install just the client
>> tools
>> and documentation. Those components are not cluster-aware and must be
>> installed on each node separately anyway. It is less confusing if you
>> get
>> them out of the way first.
>>
>> Standard Edition only supports 2-node clusters. It won't work on
>> clusters
>> with more than two nodes.
>>
>> -- >> Geoff N. Hiten
>> Senior SQL Infrastructure Consultant
>> Microsoft SQL Server MVP
>>
>>
>>
>> "Ellie" <Ellie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:1E2D18C0-A138-4823-B68E-C023E7505A1E@xxxxxxxxxxxxxxxx
>> > Im working on sql consolidation project and I am about to build
>> > multiinstance
>> > 2 node cluster.
>> > If I want Integration services installed should I manually install >> > on
>> > both
>> > nodes or thats something that will be installed automatically on >> > both
>> > nodes (
>> > It is crutial to have IS installed)
>> >
>> > i want to 2 instances to live on node1 and 2 more on node 2 ( i.e.
>> > active
>> > active cluster). Should I start sql set up on one node only or I >> > have
>> > to
>> > run
>> > setup from home node of each instance?
>> >
>> > last one q - is it possible to build 4-instance cluster >> > active-active
>> > with
>> > SQL 2005 Standatrd edition?
>>
>>
.
- Follow-Ups:
- Re: sql 2005 cluster setup questions
- From: Mary
- Re: sql 2005 cluster setup questions
- From: Li
- Re: sql 2005 cluster setup questions
- From: Li
- Re: sql 2005 cluster setup questions
- From: Li
- Re: sql 2005 cluster setup questions
- References:
- Re: sql 2005 cluster setup questions
- From: Li
- Re: sql 2005 cluster setup questions
- Prev by Date: Re: sql 2005 cluster setup questions
- Next by Date: Re: Setup 2 WIN2K3 R2 Ent with SQL 2005 Ent in cluster
- Previous by thread: Re: sql 2005 cluster setup questions
- Next by thread: Re: sql 2005 cluster setup questions
- Index(es):
Relevant Pages
|
