cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brandon Williams <dri...@gmail.com>
Subject Re: Cassandra to store logs as a list
Date Wed, 20 Jan 2010 20:56:03 GMT
2010/1/20 S├ębastien Pierre <sebastien.pierre@gmail.com>

> Hi there !
>
> I only looked briefly at Cassandra, and I would like to know how good it
> would be at storing logs. I've been using Redis and its LIST structure to
> store JSON-encoded log info, in the following fashion:
>
> redis["site:0"] = ["{'visitor':1,'referer':'http://
> ...'}", "{'visitor':1,'referer':'http://...'}]
>
> The problem is that the volume of logs is quite big, and would quickly
> exhaust the memory on the server and kill performance -- which is why I'm
> looking at Cassandra. Hence this question:
> would it be possible to store multiple (ordered) values for the same key in
> Cassandra ?
>

You could handle this equivalently in Cassandra by making the row name
'site:0', using a TimeUUIDType for the column, and JSON serialized data as
the value.

-Brandon

Mime
View raw message