Recommendation for SCSI RAID card?
I'm hoping some people here can give me recommendations on SCSI RAID cards. My minimum requirement is that it can handle 10 U160 SCSI drives per channel. 2 or more channels per card would be nice, but not necessary. I've discovered that the Dell PERC3/DC using the Megaraid driver is unstable under high loads, so something similar from Adaptec or 3WARE would be ideal. On-card cache RAM isn't really necessary, 64-bit PCI would be nice. This will be used in a MySQL database server. I realize that the Linux kernel supports a lot of hardware RAID controllers, but I'm hoping for some recommendations from people with real-world experience.
In case you're wondering if I've considered software RAID, the answer is yes. It's great, except when it comes to recovering from a failed drive without a reboot. Then it's a pain in the ass. If I have 3 drives (sda, sdb, and sdc) and sdb fails, I can pull it, replace it, and force a SCSI bus rescan through an awkward mechanism involving /proc/scsi, but then the new drive shows up as sdd, not sdb. It just seems so clumsy compared to hardware RAID that just handles everything behind the scenes.