Solid state drives

[Mark Zealey]

For reference; we used some corsair drives which lasted two months on a high 
load server (lots of small writes/erases). I'd also imagine that the -E 
(http://www.intel.com/design/flash/nand/extreme/index.htm) variety of X25's are 
better than even the never -M ones; and also quite a bit more pricy. I imagine 
it mostly a case of looking to what your database does though; if its mostly 
read-only or occasion big writes (ie blocks of 512k) then you'll be using the 
ssd ideally so perhaps 5 years is realistic. A lot of this should be tunable 
with your database server anyway.

If you're just doing tonnes of writes, which is probably the main reason you'd 
want an ssd at the moment (as you can get 64gb memory reasonably cheaply and 
use that to cache the disk) then I'd still be cautious using them. In 
particular; don't think that by having 2 servers in master/failover master 
replication you'll avoid issues as if you are performing the same ops on both 
machines then you'll be wearing the ssd's at the same rate.

FusionIO also looks very interesting - much faster and supposidly longer 
lasting, however 2-3* the price. For some stats w/ mysql 
http://www.mysqlperformanceblog.com/2010/04/08/fast-ssd-or-more-memory/

Mark


On Pazartesi 19 Nisan 2010, Chris Jack wrote:
> Because it's been discussed previously on this list, I thought I might draw
>  your attention to the newish generation of SSDs:
> 
> http://www.intel.com/design/flash/nand/mainstream/index.htm
> 
> 
> 
> You can probably find the performance data you want quite easily, but the
>  key reliability data I was interested is slightly buried in section 3.5.4
>  of the technical document's datasheet: aka it's rated for 20Gb of writes
>  for a minimum of 5 years. I'm not qualified to say if they are reliable
>  enough for production databases - but I would be interested in opinions.
> 
> 
> 
> Seems to me we my be seeing the early stages of the death of mechanical
>  computing (aka the rotating disk drive).
> 
> 
> 
> There are actually reasonably affordable
>  (http://www.microdirect.co.uk/home/product/44075/Intel-X25-M-Mainstream-80
> GB-SATA-2-5-inch?source=googleps) has 80GB drives for £155 ex VAT.
> 
> 
> 
> Chris
> 
> _________________________________________________________________
> http://clk.atdmt.com/UKM/go/195013117/direct/01/
> We want to hear all your funny, exciting and crazy Hotmail stories. Tell us
>  now
>