Re:A Look at Enterprise Performance of Intel SSDs
by jonknee on Monday February 13, 2012 @03:54PM
(#3587296)
NoSQL would be what I would go for since this is the type of thing that Redis and similar excel at. Any way you can prevent writes per page view the better off you'll be. Redis gets you speeds similar to memcached but with some stuff you'd expect from a RDBS (durability, replication, etc). It's great for logging/analytics.
"Each drive in the first DB server has seen around 570GB of writes in 9 days, or roughly 63GB/day. The drives in the second DB server have gone through 1.03TB of writes in the same period of time or 114GB/day."
They're writing an incredible amount of data for what amounts to a fairly standard article/comment/forum site (which are typically very read heavy).
"Each drive in the first DB server has seen around 570GB of writes in 9 days, or roughly 63GB/day. The drives in the second DB server have gone through 1.03TB of writes in the same period of time or 114GB/day."
They're writing an incredible amount of data for what amounts to a fairly standard article/comment/forum site (which are typically very read heavy).