incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sylvain Lebresne <sylv...@datastax.com>
Subject Re: Storing files in blob into Cassandra
Date Wed, 22 Jun 2011 08:07:12 GMT
Let's be more precise in saying that this all depends on the
expected size of the documents. If you know that the documents
will be on the few hundreds kilobytes mark on average and
no more than a few megabytes (say < 5MB, even though there is
no magic number), then storing them as blob will work perfectly
fine (which is not saying storing them externally with metadata in
Cassandra won't, but using blobs can be simpler in some cases).

I've very successfully stored tons of images as blobs in Cassandra.
I just knew they couldn't get super big because the system wasn't
allowing it.

The point with the size being that each time you will get a document,
Cassandra will have to load it (entirely) in memory to return it.

--
Sylvain


On Wed, Jun 22, 2011 at 9:22 AM, Sasha Dolgy <sdolgy@gmail.com> wrote:
> http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Storing-photos-images-docs-etc-td6078278.html
>
> Of significance from that link (which was great until feeling lucky
> was removed...):
>
> Google of terms cassandra large files + feeling lucky
> http://www.google.com/search?q=cassandra+large+files&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a
>
> Yields:
> http://wiki.apache.org/cassandra/FAQ#large_file_and_blob_storage
>
>
> --- store your images / documents / etc. somewhere and reference them
> in Cassandra.  That's the consensus that's been bandied about on this
> list quite frequently.  we employ a solution that uses Amazon S3 for
> storage and Cassandra as the reference to the meta data and location
> of the files.  works a treat
>
>
> On Wed, Jun 22, 2011 at 9:07 AM, Damien Picard <picard.damien@gmail.com> wrote:
>> Hi,
>>
>> I have to store some files (Images, documents, etc.) for my users in a
>> webapp. I use Cassandra for all of my data and I would like to know if this
>> is a good idea to store these files into blob on a Cassandra CF ?
>> Is there some contraindications, or special things to know to achieve this ?
>>
>> Thank you
>

Mime
View raw message