List:General Discussion« Previous MessageNext Message »
From:Glyn Astill Date:October 26 2010 9:10am
Subject:RE: Is SSD suitable for mysql server?
View as plain text  
--- 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
> not 
> > honour flush requests, so if the power goes out you've
> got 
> > 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.


      
Thread
Is SSD suitable for mysql server?wroxdb25 Oct
  • Re: Is SSD suitable for mysql server?Johan De Meersman25 Oct
    • Re: Is SSD suitable for mysql server?Glyn Astill25 Oct
      • Re: Is SSD suitable for mysql server?Warren Young25 Oct
      • RE: Is SSD suitable for mysql server?Daevid Vincent25 Oct
        • RE: Is SSD suitable for mysql server?Glyn Astill26 Oct
    • Re: Is SSD suitable for mysql server?Warren Young25 Oct
      • Re: Is SSD suitable for mysql server?Joerg Bruehe26 Oct
  • Re: Is SSD suitable for mysql server?mos26 Oct