Return-Path: Delivered-To: apmail-incubator-cassandra-user-archive@minotaur.apache.org Received: (qmail 56324 invoked from network); 12 Dec 2009 20:06:11 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 12 Dec 2009 20:06:11 -0000 Received: (qmail 72883 invoked by uid 500); 12 Dec 2009 20:06:11 -0000 Delivered-To: apmail-incubator-cassandra-user-archive@incubator.apache.org Received: (qmail 72851 invoked by uid 500); 12 Dec 2009 20:06:10 -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 72840 invoked by uid 99); 12 Dec 2009 20:06:10 -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 20:06:10 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of rantav@gmail.com designates 209.85.218.210 as permitted sender) Received: from [209.85.218.210] (HELO mail-bw0-f210.google.com) (209.85.218.210) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 12 Dec 2009 20:06:02 +0000 Received: by bwz2 with SMTP id 2so1342782bwz.20 for ; Sat, 12 Dec 2009 12:05:42 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=E6p5BzGOBZQITP/8BBjDTdIJoGCAxHAhQwOpQ4cAhKc=; b=DJ7GRm+Ksd6Z03AGwaesLjTmcLv/14wgZSSvlrwnLd1IH+yK735aq1zbzdN0878Ei+ laj/h/G6J607bvz9x5caUipWTjGmyqGDAKkHJ/e+VT0YXn7J0MDZ2+YUAc3oZiOaFf4P gDLKMa9Ww7JLG2Vr/44GpZTCug7A3U6C7xhbA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=WWhVGfGJ/HRMrZcIHkYG2GAxwlgh6F+ODzLx1P8WmIAIFpiBdChK7XEYXnqmAHA5T/ ykzUuqW+lNzUTsByK45hqTZf7h8DxL8C/TGomPWWEWs19RYJJ5ovZMM39jWcENtTZFc4 nP/Eri2AZ2Lefp/h4CODgFb7Y2PP0zbHCNjd4= MIME-Version: 1.0 Received: by 10.204.34.75 with SMTP id k11mr1663183bkd.105.1260648341978; Sat, 12 Dec 2009 12:05:41 -0800 (PST) Date: Sat, 12 Dec 2009 22:05:41 +0200 Message-ID: Subject: Images store in Cassandra From: Ran Tavory To: cassandra-user@incubator.apache.org Content-Type: multipart/alternative; boundary=0022154015929c3eac047a8d9080 X-Virus-Checked: Checked by ClamAV on apache.org --0022154015929c3eac047a8d9080 Content-Type: text/plain; charset=UTF-8 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 size of 30Mb (400k images, and growing). Cassandra looks like a performance improvement over mogilefs (saves roundtrip, no sql in the middle) but I was 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: What's cassandra's sweet spot in terms of Value size per column or total row size? Thanks --0022154015929c3eac047a8d9080 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
As we're designing our systems for a move from mysql t= o Cassandra we're considering moving our file storage to Cassandra as w= ell. Is this wise?

We're currently using mogilefs to= store media items (images) of average size of 30Mb (400k images, and growi= ng). Cassandra looks like a performance improvement over mogilefs (saves ro= undtrip, no sql in the middle) but I was wondering whether the fact that ca= ssandra stores byte arrays should encourage us to store images in it. Is Ca= ssandra a good fit?
Has anyone had any similar experience or can send guidelines?
To phrase the question in more general terms:=C2=A0What's cassandra&#= 39;s sweet spot in terms of=C2=A0Value size per column or total row size?
Thanks
--0022154015929c3eac047a8d9080--