Re: SAN drive config for SQL Cluster
- From: Kamal Hassan <KamalHassan@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 11 Apr 2005 08:09:03 -0700
Hi,
First, thanks for your responses which helped me to setup/running SQL
cluster in SAN. Now I have another question regarding SQL Server Clustering
and SAN.
We plan to have 2-instance (1 StandBy) Cluster running on SAN.
What would be the best RAID configuration using SAN.
Disk Drives/Space not an issue?
Any comments/feedback would be greatly appreciated.
Kamal.
"Geoff N. Hiten" wrote:
> First, backup over a LAN to disk is not a problem. I do it all the time.
> You may want a dedicated link to avoid saturating the LAN.
>
> Second, All host nodes in a cluster see the same drives with the same drive
> letters. Therefore, you must plan drive letters on a cluster-wide basis.
> The Cluster software arbitrates who can actually mount and control the
> device to avoid data corruption.
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
> I support the Professional Association for SQL Server
> www.sqlpass.org
>
> "Kamal Hassan" <KamalHassan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:3CDFE4C7-D46F-44AF-80F2-6E1204DC17FF@xxxxxxxxxxxxxxxx
> > First, thanks for your response.
> >
> > We plan to keep our existing backup server (lots of disk space...). I know
> > it will go over the LAN as oppose to SAN but until we add more drives to
> > existing SAN we plan to continue backup on backup server (online backup )
> and
> > then to TAPE.
> >
> > With regards to SQL Clustering do you see any issues with the proposed
> > configuration? I think I have read some where that in multi-instance SQL
> > clustering all nodes should have SAME drive letters. Is this true/correct?
> or
> > what are the possible issues with same drive letter or the drive letter
> > should be different across all NODES but then explain how the failover
> will
> > see/work etc.
> >
> > Please advice....
> >
> > Kamal.
> >
> > "Mike Epprecht (SQL MVP)" wrote:
> >
> > > An where are you going to put your backups?
> > >
> > > Or are you relying on tape backup software?
> > >
> > > Regards
> > > --------------------------------
> > > Mike Epprecht, Microsoft SQL Server MVP
> > > Zurich, Switzerland
> > >
> > > IM: mike@xxxxxxxxxxxx
> > >
> > > MVP Program: http://www.microsoft.com/mvp
> > >
> > > Blog: http://www.msmvps.com/epprecht/
> > >
> > > "Kamal Hassan" <Kamal Hassan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > > news:1CF126AB-D562-4706-8E90-2A2900C56C38@xxxxxxxxxxxxxxxx
> > > > I also have a question for Uttam Parui...
> > > >
> > > > I plan to install 2 node cluster (initially) and then add third and
> may be
> > > > fourth node later.
> > > >
> > > > I plan to do the following:
> > > >
> > > > 3 luns (SQL Data for each NODE1 i.e Server1, Server2, Server3) = E, F,
> G
> > > > 3 luns (2 SQL log shared by S1, S2, S3, 1 for Quorum) = S, T, Q
> > > >
> > > > Each Server has following:
> > > >
> > > > C:\ (mirrrored) = OS
> > > > D:\ (mirrored) = SQL Binary + PAGE FILE
> > > >
> > > > Server1 (Node1/Active)
> > > > Data=E:\
> > > > Log=S:\
> > > > Quorum=Q:\
> > > >
> > > > Server2 (Node2/Passive)
> > > > Data=E:\
> > > > Log=S:\
> > > > Quorum:Q:\
> > > >
> > > > Server3 (To be added later as an ACTIVE Node with Server 2 as
> > > PASSIVE/StandBy)
> > > > Data=F:\
> > > > Log=T:\
> > > > Quorum=Q:\
> > > >
> > > > First, I am not sure if this is correct for 3/4 four nodes cluster and
> if
> > > it
> > > > is how it will work/affect FAILOVER when it happens between S1 & S2 or
> S3
> > > & S2
> > > >
> > > > I would greatly appreciate if you can provide any feedback.
> > > >
> > > > Regards,
> > > >
> > > > Kamal
> > > >
> > > >
> > > >
> > > >
> > > > "Uttam Parui[MS]" wrote:
> > > >
> > > > > Use RAID 5 on read-only volumes. Any disk volume that does more than
> 10
> > > percent writes is not a good candidate for RAID 5.
> > > > > Use RAID 10 whenever the array experiences more than 10 percent
> writes.
> > > > >
> > > > > In general, for OLTP systems, RAID 10 is the best for data + logs.
> > > > >
> > > > > Regarding the original qs - as many have already answered --- have
> > > seperate luns for Quorum, msdtc, sql data, sql Tlogs, SQL backups etc.
> One
> > > huge lun is not recommended for high availability.
> > > > >
> > > > > Best Regards,
> > > > >
> > > > > Uttam Parui
> > > > > Microsoft Corporation
> > > > >
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > > >
> > > > > Are you secure? For information about the Strategic Technology
> > > Protection Program and to order your FREE Security Tool Kit, please
> visit
> > > http://www.microsoft.com/security.
> > > > >
> > > > > Microsoft highly recommends that users with Internet access update
> their
> > > Microsoft software to better protect against viruses and security
> > > vulnerabilities. The easiest way to do this is to visit the following
> > > websites:
> > > > > http://www.microsoft.com/protect
> > > > > http://www.microsoft.com/security/guidance/default.mspx
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>
.
- Follow-Ups:
- Re: SAN drive config for SQL Cluster
- From: Mike Epprecht \(SQL MVP\)
- Re: SAN drive config for SQL Cluster
- Prev by Date: Veritas backup of Share Point 2003 databases on SQL Cluster - Fail
- Next by Date: Re: SAN drive config for SQL Cluster
- Previous by thread: Veritas backup of Share Point 2003 databases on SQL Cluster - Fail
- Next by thread: Re: SAN drive config for SQL Cluster
- Index(es):
Relevant Pages
|
Loading
