Re: 2 node cluster without shared storage

#1

On Windows 2000/2003 and SQL 7/2000, shared storage/SAN.

Microsoft's implementation is not a shared nothing.

Once Yukon is out, you can use database mirroring, but that is still a long
way off.

--
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike (AT) epprecht (DOT) net

Specialist SQL Server Solutions and Consulting

MVP Program: http://www.microsoft.com/mvp

"Morten" <usenet (AT) kikobu (DOT) com> wrote

Quote:

Hi.

If I run two SQLServers at two different locations, allowing only
network traffic between them (ie. no shared storage/SAN), what options
do I have for providing fail-over?

Would I need to run an OS level cluster?

Any pointers greatly appreciated,

Morten

#2

Yes, this is completely off. MNS clustering is a new feature for new types
of applications. SQL server requires shared storage. MNS clusters do not
work with SQL.

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

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

"Morten" <usenet (AT) kikobu (DOT) com> wrote

Quote:

Mike Epprecht (SQL MVP) wrote:

On Windows 2000/2003 and SQL 7/2000, shared storage/SAN.

Microsoft's implementation is not a shared nothing.

I found a document on MS' site (link below) on "Windows Server 2003
Clustering" that mentions "Majority node set (MNS) server clusters store
the quorum on a locally attached storage device connected directly to
each of the cluster nodes" - as far as I can read, this will accomplish
what I look for, only I need to upgrade the setup to 3 nodes. Is this
completely off?

Thanks!

Morten

http://www.microsoft.com/windowsserv...m/default.mspx
Click BDMTDM.doc

#3

Actually, its not that "SQL requires shared storage" as much as clustered
SQL only supports storage that appears common between the nodes.

For example, you can use GeoCluster (www.nsisoftware.com) which replicates
the data between each node's local copy. Each node has its own X: or M:,
but the Cluster Administrator will offer it to applications as a shared
resource, available to only one node or the other. However, in actuality
each node does have its own physical X: so that the storage solution is not
a single point of failure within MSCS.

jason

"Geoff N. Hiten" <SRDBA (AT) Careerbuilder (DOT) com> wrote

Quote:

Yes, this is completely off. MNS clustering is a new feature for new
types
of applications. SQL server requires shared storage. MNS clusters do not
work with SQL.

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

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

"Morten" <usenet (AT) kikobu (DOT) com> wrote in message
news:eoAcUlNaEHA.556 (AT) tk2msftngp13 (DOT) phx.gbl...
Mike Epprecht (SQL MVP) wrote:

On Windows 2000/2003 and SQL 7/2000, shared storage/SAN.

Microsoft's implementation is not a shared nothing.

I found a document on MS' site (link below) on "Windows Server 2003
Clustering" that mentions "Majority node set (MNS) server clusters store
the quorum on a locally attached storage device connected directly to
each of the cluster nodes" - as far as I can read, this will accomplish
what I look for, only I need to upgrade the setup to 3 nodes. Is this
completely off?

Thanks!

Morten

http://www.microsoft.com/windowsserv...m/default.mspx
Click BDMTDM.doc

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

Re: 2 node cluster without shared storage

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

Re: 2 node cluster without shared storage - 07-13-2004 , 07:35 AM

Re: 2 node cluster without shared storage - 07-13-2004 , 08:19 AM

Re: 2 node cluster without shared storage - 07-28-2004 , 01:02 AM