ACTIVE/ACTIVE configuration

We are looking at installing a 2 Node ACTIVE/ACTIVE SQL
Server configuration utilizing two DELL PE6600 servers,
both connected via FIBRE to a DELL CX200(CLARION). The
OS will be clustered in a ACTIVE/ACTIVE configuration as
well.
The main purpose for attempting this is more for
spreading processing across systems more than for
failover capabilities.
I have a few questions, the first would be has anyone
accomplished this? Secondly, in a SQL server
ACTIVE/ACTIVE configuration, can both instances utilize
one shared disk configuration, so that database merging
does not need to happen?
Any help/advice would be greatly appreciated as i'm
drawing up a plan.
Failover clustering is designed for high availability. Failover clustering
is NOT a scale-out technology. There are some scenarios where data
partitioning and merge replication can be used in conjunction with
multi-instance clustering to achieve scale-out, but they require intensive
design and management. You are probably better off buying a bigger box for
your server than trying to scale out.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jeff" <anonymous@.discussions.microsoft.com> wrote in message
news:81e201c431f4$708e9430$a501280a@.phx.gbl...
> We are looking at installing a 2 Node ACTIVE/ACTIVE SQL
> Server configuration utilizing two DELL PE6600 servers,
> both connected via FIBRE to a DELL CX200(CLARION). The
> OS will be clustered in a ACTIVE/ACTIVE configuration as
> well.
> The main purpose for attempting this is more for
> spreading processing across systems more than for
> failover capabilities.
>

> I have a few questions, the first would be has anyone
> accomplished this? Secondly, in a SQL server
> ACTIVE/ACTIVE configuration, can both instances utilize
> one shared disk configuration, so that database merging
> does not need to happen?
>
No.

> Any help/advice would be greatly appreciated as i'm
> drawing up a plan.
|||I guess with that being said, would you have any ideas in
regards to distributed processing.
High availiability is what i'm looking for, just in an
active/active configuration. Can I not have a sql server
running on two different systems and look at the same
logical data source via SAN solution?

>--Original Message--
>Failover clustering is designed for high availability.
Failover clustering
>is NOT a scale-out technology. There are some scenarios
where data
>partitioning and merge replication can be used in
conjunction with
>multi-instance clustering to achieve scale-out, but they
require intensive
>design and management. You are probably better off
buying a bigger box for
>your server than trying to scale out.
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Jeff" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:81e201c431f4$708e9430$a501280a@.phx.gbl...
as
>No.
>
>.
>
|||SQL Failover clustering works on a shared-nothing setup. Each instance has
exclusive control over the underlying resources, including its portion of
the shared storage system. The cluster service arbitrates ownership of the
underlying resources so that only one host node at a time controls each
resource.
Distributed database computing is not quite what is advertised. The TPC-C
benchmark is particularly well suited to a distributed model (coincidence
maybe?), but not all applications work as well. Buying a larger box is
probably where you want to go if you need more processing power.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jeff" <anonymous@.discussions.microsoft.com> wrote in message
news:830d01c43207$a14ec370$a601280a@.phx.gbl...[vbcol=seagreen]
> I guess with that being said, would you have any ideas in
> regards to distributed processing.
> High availiability is what i'm looking for, just in an
> active/active configuration. Can I not have a sql server
> running on two different systems and look at the same
> logical data source via SAN solution?
>
> Failover clustering
> where data
> conjunction with
> require intensive
> buying a bigger box for
> message
> as
|||That makes since. I have been doing some reading on
active/active cluster configurations. Just want to
understand that in that configuration each instance
serves it's own needs until the time that one fails and
then the other instance picks up the additional workload
of the failed instance. Is that correct?

