best RAID solutions for data base server

jkrause6 · 03-17-2009, 08:16 PM

i have a small office environment and want to get a new network workstation. The workstation will be the personal computer for 1 employee and also serve all the other computers (5 others) files from the host. (mostly Microsoft Works files and Quickbooks files). Lots of small file reads and writes.

I like the 250 gig western digital RE3.

Was thinking of getting 2 drives in raid 1. is there any benefit in going to a 3 drive RAID 5?

with a 3 drive raid 5 if 1 drive dies will it still work?

i really want redundancy more than speed but speed is great too.

thanks.

fmw · 03-17-2009, 08:36 PM

The best approach is to use a NAS (network attached storage) for shared files in a peer to peer network. That keeps the files separated from things like the Internet and the internal function of whichever computer you intended to use for the RAID. You can put together a perfectly good NAS using something like the D-Llink DNS 321 and a couple of SATA drives in RAID 1. I have 5 computers here as well on my peer to peer network and I use that very unit. I've used the HP Mediavault in the past but it ran pretty hot and that kept me worried. I use it for backup rather than shared files but that's just the way I manage things around here. It makes a dandy "file server"

You don't need a RAID 5 for a small company. RAID 1 will do just fine. You can buy hard drives all the way up to 1.5 TB so storage capacity limitations wouldn't come into play for any non-governmental database on this planet.

Vipernitrox · 03-17-2009, 08:50 PM

if i were you i wouldn't get a nas i think they're overrated. pc's allow you with much more room for upgrades and expansions. Most of the times a nas doesn't really perform to well either.
Just setup a simple pc and use the internal raid controller (i would advice raid 5).
If you want more speed get a scsi raid controller and some 10k disks or just get some raptors and use the internal raid controller.

03-17-2009, 08:16 PM	#1 (permalink)
jkrause6 Bronze Member Join Date: Jan 2009 Posts: 26	best RAID solutions for data base server i have a small office environment and want to get a new network workstation. The workstation will be the personal computer for 1 employee and also serve all the other computers (5 others) files from the host. (mostly Microsoft Works files and Quickbooks files). Lots of small file reads and writes. I like the 250 gig western digital RE3. Was thinking of getting 2 drives in raid 1. is there any benefit in going to a 3 drive RAID 5? with a 3 drive raid 5 if 1 drive dies will it still work? i really want redundancy more than speed but speed is great too. thanks.

03-17-2009, 08:50 PM	#3 (permalink)
Vipernitrox Diamond Member Join Date: Nov 2005 Location: Hilversum, NL Age: 21 Posts: 1,095	if i were you i wouldn't get a nas i think they're overrated. pc's allow you with much more room for upgrades and expansions. Most of the times a nas doesn't really perform to well either. Just setup a simple pc and use the internal raid controller (i would advice raid 5). If you want more speed get a scsi raid controller and some 10k disks or just get some raptors and use the internal raid controller. __________________ Antec 1200 DFI LanParty LT X48-T2R Intel Q6700 @ 3.33ghz Kingston 4x1 GB DDR2 HyperX @ 800mhz 4-4-4-12 Sapphire Toxic HD 4870 1GB 150Gb WD Velociraptor 10K rpm 3x1Tb Samsung Spinpoint in Raid 5 WC set: EK Supreme Plexi + TFC Xchanger 240 + Laing MCP 355 Pic

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Server 2000 and SATA Raid	compaqman	Computer Networking and Servers	1	07-07-2008 06:53 PM
Please can you help me select an appropriate server for my small business?	vishy01234	Computer Networking and Servers	7	06-08-2008 10:49 AM
DX 10 for Vista!?	ADE	Computer Games and Consoles	15	03-09-2007 01:58 PM
microdrive raid in a micro sized server	tri-gate trinovant	Desktop Computers	5	02-08-2006 04:41 PM
Raid Server Board	lerch	Motherboards	1	07-01-2005 05:35 PM

03-17-2009, 08:36 PM	#2 (permalink)
fmw Gold Member Join Date: Aug 2008 Posts: 474	The best approach is to use a NAS (network attached storage) for shared files in a peer to peer network. That keeps the files separated from things like the Internet and the internal function of whichever computer you intended to use for the RAID. You can put together a perfectly good NAS using something like the D-Llink DNS 321 and a couple of SATA drives in RAID 1. I have 5 computers here as well on my peer to peer network and I use that very unit. I've used the HP Mediavault in the past but it ran pretty hot and that kept me worried. I use it for backup rather than shared files but that's just the way I manage things around here. It makes a dandy "file server" You don't need a RAID 5 for a small company. RAID 1 will do just fine. You can buy hard drives all the way up to 1.5 TB so storage capacity limitations wouldn't come into play for any non-governmental database on this planet.