Re: Active\Active\passive setup

Tech-Archive recommends: Fix windows errors by optimizing your registry

Once again, obsolete nomenclature gives the wrong impression.

Active/Active/Passive is a meaningless definition. What you can build is a four-node, three instance cluster. Nodes are host platforms. Instances are the actual SQL Servers that use a host to execute. If a host fails, the instance fails over to another server. You cna choose which instance normally runs on which node, but SQL clustering is "shared nothing". That means that instances and nodes are completely independent of each other. You can also choose which nodes can host which instances.

So what you ask is outside the definition of SQL clustering, but you can build a system that does what you want. You end up with three separate SQL Server instances that can run on any of four nodes.

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








"MeHer" <MeHer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:AFCE6F04-5917-486C-9331-74216D4A421A@xxxxxxxxxxxxxxxx
I have 4 nodes that have tons of memmory and I wanted to get opinions for SQL
2005 clustering. I visualize the following and wonder if its possible
Server1 and Server2 have there own instances and they are Active Active and
Server1 and Server2 have another set of instances and they are
Active/passive and the same for Server 3 and Server4 is this possile?

.

Relevant Pages

  • Re: Newb Active-Passive / Active-Active Single Instance Question
    ... The Disk space is SAN storage. ... node and one virtual server. ... cluster node as it is no longer like Windows Clustering is it that SQL 2005 ... Also, SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: Using sql server clustering
    ... Clustering will give that one high availability. ... other 4 can still handle the load while you fix the one that is down. ... add more server for incoming data wich is failover cluster. ... About the servers to pull data, can i use sql server clustering in order ...
    (microsoft.public.sqlserver.clustering)
  • Re: 4 Queries about DB clustering
    ... Server clustering is available on Windows Server 2003 Enterprise Edition. ... "Single Data Store" is not a service, ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: So exactly what IS clustering?
    ... I'd go with .server and .programming for this type of question. ... Edition of SQL Server. ... There's clustering and then there's clustering. ... So I've just run the index tuning wizard over ...
    (microsoft.public.sqlserver.clustering)
  • Re: Memory Allocation - Win2k3 SP1 and SQL Server 2K SP4
    ... Microsoft SQL Server MVP ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)