I have two 2X 73 GB SCSI in raid 1

Depends what you will use it for but generally RAID10 is a good choice.. safer and faster than raid5 although costs a bit more.

We used to use raid5 on a fileserver with a fairly big array (nearly 5TB in 24 disks) but performance sucked and when so many disks are involved things can and do go wrong. We switched to raid10 and its all so much better.. server loads are down, traffic is up and data is safer.. everyone is happy. ;)

New cards in the market are removing this problem, see the Netcell SPU for an example of that.

"Revolution storage processing cards feature a revolutionary 100% hardware-based 64-bit RAID engine that offers a mainstream RAID solution with the simultaneous benefits of both RAID 0-class performance and RAID 5-class data protection."

http://tweakers.net/reviews/557/25

There is a great review there, and look at the mySQL results, this is in a mixed environment as well, so lots of read and writes where I'm mostly in the 25-30% write for our forums.

This is a very thorough test and the Areca ARC-1160 with 1GB cache shows a huge lead over most other cards in the test.

RAID 10 will beat RAID5 in HEAVY write tests, but in our scenario RAID5/10 arrays are very close to the same, at least for me in my < 30% write scenario. Your mileage MAY vary, I generalized a bit too much in my earlier posts.

FYI also:

The new ARC-1220/1230/1260 uses Intel? IOP333 I/O processor. So XOR calculations should be even better improving database performance. The review above was on the 1160, which uses an older I/O processor.

with 8 or more drives, they are close. The big speed issue that most people here will see isnt a processor based issue though. Most people dealing with hosting on a non enterprise level will have issues due to their raid arrays being only 3 or 4 drives. As this forces 2 writes onto one drive for every write to the array. This hurts write performance badly.

With enough drives raid5 is certainly a good choice. And a lot of buffer help. some EMC sans I work with have 32 or 64 GB of buffering. that makes a huge performance boost.

EMC/Netapps are great, wish I could afford to run MySQL on that hehe.

I've had a netapp before and its only great until it comes time to buy another shelf of disks and then they slap you with the $25k bill.. :ermm:

These days I'd go for a SATABlade or some other Nexsan servers.. the SATABeast is truely a beast.

I am buying up Sun D-1000 and A-1000 drive arrays at the moment. cheap on ebay and they are solid hardware. Good for hosting.

EMC is nice... but not the price point you want for hosting.

My webserver runs 10k dual SATA drives (RAID 1) for backup purposes.

I am going to start building a deciated DB server. The DB is over 1GB as it sits and I dont see it going anywhere but up.

Right now my vauge plans were just dual dual-core Opterons, nice Tyan mobo, 4GB RAM, and some sort hard drive solution.

What would be best? U320, SAS, or SATAII?

For a DB server RAID 10 would be the best for performance and
redundancy?