Re: highscalability.com report

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