Solved

Best Raid configuration for Datbase server?

Posted on 2008-06-24
10
349 Views
Last Modified: 2010-05-18
Hi,

i am loking to buy a new database server and was wondering what is the best way to set it up?  Should I have a raid 1 config for the OS and a raid 10 for data and logs or just lump the whole lot on a raid 10 using all the drives?  I was looking at using 8 drives on a dell power edge 2900 iii or a HP ML370 G5.  Any other thoughts as to hardware suitabilty would be much appreciated.

Thanks
0
Comment
Question by:WannabeNerd
  • 3
  • 3
  • 2
  • +1
10 Comments
 
LVL 60

Expert Comment

by:chapmandew
Comment Utility
Definetly raid 10 on the data and log drives.  For the OS, I assume raid 1 is OK, but I've always used RAID 10 for that as well.
0
 

Author Comment

by:WannabeNerd
Comment Utility
But is their any advantage to splitting them into 2 arrays or just leaving them as 1 raid 10 array?
0
 
LVL 60

Assisted Solution

by:chapmandew
chapmandew earned 100 total points
Comment Utility
Well, since the log is always written to sequentially, and the data files are random, you could see performance gains if you have two separate arrays for the logs and the data.
0
 
LVL 25

Expert Comment

by:slam69
Comment Utility
just to add something in here raid1+0 is def the optimum IF you have the sustainability of space and you can afford the redundancy loss of space issue, in a raid1+0 configuration only 25 % of your space can be used for data capture the rest is used in back up and redundancy. if you choose to use an 8 bay configuration then you are limiting yourself, building an array is going to be a better choice and yup speerate the logs from the data to stop bottlenecks and optimise the speed.

Again depending on the growth you are expecting will detect the choices

also, do you have a requirement of having a high availability production enevironement, if so then again raid1+0 is a good choice but if you want to optimise redundancy against cost effectiveness then Raid 5 can always be considered, especially if you choose the power edge, use 3 striped drives+1 you can hot swap and rebuild a failing drive, or even raid6 allows for the failure of 2 drives but you increase your loss of disk space for redundancy

raid1+0 is the dream set up for all DB, but its effectiveness and availability positives have to be balanced against cost and enterprise implications.

if thats all a bit foggy let me know
0
 
LVL 8

Expert Comment

by:PaperTiger
Comment Utility
what kind of database? how many users? how much data? what application? how much downtime and data loss can you tolerate?
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:WannabeNerd
Comment Utility
SQL database with about 100 users, 6gig.  I am looking to have as good a performance as possible with raid config and redundant power supplies.
0
 
LVL 25

Accepted Solution

by:
slam69 earned 200 total points
Comment Utility
the redundant power supplies here is not the issue. if you had a fail of one of teh drives would having an immediate swap over be necessary for you and no loss of down time or would be happier with a 100% recovery of data but a little downtime whilst a disc was rebuilt saving you a few $$ in the process?

That size database is not huge i woul drun it as a raid5 with a 3+1 drive configuration for your drives a raid 1 for your log files over 2 discs and then have your OS on one partition leaving one disc space free for future development, that size DB is not huge and easily manageable. i think raid1+0 might be using a sledgehammer to open a peanut in this case but saying that if you need 24/7 365 days a year availability then consider it
0
 
LVL 8

Assisted Solution

by:PaperTiger
PaperTiger earned 200 total points
Comment Utility
how much money do you have to use? also you didn't answer what kind of application you will run or how much downtime/data loss you can afford.

For 100 users, 10GB data size, actually any machine on the market will do. The PowerEdge will do fine. I would also look into x3650 from IBM - i like their support. both are a little over-powered, but hey, you can buy one for less than $4000 from eBay anyway.

RAID 10 is an overkill. RAID 1 for the OS/app and RAID 5E for data should be more than sufficient, even RAID 5 would be fine.

**************
the real concern is what kind of application and what kind of data loss/downtime can you tolerate.

0
 

Author Comment

by:WannabeNerd
Comment Utility
Spoke to Hp experts and they recommended 3 arrays using 6 hdds all raid1.  I have the budget so am gonna go for raid 10 on the data although they said i wouldnt see much difference unless the database grows and number of users increase.  Thanks for your help as what you guys are saying confirms what hp say.
0
 
LVL 8

Expert Comment

by:PaperTiger
Comment Utility
You do know RAID 1 would be difficult to grow should your data size grows over your hard drive limit.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now