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 9D857FA13 for ; Tue, 9 Jul 2013 05:30:27 +0000 (UTC) Received: (qmail 96058 invoked by uid 500); 9 Jul 2013 05:30:24 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 96038 invoked by uid 500); 9 Jul 2013 05:30:24 -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 96030 invoked by uid 99); 9 Jul 2013 05:30:24 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 09 Jul 2013 05:30:24 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [208.113.200.5] (HELO homiemail-a48.g.dreamhost.com) (208.113.200.5) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 09 Jul 2013 05:30:19 +0000 Received: from homiemail-a48.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a48.g.dreamhost.com (Postfix) with ESMTP id 505884F805C for ; Mon, 8 Jul 2013 22:29:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=thelastpickle.com; h=from :content-type:message-id:mime-version:subject:date:references:to :in-reply-to; s=thelastpickle.com; bh=/dYfSLwluxl+v2BhmDzrgS60Oe 4=; b=XlpG5L+d+/0rDDi/rBdt9e4DFcIfGdZgaTPFv/IhE801wq3hA0hRz98rgj EOCD3ZgCGr1IWR4Q1Wlutg9XQw0wQoPwuXnWxEsXH86VP5mici1p5MCxigqLvRL8 8rJLywrWLVj5hnMdVqffBpoJ+Dbz7gCdxr6dooSJiIG9o8fvk= Received: from [172.16.1.7] (unknown [203.86.207.101]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: aaron@thelastpickle.com) by homiemail-a48.g.dreamhost.com (Postfix) with ESMTPSA id C42204F805B for ; Mon, 8 Jul 2013 22:29:58 -0700 (PDT) From: aaron morton Content-Type: multipart/alternative; boundary="Apple-Mail=_7ED19B37-9760-4938-8E5B-8D32C61FFE02" Message-Id: Mime-Version: 1.0 (Mac OS X Mail 6.5 \(1508\)) Subject: Re: Node tokens / data move Date: Tue, 9 Jul 2013 17:30:01 +1200 References: To: user@cassandra.apache.org In-Reply-To: X-Mailer: Apple Mail (2.1508) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail=_7ED19B37-9760-4938-8E5B-8D32C61FFE02 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii > Can I just copy data files for the required keyspaces, create schema = manually and run repair?=20 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. =20 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.=20 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.=20 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.=20 >=20 > Can I just copy data files for the required keyspaces, create schema = manually and run repair?=20 >=20 > Anything else required? Please help.=20 > -- > Thanks, > Baskar Duraikannu --Apple-Mail=_7ED19B37-9760-4938-8E5B-8D32C61FFE02 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii 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

<= div apple-content-edited=3D"true">
http://www.thelastpickle.com

On 9/07/2013, at 12:45 PM, Baskar Duraikannu <baskar.duraikannu.db@gmail.= com> 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

= --Apple-Mail=_7ED19B37-9760-4938-8E5B-8D32C61FFE02--