Re: Active/Active/Active/Passive and Database Mirroring

SQL Clustering is a failover technology only. It does not load-balance.

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



"Chad T" <ChadT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DC9DA36B-0D19-4E7E-9CD8-03F3A71F389B@xxxxxxxxxxxxxxxx
Thank you for such a fast response.
In the active/active/active/passive configuration is it possible to load
balance the 3 instances over 3 nodes?

Ideally we would like to create 1 instance split over 3 nodes... is this
possible (see EX1) or do we have to do something like EX2?

Ex1: (1 instances - share over 3 nodes)
Node A = Instance1 (load balanced)
Node B = Instance1 (load balanced)
Node C = Instance1 (load balanced)
Node D = Passive

Ex2: (4 nodes - 1 passive = 3 instances split over 3 nodes)
Node A = Instance1 (load balanced)
Node B = Instance2 (load balanced)
Node C = Instance3 (load balanced)
Node D = Passive


"Geoff N. Hiten" wrote:

Instances are installed to the entire cluster, but can be set to prefer
certain nodes. I personally like N-1 clusters (N nodes, N-1 Instances),
just to simplfy management, but other that is not an absolute, inflexible
standard.

Each instance has completely separate resources; IP address, Data disks,
Log
Disks, TempDB, and Network Name. Each instance works and appears as a
separate and distinct SQL Server.

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



"Chad T" <ChadT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B13AE62F-89A3-405F-9F14-FE979336CC7B@xxxxxxxxxxxxxxxx
We have 4 systems that was initially planned to be joined into an
Active/Active/Active/Passive cluster with SQL 2005.

Can anyone offer a suggestion on the number of instances to install per
node?
Does each instance need seperate Disks for the Database, Logs and
TempDB?
If we stay with this configuration will Database mirroring still be an
option with the configuration once it is supported by MS.






.

Relevant Pages

  • Re: Active/Active/Active/Passive and Database Mirroring
    ... that configuration, would be 3 instances. ... As Geoff pointed out, if you ... It's a reasonable design in a four-node cluster to have three SQL2005 ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Data Loss?
    ... Is the application using Windows Authentication or SQL Server logins? ... -- "Geoff N. Hiten" wrote in message ... I was able to when the deleting took place,> and the SPID of the user or computer it came from, but apparently SPIDs> change so whoever had that number on the day the deletions occurred has a> different SPID now. ... >> Senior Database Administrator ...
    (microsoft.public.sqlserver.server)
  • Re: Maintenance PLan recommendation
    ... I support the Professional Association for SQL Server ... > I can definitely confirm that what Geoff is stating is true. ... the SQL Service account must have FULL CONTROL ... >>>Senior Database Administrator ...
    (microsoft.public.sqlserver.server)
  • Re: Scenario
    ... limited budget, but you may need to point out to management that they will ... I support the Professional Association for SQL Server ... > "Geoff N. Hiten" wrote in message ... >> Senior Database Administrator ...
    (microsoft.public.sqlserver.clustering)
  • Re: Share Database with 2 SQL Servers.
    ... Why would you need more than 900 bytes in an index key? ... Senior Database Administrator ... I support the Professional Association for SQL Server ... > -0400, Geoff N. Hiten wrote: ...
    (microsoft.public.sqlserver.clustering)