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 57D6BCC9F for ; Fri, 18 May 2012 20:39:40 +0000 (UTC) Received: (qmail 16950 invoked by uid 500); 18 May 2012 20:39:38 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 16907 invoked by uid 500); 18 May 2012 20:39:38 -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 16899 invoked by uid 99); 18 May 2012 20:39:37 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 May 2012 20:39:37 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [209.85.210.44] (HELO mail-pz0-f44.google.com) (209.85.210.44) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 May 2012 20:39:31 +0000 Received: by dacx6 with SMTP id x6so4395284dac.31 for ; Fri, 18 May 2012 13:39:08 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:x-gm-message-state; bh=4Aa2c6h6l5TAEkhb3Ow5624NOEBCGihJN33SWOvPnXI=; b=SpI9EVCvkFrhM1rhD8bn8GMkizHb0jwzzkue5R+/Nof7qzLs8dvnJk5ZDvWjRlTLLo Kk6nFq3znn2XCyKlWs52zOZvA0Efndl4QrBG+cnMjMbB6YKrslmBplpwlFYzcg0pWb6+ tkcupAGJ+s6AWvcTEAtLo2JjzPyzbhGqweg5WTEMIZWPTPXaDuCLDZfYIquv6kAoRz9c KUr5NwcDk4dC6oJ979UXbEPJ1Zj3QyuSWruIRD0WDN9ZsYlwY2krI9mgz7dcyF/J5YjR hVFig6S94CPVVsT6s+aJAp3VToZjMB2h40juY7FC3JoIBVbixbqVsdic+ZndVo/z/sn7 3DuA== MIME-Version: 1.0 Received: by 10.68.125.138 with SMTP id mq10mr11972492pbb.25.1337373548268; Fri, 18 May 2012 13:39:08 -0700 (PDT) Received: by 10.68.226.36 with HTTP; Fri, 18 May 2012 13:39:08 -0700 (PDT) In-Reply-To: References: Date: Fri, 18 May 2012 13:39:08 -0700 Message-ID: Subject: Re: Migrating a column family from one cluster to another From: Rob Coli To: user@cassandra.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Gm-Message-State: ALoCoQldA6Q5/A9p6akaNolxteH2rfRqG4Wp0X0+4z3eMr5fyg39wr9Dh+YoASfGS47FMvU7cOl/ On Thu, May 17, 2012 at 9:37 AM, Bryan Fernandez wrote: > What would be the recommended > approach to migrating a few column families from a six node cluster to a > three node cluster? The easiest way (if you are not using counters) is : 1) make sure all filenames of sstables are unique [1] 2) copy all sstablefiles from the 6 nodes to all 3 nodes 3) run a "cleanup" compaction on the 3 nodes =Rob [1] https://issues.apache.org/jira/browse/CASSANDRA-1983 -- =Robert Coli AIM>ALK - rcoli@palominodb.com YAHOO - rcoli.palominob SKYPE - rcoli_palominodb