what's difference between active/active and active/passive

#41

Yes. Each Instance requires a separate install.

Servers and Instances are independent in a cluster. You can arrange
Instances on whichever nodes suit you. Each instance has a preferred node
order to determine failover paths. It is a good idea to set these when you
have anything more complex than a single-instance cluster.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Iter" <Iter (AT) discussions (DOT) microsoft.com> wrote

Quote:

Thank you guys. I still have a a little bit question about installation.
1. If I install active/active, I need to install extra times for sql
server
installation in order to install other instances, just like stand alone
server to install named instance, right?
2. I don't need to configue which one is primary server and which one is
failover server when configure active/active cluster, right?

thanks.

"Uri Dimant" wrote:

Iter
Active/Active.....
As Geoff pointed out in previous post those terminology is for SQL Server
7.0

Shortly

1)Active-Active

You have a cluster configuration with two nodes. On each node you have
intalled SQL Server Instance.
If one node failed over the second one becomes responsible for clinets.
It
is important to configure memory properly ( for example if you have 16GB
on
two nodes)
assign 5-6GB for each one

2) Active Passive

You have a cluster configuration with two nodes.But at this time you have
intalled SQL Server Instance only on one node (Active)
When it failed over the passive node (computer) becomes an active.

Read these articles

http://searchsqlserver.techtarget.co..._needs_URL.pdf -
---Steps Clustering
http://technet2.microsoft.com/window....mspx?mfr=true
---All about CLustering

"Iter" <Iter (AT) discussions (DOT) microsoft.com> wrote in message
news:2B6345F8-99B9-4F38-A637-6124CB953577 (AT) microsoft (DOT) com...
I have a question regarding configuration of active/active and
active/passive, is there any difference between them when install sql
server
software in windows cluster. I look at doc and can not figure out what
is
difference between them. Can anybody give me some tips about it?
Thanks.

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

what's difference between active/active and active/passive

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

Re: what's difference between active/active and active/passive - 01-24-2008 , 10:12 AM