On Sat, Dec 12, 2009 at 3:08 PM, Ryan King <[email protected]> wrote: > On Sat, Dec 12, 2009 at 12:05 PM, Ran Tavory <[email protected]> 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? >> 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? > > Large objects aren't feasible without some work: > http://issues.apache.org/jira/browse/CASSANDRA-265. > > In general, if it's not suitable for a RDBMS, its probably not > suitable for Cassandra.
For what it's worth, this is where something like Amazon's S3 works pretty well. Similar key/value storage and access, but more aimed at larger payloads (and more limited number of entries). -+ Tatu +-