>--Original Message--
>SQL Failover clustering works on a shared-nothing
setup. Each instance has
>exclusive control over the underlying resources,
including its portion of
>the shared storage system. The cluster service
arbitrates ownership of the
>underlying resources so that only one host node at a
time controls each
>resource.
>Distributed database computing is not quite what is
advertised. The TPC-C
>benchmark is particularly well suited to a distributed
model (coincidence
>maybe?), but not all applications work as well. Buying
a larger box is
>probably where you want to go if you need more
processing power.
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Jeff" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:830d01c43207$a14ec370$a601280a@.phx.gbl...
in[vbcol=seagreen]
server[vbcol=seagreen]
scenarios[vbcol=seagreen]
they[vbcol=seagreen]
SQL[vbcol=seagreen]
servers,[vbcol=seagreen]
The[vbcol=seagreen]
configuration[vbcol=seagreen]
anyone[vbcol=seagreen]
utilize[vbcol=seagreen]
merging
>
>.
>
|||Nope. You are confusing instances and hosts. Not surprising since
active-active is a holdover from the SQL 7.0 days and is misleading for SQL
2000.
Lets start with a single-instance cluster. Two nodes (host computers), one
SQL instance. The instance runs on one host at a time. The cluster
services on all nodes monitor the running instance and if it fails a series
of tests (looks-alive and is-alive) the instance is deemed failed and is
restarted. The restart may be on the original node or on the other node.
You can add a second, independant instance that normally runs on the second
node but can run on either node. The two instances have nothing in common
except the set of host nodes that they can run on. There are some extra
concerns when using multiple instances on a cluster to make sure they can
'stack' on a single host node if necessary, but otherwise they do not
interact in any way. People incorrectly refer to this as 'Active-Active',
meaning both nodes have active instances. However, under SQL 2000 you can
have up to 16 instances on a cluster, so the naming quickly can get out of
hand.
Under SQL 7.0 the nodes were not completely interchangable so the
active-passive and active-active names were important. Each node owned a
single instance and the other node could run it but not make certain changes
to the setup. Now, single-instance and multiple-instance naming is more
meaningful since the nodes are truly interchangable. This is especially
true now that Windows 2003 allows 8 node clusters using Enterprise Edition.
(Active-Active-Passive-Passive-Active.. Blah, Blah, Blah).
Sounds like you need a single-instance installation running on fairly beefy
hardware. FYI, the CX-200 has been replaced with the CX-300. If you go
with a system larger than a 6600/6650 I would strongly look at the CX-500 or
CX-700 for the performance benefits.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jeff" <anonymous@.discussions.microsoft.com> wrote in message
news:837001c43213$70e59cc0$a501280a@.phx.gbl...[vbcol=seagreen]
> That makes since. I have been doing some reading on
> active/active cluster configurations. Just want to
> understand that in that configuration each instance
> serves it's own needs until the time that one fails and
> then the other instance picks up the additional workload
> of the failed instance. Is that correct?
> setup. Each instance has
> including its portion of
> arbitrates ownership of the
> time controls each
> advertised. The TPC-C
> model (coincidence
> a larger box is
> processing power.
> message
> in
> server
> scenarios
> they
> SQL
> servers,
> The
> configuration
> anyone
> utilize
> merging
|||No. SQL Server does not allow shared access to a database. A single SQL
Server can open the database files and access them and that prevents
anything else for getting at the data. This is a data protection mechanism
and exists to prevent possible corruption of the data when two independent
resources attempt to write the same data.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
|||You may deploy it on SAN
|||I was going to have my two nodes on a SAN solution. Is
there differences from what the other gentleman was
stating in regards to having a SAN solution?

>--Original Message--
>You may deploy it on SAN
>.
>
|||You can store SQL data on a SAN. It is generally the best way to build a
cluster.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jeff" <anonymous@.discussions.microsoft.com> wrote in message
news:acbc01c4369c$fd6a3290$a601280a@.phx.gbl...[vbcol=seagreen]
> I was going to have my two nodes on a SAN solution. Is
> there differences from what the other gentleman was
> stating in regards to having a SAN solution?

Active Directory and SQL 2000 clustering on W2003

Is this true that Active Directory is needed in order to cluster the SQL2000.
I have 2 Dell 6000 series with a shared Dell RAID...
Any articles or links to see how can I set this up correctly?
You need a domain, NT 4.0, 2000 or 2003. AD is not needed.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Eugene Borukhovich" <macroscape@.yahoo.com> wrote in message
news:41df378d.0408191658.1d36e56d@.posting.google.c om...
> Is this true that Active Directory is needed in order to cluster the
> SQL2000.
> I have 2 Dell 6000 series with a shared Dell RAID...
> Any articles or links to see how can I set this up correctly?
|||You do not need active directory for SQL Server 2000 Clustering on W2K3. You do need the nodes of the cluster to be members of the same domain.
Here are some links that you may find useful. These will help with the requirements of Windows and SQL Clsutering, step by step installation, what it can do and what it cannot do, troubleshooting etc.
Step-by-step instructions for creating and configuring a typical single quorum device multi-node server cluster using a shared disk on servers running the Microsoft Windows Server 2003 Enterprise Edition and
Windows Server 2003 Datacenter Edition operating systems.
http://www.microsoft.com/downloads/d...displaylang=en
SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/pro.../failclus.mspx
There are few things different for clustering SQL Server 2000 on Win2K3 and the foll. KBs are useful
Installation of a Named Instance of SQL Server 2000 Virtual Server on a Windows 2003-Based Cluster Fails
http://support.microssoft.com/?id=815431
SQL Server 2000 Cluster Does Not Install on Windows Server 2003-Based Computers Where Terminal Services Is Installed (Has better info than 327270)
http://support.microsoft.com/?id=301520
SQL Server 2000 Is Not Supported on Windows Server 2003 Terminal Server Application Server
http://support.microsoft.com/?id=327270
Virtual SQL Server 2000 Installation Fails on Cluster That Has Eight Nodes
http://support.microsoft.com/?id=811054
SQL Server 2000 support for mounted volumes
http://support.microsoft.com/?id=819546
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||So w/o actually reading through all the links yet and to confirm that
there is no dependencies on the AD at all. When you say "domain" - can
it be a workgroup?
this will be in a highly secure environment, so i dont want any AD nor
these SQL servers even joining the AD.
Thanks, Eugene B
|||Clustered SQL Servers must have a common security context. This means they
must be member servers of an NT4 or AD domain. A common workgroup will not
work.
I am concerned that you see AD as a security problem rather than a solution.
Perhaps your system administrators do not fully understand how to implement
AD in a highly secure environment.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Eugene Borukhovich" <macroscape@.yahoo.com> wrote in message
news:41df378d.0408250542.71ac947e@.posting.google.c om...
> So w/o actually reading through all the links yet and to confirm that
> there is no dependencies on the AD at all. When you say "domain" - can
> it be a workgroup?
> this will be in a highly secure environment, so i dont want any AD nor
> these SQL servers even joining the AD.
> Thanks, Eugene B
|||You can't have it on a workgroup. It must be on a domain - AD or NT. If
you really want security, then you'll have to put it within its own forest
and set up a one-way trust.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Eugene Borukhovich" <macroscape@.yahoo.com> wrote in message
news:41df378d.0408250542.71ac947e@.posting.google.c om...
So w/o actually reading through all the links yet and to confirm that
there is no dependencies on the AD at all. When you say "domain" - can
it be a workgroup?
this will be in a highly secure environment, so i dont want any AD nor
these SQL servers even joining the AD.
Thanks, Eugene B
|||Hi ,
I am trying to install cluster SQL2000 on a WIN2003MSCS. Are there any
links to step by step procedure. Install on a WIN 2000 is quite
different.WIN 2003 cluster service is setup and running. Any
documentations on a SQL virtual server setup will be much appreciated.
Thank you
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||There are few things different for clustering SQL Server 2000 on Win2K3 and the foll. KBs are useful
Installation of a Named Instance of SQL Server 2000 Virtual Server on a Windows 2003-Based Cluster Fails
http://support.microssoft.com/?id=815431
SQL Server 2000 Cluster Does Not Install on Windows Server 2003-Based Computers Where Terminal Services Is Installed (Has better info than 327270)
http://support.microsoft.com/?id=301520
SQL Server 2000 Is Not Supported on Windows Server 2003 Terminal Server Application Server
http://support.microsoft.com/?id=327270
Virtual SQL Server 2000 Installation Fails on Cluster That Has Eight Nodes
http://support.microsoft.com/?id=811054
SQL Server 2000 support for mounted volumes
http://support.microsoft.com/?id=819546
How to Configure Microsoft Distributed Transaction Coordinator on a Windows Server 2003 Cluster
http://support.microsoft.com/?id=301600
How to enable Network DTC access in Windows Server 2003
http://support.microsoft.com/?kbid=817064
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx