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 242E170B8 for ; Wed, 9 Nov 2011 22:26:28 +0000 (UTC) Received: (qmail 46266 invoked by uid 500); 9 Nov 2011 22:26:26 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 46244 invoked by uid 500); 9 Nov 2011 22:26:26 -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 46236 invoked by uid 99); 9 Nov 2011 22:26:25 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Nov 2011 22:26:25 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of scode@scode.org designates 74.125.82.44 as permitted sender) Received: from [74.125.82.44] (HELO mail-ww0-f44.google.com) (74.125.82.44) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Nov 2011 22:26:17 +0000 Received: by wwh12 with SMTP id 12so1088995wwh.25 for ; Wed, 09 Nov 2011 14:25:57 -0800 (PST) MIME-Version: 1.0 Received: by 10.180.19.9 with SMTP id a9mr5126001wie.32.1320877557328; Wed, 09 Nov 2011 14:25:57 -0800 (PST) Sender: scode@scode.org Received: by 10.180.24.201 with HTTP; Wed, 9 Nov 2011 14:25:57 -0800 (PST) X-Originating-IP: [166.250.32.60] In-Reply-To: References: <60E014B3-4010-4987-BD42-CA4242675BB7@gmail.com> <1320646450.33642.YahooMailNeo@web95202.mail.in2.yahoo.com> <477F356C-DD18-46DC-8463-EF278DE9C97B@gmail.com> Date: Wed, 9 Nov 2011 14:25:57 -0800 X-Google-Sender-Auth: Av23oVMlH2p0aK6VpY5Ryr7vJoo Message-ID: Subject: Re: Will writes with < ALL consistency eventually propagate? From: Peter Schuller To: user@cassandra.apache.org Content-Type: text/plain; charset=UTF-8 X-Virus-Checked: Checked by ClamAV on apache.org > handful of nodes that I write to with a CL of QUORUM (or there abouts). If your goal is to service reads w/o waiting for remote servers, you probably would want to use LOCAL_QUORUM (quorum within a data center) or ONE for reads. That however assumes an RF of >= 3 in each data center (which means many copies in total if you have many data centers). Carefully plan how many copies you want in each DC, keeping in mind that 3+ is required for LOCAL_QUORUM to be useful, and keeping in mind that if you have only one copy per DC the latency to data will be vastly increased whenever a node is down even if temporarily. And consider whether you require that written data is guaranteed to be visible globally upon subsequent read or not. I don't know the situation, but I suspect some application logic on top of Cassandra is useful for a CDN like situation. At least if you have a lot of data and you care about cost efficiency. If it's okay to just say RF=3 per DC (so e.g. 9 copies for 3 DC:s) and e.g. use LOCAL_QUOROM for reads, and use LOCAL_QUORUM against each DC for writes (or else just having less strict consistency guarantees), then that's easy. It just won't be cost-effective if you start having to scale to lots and lots of data (or writes). -- / Peter Schuller (@scode, http://worldmodscode.wordpress.com)