From user-return-20403-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Thu Sep 1 18:46:41 2011 Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id E62B783C5 for ; Thu, 1 Sep 2011 18:46:41 +0000 (UTC) Received: (qmail 42441 invoked by uid 500); 1 Sep 2011 18:46:39 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 42347 invoked by uid 500); 1 Sep 2011 18:46:39 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 42339 invoked by uid 99); 1 Sep 2011 18:46:39 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Sep 2011 18:46:38 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of potekhin@bnl.gov designates 130.199.3.132 as permitted sender) Received: from [130.199.3.132] (HELO smtpgw.bnl.gov) (130.199.3.132) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Sep 2011 18:46:30 +0000 X-BNL-policy-q: X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AnUNAL7SX06Cx1r1/2dsb2JhbABChyWSApFfAQEFeBELBBQJFggHCQMCAQIBNBETBgIBAcFthlsEpEs X-IronPort-AV: E=Sophos;i="4.68,314,1312171200"; d="scan'208,217";a="141361862" Received: from dh05.s90.bnl.gov (HELO [130.199.90.245]) ([130.199.90.245]) by smtpgw.sec.bnl.local with ESMTP/TLS/DHE-RSA-CAMELLIA256-SHA; 01 Sep 2011 14:45:54 -0400 Message-ID: <4E5FD2E2.9020704@bnl.gov> Date: Thu, 01 Sep 2011 14:45:54 -0400 From: Maxim Potekhin Reply-To: potekhin@bnl.gov Organization: Brookhaven National Laboratory User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:6.0.1) Gecko/20110830 Thunderbird/6.0.1 MIME-Version: 1.0 To: user@cassandra.apache.org Subject: Re: hw requirements References: <4E5E6F02.7010602@bnl.gov> In-Reply-To: Content-Type: multipart/alternative; boundary="------------090901070305050505060905" X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. --------------090901070305050505060905 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Sorry about unclear naming scheme. I meant that if I want to index on a few columns simultaneously, I create a new column with catenated values of these. On 8/31/2011 3:10 PM, Anthony Ikeda wrote: > Sorry to fork this topic, but in "composite indexes" do you mean as > strings or as "Composite()". I only ask cause we have started using > the Composite as rowkeys and column names to replace the use of > concatenated strings mainly for lookup purposes. > > Anthony > > > On Wed, Aug 31, 2011 at 10:27 AM, Maxim Potekhin > wrote: > > Plenty of comments in this thread already, and I agree with those > saying > "it depends". From my experience, a cluster with 18 spindles total > could not match the performance and throughput of our primary > Oracle server which had 108 spindles. After we upgraded to SSD, > things have definitely changed for the better, for Cassandra. > > Another thing is that if you plan to implement "composite indexes" by > catenating column values into additional columns, that would > constitute > a "write" hence you'll need CPU. So watch out. > > > > On 8/29/2011 9:15 AM, Helder Oliveira wrote: > > Hello guys, > > What is the type of profile of a cassandra server. > Are SSD an option ? > Does cassandra needs better CPU ou lots of memory ? > Are SATA II disks ok ? > > I am making some tests, and i started evaluating the possible > hardware. > > If someone already has conclusions about it, please share :D > > Thanks a lot. > > > --------------090901070305050505060905 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Sorry about unclear naming scheme. I meant that if I want to index on a few columns simultaneously,
I create a new column with catenated values of these.

On 8/31/2011 3:10 PM, Anthony Ikeda wrote:
Sorry to fork this topic, but in "composite indexes" do you mean as strings or as "Composite()". I only ask cause we have started using the Composite as rowkeys and column names to replace the use of concatenated strings mainly for lookup purposes.

Anthony


On Wed, Aug 31, 2011 at 10:27 AM, Maxim Potekhin <potekhin@bnl.gov> wrote:
Plenty of comments in this thread already, and I agree with those saying
"it depends". From my experience, a cluster with 18 spindles total
could not match the performance and throughput of our primary
Oracle server which had 108 spindles. After we upgraded to SSD,
things have definitely changed for the better, for Cassandra.

Another thing is that if you plan to implement "composite indexes" by
catenating column values into additional columns, that would constitute
a "write" hence you'll need CPU. So watch out.



On 8/29/2011 9:15 AM, Helder Oliveira wrote:
Hello guys,

What is the type of profile of a cassandra server.
Are SSD an option ?
Does cassandra needs better CPU ou lots of memory ?
Are SATA II disks ok ?

I am making some tests, and i started evaluating the possible hardware.

If someone already has conclusions about it, please share :D

Thanks a lot.



--------------090901070305050505060905--