In any "real word" MySQL use, a SSD will outperform a classic HDD a million times better (exaggerated a bit). The newer SSD's on the market like the Intel S3500, Samsung 840 pros, etc. etc., have the ability to last for years and years without failing, so any of those stories you have heard are...