Re: active active: can somebody help with design?
- From: "Tom Moreau" <tom@xxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 5 Jun 2008 11:10:50 -0400
Perhaps a DNS alias had been created. Not sure.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Gene." <Gene@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:41692798-30E5-4934-A61E-8DCDC1E61EE3@xxxxxxxxxxxxxxxx
However, the situation I saw was:
2 sql instances installed in active active configuration, using each 4
mounting points.
I beleive if you ran @@servername, it would show you named instance. But all
application programs and ssms would refer to them as sql2 and sql3 as they
were default instances. No aliasing on clients was involved.
How was it possible?
"Tom Moreau" wrote:
You don't install MSCS twice - only once. You then install SQL Serverin
twice.
You can't have a default instance in virtual server 1 and another default
instance on virtual server 2. There is only one default instance allowed
the entire cluster. When I have a multi-instance cluster, I use strictlyso
named instances - eliminates confusion.
You don't install the instances on particular nodes per se. Rather, you
install the instances on the cluster. You can then move the groups around
so that they are not running all on the same node.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Gene." <Gene@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:952000C0-BA79-49B6-BE78-4A7ECF044C6C@xxxxxxxxxxxxxxxx
Hi Tom
As I understand:
1. I would have 2 groups of drives:
f:\system, f:\data f:\log f:\tempdb
and
g ......
Those directories would be a mounting points for raid resources from SAN.
2. I run mscs install 2 times - each is going to create different virtual
servers which belong to the same cluster.
3. After it's done, I need to get default instance on virt. server1 and 2.
Here i am still confused. I think I will be installing named instance on
each server on node. How it will end up as default instance on virtual
server1?
Thank you, Gene.
"Tom Moreau" wrote:
There is really no difference between a single-instance install and a
multi-instance install. You simply repeat the install process for each
instance. There can be only one default instance in an entire cluster,
themat least one of tour instances will be a named instance. Each instancewill
have its own virtual server name, IP, and disk resources.to
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Gene." <Gene@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:22754C51-1668-4907-B30A-9B0DE4F31D45@xxxxxxxxxxxxxxxx
Hi folks
I am new to sql installation on clusters, they were installed before me.
I have 2 questions:
1. how do I install 2 virtual servers on 2 node cluster? I only know how
install 1 virtual server.
2. Once i have 2 virtual servers, will I get default sql instances on
by default or I have to do something for it?
If by chance you could also point to document which describes details of
active/active setup, please mention it.
Thank you, Gene.
.
- References:
- Re: active active: can somebody help with design?
- From: Tom Moreau
- Re: active active: can somebody help with design?
- From: Gene.
- Re: active active: can somebody help with design?
- From: Tom Moreau
- Re: active active: can somebody help with design?
- From: Gene.
- Re: active active: can somebody help with design?
- Prev by Date: Re: active active: can somebody help with design?
- Next by Date: Re: active active: can somebody help with design?
- Previous by thread: Re: active active: can somebody help with design?
- Next by thread: Re: active active: can somebody help with design?
- Index(es):
Relevant Pages
|
