active active: can somebody help with design?

#71

You need two virtual SQL Servers - not two clusters. After you have created
the cluster itself, then just run the SQL Server install - once for each SQL
install. IOW, you will need to run the SQL Server install twice. Each
time, it creates a virtual server, each with its own IP and server name.

--
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 (AT) discussions (DOT) microsoft.com> wrote

So Tom, so I do not need 2 virtual servers, don't I?
And if i ever need to virtual servers, what it would be and how do i install
2nd virtual server?

"Tom Moreau" wrote:

Quote:

You don't install MSCS twice - only once. You then install SQL Server
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
in
the entire cluster. When I have a multi-instance cluster, I use strictly
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 (AT) discussions (DOT) microsoft.com> wrote in message
news:952000C0-BA79-49B6-BE78-4A7ECF044C6C (AT) microsoft (DOT) com...
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,
so
at least one of tour instances will be a named instance. Each instance
will
have its own virtual server name, IP, and disk resources.

--
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 (AT) discussions (DOT) microsoft.com> wrote in message
news:22754C51-1668-4907-B30A-9B0DE4F31D45 (AT) microsoft (DOT) com...
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
to
install 1 virtual server.
2. Once i have 2 virtual servers, will I get default sql instances on
them
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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

active active: can somebody help with design?

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Re: active active: can somebody help with design? - 06-05-2008 , 11:43 AM