Florin Andrei spake the following on 3/20/2007 11:20 AM: > Andrew Cotter wrote: >> >> What are you trying to build? > > 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. > > I was wrong with the requirements, it's not PCI, it's PCI Express x16 > > 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. > > It's a fairly new AMD 64bit machine. It will run CentOS 4.4 64bit, > possibly version 5 if the project drags its feet long enough and 5 is > released soon, and MySQL makes "official" packages for CentOS 5 soon > enough and is stable enough. Hm, that's a lot of ifs. :-/ > 3ware 9650Se is a half height card up to 8 drives, is BBU capable, and you could have raid 10 if you want some speed and reliability. -- MailScanner is like deodorant... You hope everybody uses it, and you notice quickly if they don't!!!!