Return-Path: Delivered-To: apmail-incubator-cassandra-user-archive@minotaur.apache.org Received: (qmail 8066 invoked from network); 12 Dec 2009 23:08:41 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 12 Dec 2009 23:08:41 -0000 Received: (qmail 77798 invoked by uid 500); 12 Dec 2009 23:08:40 -0000 Delivered-To: apmail-incubator-cassandra-user-archive@incubator.apache.org Received: (qmail 77743 invoked by uid 500); 12 Dec 2009 23:08:40 -0000 Mailing-List: contact cassandra-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cassandra-user@incubator.apache.org Delivered-To: mailing list cassandra-user@incubator.apache.org Received: (qmail 77734 invoked by uid 99); 12 Dec 2009 23:08:39 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 12 Dec 2009 23:08:39 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of ryan@twitter.com designates 209.85.222.174 as permitted sender) Received: from [209.85.222.174] (HELO mail-pz0-f174.google.com) (209.85.222.174) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 12 Dec 2009 23:08:31 +0000 Received: by pzk4 with SMTP id 4so1390914pzk.32 for ; Sat, 12 Dec 2009 15:08:10 -0800 (PST) MIME-Version: 1.0 Received: by 10.142.6.2 with SMTP id 2mr1889351wff.90.1260659289971; Sat, 12 Dec 2009 15:08:09 -0800 (PST) In-Reply-To: References: Date: Sat, 12 Dec 2009 15:08:09 -0800 Message-ID: <7c5131fa0912121508i5390615dmef66e8014bff77e2@mail.gmail.com> Subject: Re: Images store in Cassandra From: Ryan King To: cassandra-user@incubator.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org On Sat, Dec 12, 2009 at 12:05 PM, Ran Tavory 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 s= ize > of 30Mb (400k images, and growing). Cassandra looks like a performance > improvement over mogilefs (saves roundtrip, no sql in the middle) but I w= as > 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:=A0What's cassandra's sweet = spot > in terms of=A0Value 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. -ryan