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 44F8C17D29 for ; Thu, 2 Apr 2015 14:31:05 +0000 (UTC) Received: (qmail 78019 invoked by uid 500); 2 Apr 2015 14:24:05 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 71426 invoked by uid 500); 2 Apr 2015 14:24:02 -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 62535 invoked by uid 99); 2 Apr 2015 13:58:15 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Apr 2015 13:58:15 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of rolo@pythian.com designates 209.85.213.181 as permitted sender) Received: from [209.85.213.181] (HELO mail-ig0-f181.google.com) (209.85.213.181) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Apr 2015 13:57:51 +0000 Received: by igcau2 with SMTP id au2so49777039igc.1 for ; Thu, 02 Apr 2015 06:57:49 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:content-type; bh=L56pPB4+yGB/NEaUyNy9QRcnKjfKuOAwxqLA3F4D4YY=; b=UkC4IUPIIeTfmEW9ZP6POSTO2rsFNd7b7ciYvzYrilTUVJINOtl+gyVsji8j1O4e25 RUMRtB6VZk3tm/ZcdrQu3zCyz7Ju+w64kiUuVLVm8Qv8tX4r2VKxvVvLCAnwI1MbRc44 3pBTqoLdVCJrac9Wc+QNExFn4M0AzMKkCaWjqe8OpSTUpYuJwWaJ8I2oEUxaBbGefidP GFCS/kCb/5J8oKbG+z1TtJLXNJlIl8kMkKHYflWdTDyA1d8GnDm/GuFRE2oGRTNjPRaH qkIhl9eUk1TnmwBxY1/r88lGaRvi8nc0XDU/6LvV1SOxe7QVHDrLbSI0LkUzcOVG7ymf KQ0g== X-Gm-Message-State: ALoCoQmH4p3FsILLgfjxHc6/GIsUaCHsj5vKdB1PW5a9BzHVAQoJjmt5iuMsH4F0g0ocQrO7Y/3WPXvTfBPjIGt0i1XX/lJ8O78rU9Uq38B+lSIhSmLkEdSinWAm7vCFo3PhWZ67r3Q/ X-Received: by 10.42.147.9 with SMTP id l9mr79769323icv.41.1427983069268; Thu, 02 Apr 2015 06:57:49 -0700 (PDT) MIME-Version: 1.0 Received: by 10.64.101.2 with HTTP; Thu, 2 Apr 2015 06:57:29 -0700 (PDT) In-Reply-To: References: From: Carlos Rolo Date: Thu, 2 Apr 2015 15:57:29 +0200 Message-ID: Subject: Re: Best practice: Multiple clusters vs multiple tables in a single cluster? To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=90e6ba2121db96e6f70512be3793 X-Virus-Checked: Checked by ClamAV on apache.org --90e6ba2121db96e6f70512be3793 Content-Type: text/plain; charset=UTF-8 Adding a new keyspace should be perfectly fine. Unless you have completely distinct workloads for the different keyspaces. Even so you can balanced some stuff at keyspace/table level. But I would go with a new keyspace not with a new cluster given the small size you say you have. Regards, Carlos Juzarte Rolo Cassandra Consultant Pythian - Love your data rolo@pythian | Twitter: cjrolo | Linkedin: *linkedin.com/in/carlosjuzarterolo * Mobile: +31 6 159 61 814 | Tel: +1 613 565 8696 x1649 www.pythian.com On Thu, Apr 2, 2015 at 3:06 PM, Ian Rose wrote: > Hi all - > > We currently have a single cassandra cluster that is dedicated to a > relatively narrow purpose, with just 2 tables. Soon we will need cassandra > for another, unrelated, system, and my debate is whether to just add the > new tables to our existing cassandra cluster or whether to spin up an > entirely new, separate cluster for this new system. > > Does anyone have pros/cons to share on this? It appears from watching > talks and such online that the big users (e.g. Netflix, Spotify) tend to > favor multiple, single-purpose clusters, and thus that was my initial > preference. But we are (for now) no where close to them in traffic so I'm > wondering if running an entirely separate cluster would be a premature > optimization which wouldn't pay for the (nontrivial) overhead in > configuration management and ops. While we are still small it might be > much smarter to reuse our existing clusters so that I can get it done > faster... > > Thanks! > - Ian > > -- -- --90e6ba2121db96e6f70512be3793 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Adding a new keyspace should be perfectly fine. Unless you= have completely distinct workloads for the different keyspaces. Even so yo= u can balanced some stuff at keyspace/table level. But I would go with a ne= w keyspace not with a new cluster given the small size you say you have.

Regards,
=

Carlos Juzarte Rolo
Cassandra Consultant
=C2=A0
Pythian - Love your data

ro= lo@pythian | Twitter: cjrolo | Linkedin: linkedin.co= m/in/carlosjuzarterolo
Mobile: +31 6 159 61 814 | = Tel: +1 613 565 8696 x1649

On Thu, Apr 2, 2015 at 3:06 PM, Ian Rose <ianrose@fullstory.com> wrote:
Hi all -

We currently have a sing= le cassandra cluster that is dedicated to a relatively narrow purpose, with= just 2 tables.=C2=A0 Soon we will need cassandra for another, unrelated, s= ystem, and my debate is whether to just add the new tables to our existing = cassandra cluster or whether to spin up an entirely new, separate cluster f= or this new system.

Does anyone have pros/cons to = share on this?=C2=A0 It appears from watching talks and such online that th= e big users (e.g. Netflix, Spotify) tend to favor multiple, single-purpose = clusters, and thus that was my initial preference.=C2=A0 But we are (for no= w) no where close to them in traffic so I'm wondering if running an ent= irely separate cluster would be a premature optimization which wouldn't= pay for the (nontrivial) overhead in configuration management and ops.=C2= =A0 While we are still small it might be much smarter to reuse our existing= clusters so that I can get it done faster...

Than= ks!
- Ian



--



--90e6ba2121db96e6f70512be3793--