We are running a MySQL server right now that sits at about 35% iowait due to the load on the server. Currently we are using it primarily for network monitoring so there is a large percentage of db writes, heavily used databases are MyISAM.
Our current server is a hyperthreaded Supermicro that just isn’t cutting it, onboard ICH6R raid 1, but lagging.
The server averages about 135 queries/s, but these spike at the five minute polling interval to around 500/600 q/s, with spikes as high as 2000 q/s. This totals around 12 million/day.
Wondering if anyone has experience and make any recommendations on whether a solid onboard array of SAS drives would be faster, than a SAN type solution using fiber channel or iSCSI? In both cases I am planning on striping the drives and running master-slave replication.
Links to some good whitepapers or other comparisons would also work for me.