We’ve been using a 16bay raid array attached to a poweredge 1850 via non-raid scsi card as a slave. It works great and is the cheapest per GB we could find at the time. We have 5 mysql processes running as slaves on the single box. Its connected via two scsi channels. Each channel sees two 1TB partitions. Then I stripe them with lvm. The raid array itself has 1GB of cache+battery in it.
Would we see a performance increase if we have it attached to a raid card w/ cache+battery? Or would there no difference?