As a reference:
- Crucial RealSSD C300 256GB drives.
- MySQL 5.1.5x running InnoDB tables.
- Linux (CentOS 5.5 etx3 journaled).
Is it better to use a RAID of these so that drives can be swapped in and out or get a FusionIO or RevoDrive card?
If RAID, what controller? LSI? 3Ware?
What layout? I would presume the RAID 5 hole doesn't apply as much to SSD since the rebuild time is much less. Bad assumption?
If a flash card, what card?
Better to move to Solaris and ZFS and skip the cards and pick up other goodies along with? I have only experience with Linux so the move to Solaris would be uncomfortable though doable.