--- On Mon, 25/10/10, Daevid Vincent <daevid@stripped> wrote:
> From: Daevid Vincent <daevid@stripped>
> Subject: RE: Is SSD suitable for mysql server?
> To: "'mysql'" <mysql@stripped>
> Date: Monday, 25 October, 2010, 21:52
> > I guess it depends on how
> important your data is too. Quite
> > a few of the SSDs on the market have been proven to
> > honour flush requests, so if the power goes out you've
> > corrupted data.
> Uh. If you're not using a UPS battery backup then you
> deserve to loose your
> data. And if you don't have it configured to auto-power off
> when it's low
> on battery (extended outtage) then you also deserve to feel
> the resulting
> pain. (http://www.apcupsd.com/)
A UPS doesn't save you from the possibility of a server crash or any other outage
(including the UPS failing), in that instance your data is hosed anyway. You have to
make sure the data that the database thinks is comitted actually is, and for that you
need a storage medium that honours flush requests properly.
Disregarding your storage system reliability because you have a UPS is madness.