On 04/12/2012 10:00 AM, Clinton Gormley wrote:
I think the bigger factor in the speed improvement is probably to do
with switching from MySQL to Redis
https://groups.google.com/group/redis-db/browse_thread/thread/77841c595d29f983?pli=1
They didn't really "switch" from mysql to redis. They are using Redis as
a structured caching layer in front of mysql. Their authoritative data
is still stored in mysql, but they have several "views" of that data
that they export regularly to redis. The site pulls these cached views
from redis and yes that's very fast.
It's kind of similar to a lot of other really big systems (like
facebook). Authoritative data in an SQL database and then their read
data in denormalized structures in a NoSQL database.
--
Michael Peters
Plus Three, LP