Mailing-List: contact cassandra-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cassandra-user@incubator.apache.org
Received-SPF: pass (athena.apache.org: domain of driftx@gmail.com designates
 209.85.221.180 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=fcFkSI2Fi5NhzFt6rlzomV6/0WBGjeqvDzjawXmnWHSbd7gri8yRmfcJpyBDb5v3dT
         m80SyiE5cmkCKgEXG2V73GFkYXWE3NZ59w1amceMViNPdGW4hTvl2yw3yTNUbScHn5TZ
         DxPrmzT2RQHgOVt6Z8nm1FZTUhnAQ70BgiHA4=
MIME-Version: 1.0
In-Reply-To: <91790a981001201231o6e346c2ct4fb687c7799fe431@mail.gmail.com>
References: <91790a981001201231o6e346c2ct4fb687c7799fe431@mail.gmail.com>
Date: Wed, 20 Jan 2010 14:56:03 -0600
Message-ID: <cdc5ad201001201256n49bd10c9ge2d1abed0ce5767c@mail.gmail.com>
Subject: Re: Cassandra to store logs as a list
From: Brandon Williams <driftx@gmail.com>
To: cassandra-user@incubator.apache.org
Content-Type: multipart/alternative; boundary=0016364186058081a3047d9ed007

--0016364186058081a3047d9ed007
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

2010/1/20 S=E9bastien 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"] =3D ["{'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

--0016364186058081a3047d9ed007
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div class=3D"gmail_quote">2010/1/20 S=E9bastien Pierre <span dir=3D"ltr">&=
lt;<a href=3D"mailto:sebastien.pierre@gmail.com">sebastien.pierre@gmail.com=
</a>&gt;</span><br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 =
.8ex;border-left:1px #ccc solid;padding-left:1ex;">
<span style=3D"font-family:arial, sans-serif;font-size:13px;border-collapse=
:collapse">Hi there !<div><br></div><div>I only looked briefly at Cassandra=
, and I would like to know how good it would be at storing logs. I&#39;ve b=
een using Redis and its LIST structure to store JSON-encoded log info, in t=
he following fashion:</div>


<div><br></div><div><font face=3D"&#39;courier new&#39;, monospace">redis[&=
quot;site:0&quot;] =3D [&quot;{&#39;visitor&#39;:1,&#39;referer&#39;:&#39;h=
ttp://...&#39;}&quot;,=A0&quot;{&#39;visitor&#39;:1,&#39;referer&#39;:&#39;=
http://...&#39;}]</font></div>


<div><br></div><div>The problem is that the volume of logs is quite big, an=
d would quickly exhaust the memory on the server and kill performance -- wh=
ich is why I&#39;m looking at Cassandra. Hence this question:</div><div>


would it be possible to store multiple (ordered) values for the same key in=
 Cassandra ?</div></span></blockquote><div><br></div><div>You could handle =
this equivalently in Cassandra by making the row name &#39;site:0&#39;, usi=
ng a TimeUUIDType for the column, and JSON serialized data as the value.</d=
iv>
<div><br></div><div>-Brandon</div></div>

--0016364186058081a3047d9ed007--