cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aaron Morton <>
Subject Re: What would be a good strategy for Storing the large text contents like blog posts in Cassandra.
Date Sun, 06 Mar 2011 23:40:12 GMT
Sounds reasonable, one CF for the blog post one CF for the comments. You could also use a single
CF if you will often read the blog and the comments at the same time. The best design is the
one that suits how your app works, try one and be prepared to change.

Note that counters are only in the 0.8 trunk and are still under development, they are not
going to be released for a couple of months.

Your per column data size is nothing to be concerned abut.

Hope that helps.

On 7/03/2011, at 6:35 AM, Aditya Narayan <> wrote:

> What would be a good strategy to store large text content/(blog posts
> of around 1500-3000 characters)  in cassandra? I need to store these
> blog posts along with their metadata like bloggerId, blogTags. I am
> looking forward to store this data in a single row giving each
> attribute a single column. So one blog per row. Is using a single
> column for a large blog post like this a good strategy?
> Next, I also need to store the blogComments which I am planning to
> store all, in another single row. 1 comment per column. Thus the
> entire information about the a single comment like  commentBody,
> commentor would be serialized(using google Protocol buffers) and
> stored in a single column,
> For storing the no. of likes of each comment itself,  I am planning to
> keep a counter_column, in the same row, for each comment that will
> hold an no. specifiying no. of 'likes' of that comment.
> Any suggestions on the above design highly appreciated.. Thanks.

View raw message