On Tue, 20 Mar 2007 at 11:20am, Florin Andrei wrote
Analysis and reporting tool with a large MySQL backend. It also serves as a transient backup server for that data. I need MySQL to _fly_ on that RAID array, since the data set is pretty big. I wrote pretty much all software and did the DB schema, so I have true full control over what's running on that machine.
I think I can go with the "throw more hardware (bigger disks) at the problem" approach and use RAID1 instead of RAID5. That should give a boost to the read performance, in theory. I need to do some tests and figure out what works best in this particular case.
IMO, you do *not* want RAID5 there. RAID10 is likely to work best.
I was wrong with the requirements, it's not PCI, it's PCI Express x16
For 3ware, then, that's 9590 or 9650.
There's not much room in the system, it's a 1U. I think I can fit a full-height card in it, but it must not be too bulky.
Erm, how many spindles can you fit in that 1U? 4 is the most I've seen.