dbTalk Databases Forums  

Active/Passive ---> Active/Active

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


Discuss Active/Passive ---> Active/Active in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Allan Hirt
 
Posts: n/a

Default Active/Passive ---> Active/Active - 07-28-2004 , 05:42 PM






You mean going from a single instance cluster to a
multiple instance cluster (this is the correct
terminology).

It depends on your disk setup. Remember that each SQL
virtual server needs its own set of dedicated disks, not
to mention a dedicated disk for the quorum, and if you're
using W2K3, one for MS DTC.

Also, you need to ensure you have enough memory and
processor to handle the additional load.

I suggest you look at any of the numerous sources out
there, including the SQL 2K HA book by MS Press, or the
failover clustering whitepaper on Microsoft.com



Reply With Quote
  #2  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Active/Passive ---> Active/Active - 07-30-2004 , 09:11 AM






I think your developer misunderstands the whole 'active-passive...'
nomenclature. Do you want one or two virtual servers on your cluster? If
one, then it is 'active-passive' or 'single-instance'. Two or more means
'active-active' or 'multi-instance'. If you want to transition your
existing single instance to new hosts, that is a different issue.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

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

Quote:
Hi Allan,

Thanks for replying. I should make myself clearer.
Right now I have 2 Dell 6450's attached to EMC Clarion.
They are setup as Active/Passive cluster. The company bought 2
new Dell 6650's and I will be swapping out the servers one at a time to
upgrade the H/W.
One of the developers wants to go Active/Active and the only way I think I
can do this is uninstall SQL and uninstall the cluster, then reinstall the
cluster and and reinstall SQL. If that's the case I think we'll stay with
Active/Passive since we couldn't afford the downtime.
Quote:


"Allan Hirt" wrote:

You mean going from a single instance cluster to a
multiple instance cluster (this is the correct
terminology).

It depends on your disk setup. Remember that each SQL
virtual server needs its own set of dedicated disks, not
to mention a dedicated disk for the quorum, and if you're
using W2K3, one for MS DTC.

Also, you need to ensure you have enough memory and
processor to handle the additional load.

I suggest you look at any of the numerous sources out
there, including the SQL 2K HA book by MS Press, or the
failover clustering whitepaper on Microsoft.com






Reply With Quote
  #3  
Old   
plane123
 
Posts: n/a

Default Re: Active/Passive ---> Active/Active - 07-30-2004 , 11:45 AM



Thanks for your input.
I think in order for me to create an active/active setup, I need to reconfigure the shared disk, which I can't do, I'd disrupt all the other attached servers.
Thanks

"Geoff N. Hiten" wrote:

Quote:
I think your developer misunderstands the whole 'active-passive...'
nomenclature. Do you want one or two virtual servers on your cluster? If
one, then it is 'active-passive' or 'single-instance'. Two or more means
'active-active' or 'multi-instance'. If you want to transition your
existing single instance to new hosts, that is a different issue.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"plane123" <plane123 (AT) discussions (DOT) microsoft.com> wrote in message
news:305B32A8-6A53-4337-A2AE-48F60DE459CB (AT) microsoft (DOT) com...
Hi Allan,

Thanks for replying. I should make myself clearer.
Right now I have 2 Dell 6450's attached to EMC Clarion.
They are setup as Active/Passive cluster. The company bought 2
new Dell 6650's and I will be swapping out the servers one at a time to
upgrade the H/W.
One of the developers wants to go Active/Active and the only way I think I
can do this is uninstall SQL and uninstall the cluster, then reinstall the
cluster and and reinstall SQL. If that's the case I think we'll stay with
Active/Passive since we couldn't afford the downtime.



"Allan Hirt" wrote:

You mean going from a single instance cluster to a
multiple instance cluster (this is the correct
terminology).

It depends on your disk setup. Remember that each SQL
virtual server needs its own set of dedicated disks, not
to mention a dedicated disk for the quorum, and if you're
using W2K3, one for MS DTC.

Also, you need to ensure you have enough memory and
processor to handle the additional load.

I suggest you look at any of the numerous sources out
there, including the SQL 2K HA book by MS Press, or the
failover clustering whitepaper on Microsoft.com







Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.