DB Clustering or Load Balancing

#51

Clustering has a single data store that is connected to multiple host units.
The LUNs (logical partitions that map as disk drives) are arbitrated by the
cluster service. One node fails and another picks up the instance (and
associated resources) and runs.

Database mirroring pushes the data to a second machine. This can be done
synchronously or asynchronously. Each tecnhique has benefits and
constraints. One universal is the mirror database (the database on the
second machine) is not available for work, but you can create a read-only
static snapshot to make the data readable.

Both are techniques for implementing a more highly available database
infrastructure.

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

"tommypa" <u46176@uwe> wrote

Quote:

Can you explain the difference btwn clustering and mirroring and what the
advantages are? I appreciate your input this is very helpful.

Geoff N. Hiten wrote:
"Active-Active" means two separate active instances, each with unique data
sets. There is no native shared-database scale-out architecture for SQL
Server.

See I read this,

[quoted text clipped - 61 lines]
Ragards,
Tommy

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

DB Clustering or Load Balancing

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

Re: DB Clustering or Load Balancing - 09-12-2008 , 03:45 PM