Re: SAN drive config for SQL Cluster
From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 02/15/05
- Next message: tram: "Dynamic disk"
- Previous message: Geoff N. Hiten: "Re: 4 Queries about DB clustering"
- In reply to: Kamal Hassan: "Re: SAN drive config for SQL Cluster"
- Next in thread: Kamal Hassan: "Re: SAN drive config for SQL Cluster"
- Reply: Kamal Hassan: "Re: SAN drive config for SQL Cluster"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 15 Feb 2005 23:09:36 +0100
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@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kamal Hassan" <Kamal Hassan@discussions.microsoft.com> wrote in message
news:1CF126AB-D562-4706-8E90-2A2900C56C38@microsoft.com...
> 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
> >
> >
> >
- Next message: tram: "Dynamic disk"
- Previous message: Geoff N. Hiten: "Re: 4 Queries about DB clustering"
- In reply to: Kamal Hassan: "Re: SAN drive config for SQL Cluster"
- Next in thread: Kamal Hassan: "Re: SAN drive config for SQL Cluster"
- Reply: Kamal Hassan: "Re: SAN drive config for SQL Cluster"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
