Raid 0 on database server

 
Thread Tools Search this Thread
Special Forums Hardware Raid 0 on database server
# 1  
Old 12-17-2010
Raid 0 on database server

Hi guys.

if we want to use SSD drives on a database server, can we use RAID 0 configuration because of their reliability?
# 2  
Old 12-17-2010
Raid 0 for database is not good option.
if you have enough resources .. its always good to go with raid 1+0
or raid 5.
This User Gave Thanks to mtomar For This Post:
# 3  
Old 12-29-2010
Quote:
Originally Posted by mtomar
Raid 0 for database is not good option.
if you have enough resources .. its always good to go with raid 1+0
or raid 5.
I would advise against RAID5 if performance is what you're after. RAID5 is known to be slow because of its design.
The answer also cannot be that simple, unless we know the DB type and the typical usage. You should also pick the best hardware based on the response, as you need to plan capacities.
# 4  
Old 04-10-2011
With SSDs, really the only noticeable difference between them being in RAID 0, and being lone discs would be simplicity of just having one main disc, as opposed to a lot of different discs.

The only problem with RAID and SSDs is that AHCI mode needs to be enabled for TRIM support. Therefore, the RAID array will need to be declared in the OS, (the only OS that I've done it on so far is [cringe] Windows [/cringe] and that was a small nightmare) which can be done with mdraid. Also I've found that Linux doesn't even like to install onto a hardware-defined RAID array, I'm sure you could do it if you tried hard enough though, so you would need a separate boot disc for two reasons now (the OS defined array, and the Linux not liking RAID 0 instillations)

Another thing that should be mentioned is that although you are using SSDs, if you are making an OS defined array, the boot time will be drastically increased for every disc that you add to the array. However, this should not be all that much of a problem for a datacenter.

I hope this helps, good luck!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

Is it mandatory or not to stop/start Applcation server ehen Restarting Database Server?

Good afternoon I need your help please. There is a Mantenance Windos which needs to Restart de Database Server 192.x.x.97 to set up some configuration Is it mandatory or not to stop/start Applcation server that runs in 192.x.x.95 ? Is it mandatory or not to stop/start apache and Tomcat?... (3 Replies)
Discussion started by: alexcol
3 Replies

2. SCO

Backup/RAID of HD on Old UNIX Server

I need to be able to make a backup image of an OLD UNIX server HD where I can restore the complete HD from scratch if (when) the HD fails. This server runs the accounting system for a company. I can and have backed the data up via local FTP, but O/S and Apps are so old that I am not sure I could... (21 Replies)
Discussion started by: chrishouse
21 Replies

3. Hardware

3ware RAID server

We have a 3ware RAID server at work, and as the appointed systems administrator (by virtue of being the one with the most knowledge) I've taken on the job of maintaining it. I've installed smartmontools on it to keep an eye on the drives and run scans every day, and looking at the data from the... (0 Replies)
Discussion started by: Krendoshazin
0 Replies

4. Solaris

Checking RAID health, metastat returns "no database"

Hello, I am supposed to check the RAID health of a system but when I type metastat it says "there are no existing databases" Does this mean that there is no RAID configured at all? Is there any other utility I should try? I know the system has two disks. Tanks! (8 Replies)
Discussion started by: cevspencer
8 Replies

5. Linux

Help Setting up Linux Raid Server

I just built a home computer with 3TB hard drives I wanted to set up in a RAID 5 and load Ubuntu server onto it. The first thing I did was set up the drives in a RAID 5 using just the motherboard chipset software to do it, so a 'hardware' RAID basically. I installed Windows first to see if... (2 Replies)
Discussion started by: lorewap3
2 Replies

6. Hardware

Hardware RAID on Sun T2000 Server

Hi All I have a Sun T2000 server. Couple of years ago I had configured and mirrored the boot drive with an other drive using hardware RAID 1 using raidctl command. Following is the hardware RAID output. root@oracledatabaseserver / $ raidctl RAID Volume RAID RAID Disk... (0 Replies)
Discussion started by: Tirmazi
0 Replies

7. UNIX for Dummies Questions & Answers

efficient raid file server

I need to put together a RAID1 file server for use by Windoze systems. I've built zillions of windows systems from components. I was a HPUX SE for a long time at HP, but have been out of the game for years. I've got an old workhorse mobo FIC PA-2013 with a 450 MHz K6 III+ I could use, but I'd... (2 Replies)
Discussion started by: pcmacd
2 Replies

8. Red Hat

linux server with raid controller card

I am planning on building a fedora box with raid controller (database server). Is anybody done that ? also what kind of software do you need to backup and recover data. (1 Reply)
Discussion started by: amir07
1 Replies

9. Filesystems, Disks and Memory

Adding RAID to server

Hi, I have a server that I am adding a RAID that we purchased to. The server works fine. It is running Fedora 7 and is a Dell Precision 690. When the RAID is attached, it boots up and says the following: Controller Bus #00, Device#1F, Function#02: 00 Ports No device found AHCI BIOS not... (0 Replies)
Discussion started by: user23
0 Replies

10. Filesystems, Disks and Memory

2-Ch RAID Problem in SCO Open Server

Help, if possible. In SCO Open Server with installation of two-channel RAID controller the following happens: on the channel 0 disk array is seen by an operational system, and on the channel 1 array is not seen (simultaneously). That is the operational system can not simultaneously use more than... (1 Reply)
Discussion started by: pko60
1 Replies
Login or Register to Ask a Question