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 24D7E1042C for ; Tue, 9 Jul 2013 10:19:43 +0000 (UTC) Received: (qmail 57804 invoked by uid 500); 9 Jul 2013 10:19:40 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 57712 invoked by uid 500); 9 Jul 2013 10:19:39 -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 57704 invoked by uid 99); 9 Jul 2013 10:19:38 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 09 Jul 2013 10:19:38 +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 baskar.duraikannu.db@gmail.com designates 74.125.82.177 as permitted sender) Received: from [74.125.82.177] (HELO mail-we0-f177.google.com) (74.125.82.177) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 09 Jul 2013 10:19:33 +0000 Received: by mail-we0-f177.google.com with SMTP id m19so4386051wev.8 for ; Tue, 09 Jul 2013 03:19:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=zuNWJUIeZO6Wpc24Rjs3VlRGtIqHzAHy0U2evdjoYCI=; b=pDPNgKQtv4tpvpQgsR/XyZ6PxBs2r8ZDA7uYyvU+2VhZnvBUdwP+sIbWlfMoK2TOPf Gq+aXzicaCT0W/BxfYEMki5DdP/CKXvCKag76gnwlGvslBXkzTRo5sLV3Bv69F17DdZl JKh18cCRC0xwU/wFqGMqSfSQxl/UF0xcoURnr9GXxRcCa1fOzlQ2Q16GX11rDQRQZ4na pZ905wzOaRjZQSC1XcGfn9YiJE2r6P7ULjvHXcZhsyaYpoEQE2S59wZ35zVPbaANQ5NE px1IzKyc8gw0p4NyKH4gqHoHEVr+QkdsVjrxwrsfca4YFf7sf7TVkEW0RvKLY44VrnBs Pr3A== MIME-Version: 1.0 X-Received: by 10.180.183.40 with SMTP id ej8mr13946558wic.37.1373365153275; Tue, 09 Jul 2013 03:19:13 -0700 (PDT) Received: by 10.216.192.195 with HTTP; Tue, 9 Jul 2013 03:19:13 -0700 (PDT) In-Reply-To: References: Date: Tue, 9 Jul 2013 06:19:13 -0400 Message-ID: Subject: Re: Node tokens / data move From: Baskar Duraikannu To: user@cassandra.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org Thanks Aaron On 7/9/13, aaron morton wrote: >> Can I just copy data files for the required keyspaces, create schema >> manually and run repair? > If you have something like RF 3 and 3 nodes then yes, you can copy the data > from one node in the source cluster to all nodes in the dest cluster and use > cleanup to remove the unneeded data. Because each node in the source cluster > has a full copy of the data. > > If that's not the case you cannot copy the data files, even if they have the > same number of nodes, because the nodes in the dest cluster will have > different tokens. AFAIK you need to export the full data set from the source > DC and then import it into the dest system. > > The Bulk Load utility may be of help > http://www.datastax.com/docs/1.2/references/bulkloader . You could copy the > SSTables from every node in the source system and bulk load them into the > dest system. That process will ensure rows are sent to nodes that are > replicas. > > Cheers > > ----------------- > Aaron Morton > Freelance Cassandra Consultant > New Zealand > > @aaronmorton > http://www.thelastpickle.com > > On 9/07/2013, at 12:45 PM, Baskar Duraikannu > wrote: > >> We have two clusters used by two different groups with vnodes enabled. Now >> there is a need to move some of the keyspaces from cluster 1 to cluster 2. >> >> >> Can I just copy data files for the required keyspaces, create schema >> manually and run repair? >> >> Anything else required? Please help. >> -- >> Thanks, >> Baskar Duraikannu > >