cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Koziarski <mich...@koziarski.com>
Subject Re: Images store in Cassandra
Date Sun, 13 Dec 2009 21:55:43 GMT
On Sun, Dec 13, 2009 at 9:05 AM, Ran Tavory <rantav@gmail.com> wrote:
> As we're designing our systems for a move from mysql to Cassandra we're
> considering moving our file storage to Cassandra as well. Is this wise?
> We're currently using mogilefs to store media items (images) of average size
> of 30Mb (400k images, and growing). Cassandra looks like a performance
> improvement over mogilefs (saves roundtrip, no sql in the middle) but I was
> wondering whether the fact that cassandra stores byte arrays should
> encourage us to store images in it. Is Cassandra a good fit?

I think that mogile would probably be a much better fit here.  While
you may save a tiny bit of round-tripping, those sql queries aren't
likely going be an appreciable percentage of the total time taken to
stream the binary out to the user.

> Has anyone had any similar experience or can send guidelines?
> To phrase the question in more general terms: What's cassandra's sweet spot
> in terms of Value size per column or total row size?
> Thanks



-- 
Cheers

Koz

Mime
View raw message