Forum Search:
Forum.Brain-Cluster.com: Brain Cluster Technical Forum
Ultimate forum for Technical Discussions

Home » Microsoft » Windows Server » Server Clustering » the shared storage is a single point of failure
the shared storage is a single point of failure [message #331962] Tue, 01 December 2009 04:46 Go to next message
almatador  is currently offline almatador
Messages: 2
Registered: December 2009
Junior Member
Dear all,

I have clusterd SQl server 2005 and i see that if the shared disk becomes
unavialable then the cluster does not work.
can i setupt two shared disks te remove the single point of failure from
the shared disk?

Thanks for any answer,

almatador
RE: the shared storage is a single point of failure [message #334883 is a reply to message #331962] Thu, 03 December 2009 23:29 Go to previous messageGo to next message
Elden  is currently offline Elden
Messages: 7
Registered: July 2009
Junior Member
Upgrade to Win2008, the Quorum disk is no longer a single point of failure in
Win2008 or Win2008 R2.

Thanks!
Elden
Re: the shared storage is a single point of failure [message #345708 is a reply to message #331962] Wed, 16 December 2009 11:36 Go to previous messageGo to next message
daveberm[1]  is currently offline daveberm[1]  United States
Messages: 35
Registered: July 2009
Member
On Dec 1, 4:46 am, almatador <almata...@discussions.microsoft.com>
wrote:
> Dear all,
>
> I have clusterd SQl server 2005  and i see that  if the shared disk becomes
> unavialable then the cluster does not work.
> can i setupt  two shared disks  te remove the single point of failure from
> the shared disk?
>
> Thanks for any answer,
>
> almatador

As Elden mentioned, there are new quorum types which eliminate the
shared disk as a single point of failure. However, this does not
remove the need for a shared disk to store your application data. In
order to eliminate the shared disk as a single point of failure in all
cases, you must look at array or host based replication solutions
which integrate with failover clustering. SteelEye DataKeeper Cluster
Edition is one of the replication solutions which integrates with
failover clustering to eliminate the need for a shared disk in a
cluster. The following article gives you the step-by-step
instructions on how to cluster SQL 2008 without using a shared storage
device.

http://clusteringformeremortals.com/2009/10/07/step-by-step- configuring-a-2-node-multi-site-cluster-on-windows-server-20 08-r2-%E2%80%93-part-3/

Although the article talks about multi-site clusters, the nodes do not
have to reside in different sites. Having the nodes in the same site
eliminates the shared disk as a single point of failure. The best
possible configuration is to have a two node cluster in the local site
with a 3rd node in a remote site. This gives you local high
availability as well as an automated disaster recovery plan.

If you are interested in learning more, contact me through
http://www.steeleye.com/company/contact.php
Re: the shared storage is a single point of failure [message #368499 is a reply to message #331962] Thu, 14 January 2010 18:51 Go to previous message
Microsoft Cluster Man  is currently offline Microsoft Cluster Man  India
Messages: 1
Registered: January 2010
Junior Member
On Dec 1 2009, 2:46 pm, almatador
<almata...@discussions.microsoft.com> wrote:
> Dear all,
>
> I have clusterd SQl server 2005  and i see that  if the shared disk becomes
> unavialable then the cluster does not work.
> can i setupt  two shared disks  te remove the single point of failure from
> the shared disk?
>
> Thanks for any answer,
>
> almatador

The best thing is like suggested to go for Windows Server 2008. If not
then you need to compramise with the single point of failure.

You can have multiple shared disks as your quorum but one at a time.
You need to manually point to the quorum disk in case the earlier
quorum disk fails.
You can use your local quorum as well to create a new quorum.
Goto Forum:
  


Current Time: Sun Sep 24 15:27:02 EDT 2017

Total time taken to generate the page: 0.05148 seconds
.:: Contact :: Home ::Sitemap::.

Powered by: FUDforum 3.0.0RC2.
Copyright ©2001-2009 FUDforum Bulletin Board Software