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 208AFF09E for ; Wed, 8 May 2013 23:21:36 +0000 (UTC) Received: (qmail 27959 invoked by uid 500); 8 May 2013 23:21:32 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 27904 invoked by uid 500); 8 May 2013 23:21:32 -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 27828 invoked by uid 99); 8 May 2013 23:21:32 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 May 2013 23:21:32 +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 jbellis@gmail.com designates 209.85.217.175 as permitted sender) Received: from [209.85.217.175] (HELO mail-lb0-f175.google.com) (209.85.217.175) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 May 2013 23:21:27 +0000 Received: by mail-lb0-f175.google.com with SMTP id w20so2455473lbh.20 for ; Wed, 08 May 2013 16:21:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=x-received:mime-version:in-reply-to:references:from:date:message-id :subject:to:content-type:content-transfer-encoding; bh=dUIRzMwYkPy4zygenkNqYkjY+swdGgXkogNgXmO140w=; b=Yt3rBxsRWtij31pttRgi/2j21W2Lb3Wr3WBy40zgOJhRZa7yxcVEzep3o/Bu7dRdBz jK35ukBW3RWra1JNIvAzhqAdU6r2N25TdKXlHwJMEZoLmJ+1W+nPfSTHzOy4nuLmK629 DLCZEEiJwT5r7uxAriPkvKVlqKmfLnEXxlezm9bSVyCeYexti9/k+3TyeduZX0IOmUgM YkWM9/EWGP5+Bq5Xu90hlN8HWDCFfeZR4HWL4SbBILmEKyr7H7DprrYNy9sj4kwTan4z py97tB5nI4O48xVWdzCwR9S4zlp3Ji08ep4ET7tMaVV2Z5PD9nnf/tcEMT0m8UpQqiaS G1bQ== X-Received: by 10.112.161.97 with SMTP id xr1mr4308451lbb.15.1368055267155; Wed, 08 May 2013 16:21:07 -0700 (PDT) MIME-Version: 1.0 Received: by 10.112.199.200 with HTTP; Wed, 8 May 2013 16:20:47 -0700 (PDT) In-Reply-To: References: From: Jonathan Ellis Date: Wed, 8 May 2013 18:20:47 -0500 Message-ID: Subject: Re: Backup and restore between different node-sized clusters To: user Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org You want to use sstableloader when the cluster sizes are different; it will stream things to the right places in the new one. On Wed, May 8, 2013 at 6:03 PM, Ron Siemens wrot= e: > > I have a 3-node cluster in production and a single-node development clust= er. I tested snapshotting a column family from the 3-node production clust= er, grouping the files together, and restoring onto my single node developm= ent system. That worked fine. Can I go the other direction? It's not eas= y for me to test in that direction: I'll get the chance at some point but w= ould like to hear if you've done this. > > If I just put the snapshot from the single node cluster on one of the nod= es from the 3-node cluster, and do a JMX loadNewSSTables on that node, will= the data load correctly into the 3-nodes? Or is something more complex in= volved? > > FYI, I'm following the instructions below, but only doing per column fami= ly backup and restore. > > http://www.datastax.com/docs/1.2/operations/backup_restore > > Thanks, > Ron > --=20 Jonathan Ellis Project Chair, Apache Cassandra co-founder, http://www.datastax.com @spyced