Solid state drives
mspam at itsolve.co.uk
Mon Apr 19 17:46:13 BST 2010
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
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:
> 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
> GB-SATA-2-5-inch?source=googleps) has 80GB drives for £155 ex VAT.
> We want to hear all your funny, exciting and crazy Hotmail stories. Tell us
More information about the london.pm