Re: multiple clusters on single quorum drive

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I had another thought regarding the new cluster. My plan is to have
mirrored disks for the sql logs and a seperate raid set for the data.
My thought is, why not partition the mirrored set and have the quorom
on one partion and the logs on another. Any thoughts on this?


On Sep 26, 7:07 am, "Justin Rich" <jrich...@xxxxxxxxxxxxxx> wrote:
There is no difference, if you are setting up a cluster you are probably
going to do it right, and by that I mean you are going to use two of the
smallest disks you can find and mirror them and use them only for the
quorum. Its actually difficult to get a 36GB disk so basically you are
wasting two 72GB drives for this at the least.

MS recommends 500MB not because that's what the quorum needs for space but
because that is the smallest optimal NTFS partition size. My quorums are
about 10MB on my prod DB systems.

I was simply providing information. If the user is asking if they can share
it, then perhaps disk space is an issue.

Also there would be nothing wrong with using those two mirrored disk for
multiple clusters by making different LUNs. I know the activity is pretty
low on those disks but depending on the disk and backend you could probably
use those disks for quite a few clusters. Probably not 144 clusters though
:)

"Linchi Shea" <LinchiS...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message

news:557D9465-FF34-4796-92DE-BB3A9F31F6D7@xxxxxxxxxxxxxxxx



Point taken. But what is the masterial difference between 500MB and 1GB?

Linchi

"Justin Rich" wrote:

500MB is all you need for an optimal NTFS partition.
the Quorum itself requires very little disk space (for some reason i want
to
say its 24MB for a 2 node cluster, not really sure why i think that
though)

"Geoff N. Hiten" <SQLCrafts...@xxxxxxxxx> wrote in message
news:ehcbe6nHJHA.1308@xxxxxxxxxxxxxxxxxxxxxxx
Cluster and Quorum drive is a one-to-one relationship.

You can use a fairly small LUN for the quorum drive.  I typically use a
1-2 GB slice.

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

<shamus.sa...@xxxxxxxxxxx> wrote in message
news:1dd5cefe-18fe-4abc-abd4-45334f54e997@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I currently have an SQL 2000 active/passive cluster that has a quorum
drive.  I am planning on setting up an additonal SQL 2005 active/
passive cluster, but I have a question about the quorum drive.  Is it
possible to set this up to share the quorum drive that the original
cluster uses.  So basicly, the LUN that is presented to my original
cluster would also be presented to my new cluster.

Thanks- Hide quoted text -

- Show quoted text -

.

Relevant Pages

  • SUMMARY: changed WWID on cluster member boot disk
    ... disk and quorum disk of a single-member cluster, ... I could no longer boot from the cluster disks, ... the pre-cluster stand-alone system disk; ... the root1_domain on LUN containing the member boot disk was found ...
    (Tru64-UNIX-Managers)
  • Re: New to clustering and need some clarification on disk resource
    ... "Geoff N. Hiten" wrote: ... second node, only the primary, during a cluster install. ... Senior SQL Infrastructure Consultant ... enough disk space for all your data. ...
    (microsoft.public.sqlserver.clustering)
  • Re: New to clustering and need some clarification on disk resource
    ... The clustered disk should have MDF and LDF files. ... Did you look at the SQL setup logs to see what went wrong? ... Microsoft SQL Server MVP ... running, quorum is clustered and running, cluster is healthy and i got 29 out ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 05 ENT Cluster: not enough disk space for data files
    ... X:\Microsoft SQL Server ... I did notice that for some reason my drives are accessible (not just ... visable) to both cluster nodes (and its an active passive, ... These is not enough disk space on the destination disk for the current ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering Newbie - SAN Advice
    ... If fibre connector is used, ... single-instance cluster. ... a properly configured dedicated SQL server should ... disk set. ...
    (microsoft.public.sqlserver.clustering)