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 6CAA44789 for ; Thu, 23 Jun 2011 19:01:28 +0000 (UTC) Received: (qmail 84845 invoked by uid 500); 23 Jun 2011 19:01:25 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 84766 invoked by uid 500); 23 Jun 2011 19:01:25 -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 84758 invoked by uid 99); 23 Jun 2011 19:01:25 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 23 Jun 2011 19:01:25 +0000 X-ASF-Spam-Status: No, hits=2.0 required=5.0 tests=FS_LARGE_PERCENT2,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of nate@datastax.com designates 209.85.210.44 as permitted sender) Received: from [209.85.210.44] (HELO mail-pz0-f44.google.com) (209.85.210.44) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 23 Jun 2011 19:01:19 +0000 Received: by pzk5 with SMTP id 5so1470134pzk.31 for ; Thu, 23 Jun 2011 12:00:58 -0700 (PDT) MIME-Version: 1.0 Received: by 10.68.29.74 with SMTP id i10mr1377410pbh.69.1308855658300; Thu, 23 Jun 2011 12:00:58 -0700 (PDT) Received: by 10.68.51.138 with HTTP; Thu, 23 Jun 2011 12:00:58 -0700 (PDT) X-Originating-IP: [64.132.24.216] In-Reply-To: <4E038A5D.8040203@gmail.com> References: <4E038A5D.8040203@gmail.com> Date: Thu, 23 Jun 2011 14:00:58 -0500 Message-ID: Subject: Re: 99.999% uptime - Operations Best Practices? From: Nate McCall To: user@cassandra.apache.org Cc: Les Hazlewood Content-Type: text/plain; charset=ISO-8859-1 As an additional concrete detail to Edward's response, 'result pinning' can provide some performance improvements depending on topology and workload. See the conf file comments for details: https://github.com/apache/cassandra/blob/cassandra-0.8.0/conf/cassandra.yaml#L308-315 I would also advise to take the time to experiment with consistency levels (particularly in multi-DC setup) and their effect on response times and weigh those against your consistency requirements. For the record, any performance twiddling will only provide useful results when comparable metrics are available for the similar workload (Les, it appears you have a good grasp of this already - just wanted to re-iterate).