From user-return-36363-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Wed Sep 4 20:02:38 2013 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 AB2CB10B63 for ; Wed, 4 Sep 2013 20:02:38 +0000 (UTC) Received: (qmail 23015 invoked by uid 500); 4 Sep 2013 20:02:36 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 22980 invoked by uid 500); 4 Sep 2013 20:02:33 -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 22962 invoked by uid 99); 4 Sep 2013 20:02:33 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Sep 2013 20:02:33 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: error (nike.apache.org: encountered temporary error during SPF processing of domain of Jim.Langston@compuware.com) Received: from [216.32.181.184] (HELO ch1outboundpool.messaging.microsoft.com) (216.32.181.184) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Sep 2013 20:02:27 +0000 Received: from mail114-ch1-R.bigfish.com (10.43.68.242) by CH1EHSOBE017.bigfish.com (10.43.70.67) with Microsoft SMTP Server id 14.1.225.22; Wed, 4 Sep 2013 20:01:45 +0000 Received: from mail114-ch1 (localhost [127.0.0.1]) by mail114-ch1-R.bigfish.com (Postfix) with ESMTP id BF9A61C0101 for ; Wed, 4 Sep 2013 20:01:45 +0000 (UTC) X-Forefront-Antispam-Report: CIP:157.56.240.101;KIP:(null);UIP:(null);IPV:NLI;H:BL2PRD0510HT005.namprd05.prod.outlook.com;RD:none;EFVD:NLI X-SpamScore: 1 X-BigFish: PS1(zz98dI9371Ic85fh1447I9a6kzz1f42h208ch1ee6h1de0h1fdah2073h1202h1e76h1d1ah1d2ah1fc6hzz1de098h17326ah18c673h1de097h186068h8275bh8275dhz2ei2a8h839hbe3he5bhf0ah1288h12a5h12bdh137ah1441h1504h1537h153bh162dh1631h1758h18e1h1946h19b5h1ad9h1b0ah1bceh1d0ch1d2eh1d3fh1dc1h1dfeh1dffh1e1dh1fe8h1ff5h209eh1155h) Received-SPF: neutral (mail114-ch1: 157.56.240.101 is neither permitted nor denied by domain of compuware.com) client-ip=157.56.240.101; envelope-from=Jim.Langston@compuware.com; helo=BL2PRD0510HT005.namprd05.prod.outlook.com ;.outlook.com ; X-Forefront-Antispam-Report-Untrusted: SFV:NSPM;SFS:(24454002)(377454003)(51914003)(199002)(189002)(50986001)(47976001)(51856001)(46102001)(74366001)(74876001)(74706001)(16236675002)(15202345003)(47736001)(49866001)(4396001)(53806001)(54356001)(83506001)(80022001)(81816001)(79102001)(77096001)(63696002)(81686001)(47446002)(65816001)(15975445006)(74502001)(69226001)(56776001)(76176001)(54316002)(59766001)(83072001)(77982001)(76482001)(81342001)(56816003)(19580395003)(31966008)(36756003)(74662001)(80976001)(76796001)(83322001)(76786001)(81542001)(19580405001)(24704002);DIR:OUT;SFP:;SCL:1;SRVR:BN1PR05MB424;H:BN1PR05MB424.namprd05.prod.outlook.com;CLIP:10.255.100.4;RD:InfoNoRecords;A:1;MX:1;LANG:en; Received: from mail114-ch1 (localhost.localdomain [127.0.0.1]) by mail114-ch1 (MessageSwitch) id 1378324903615402_13362; Wed, 4 Sep 2013 20:01:43 +0000 (UTC) Received: from CH1EHSMHS043.bigfish.com (snatpool1.int.messaging.microsoft.com [10.43.68.242]) by mail114-ch1.bigfish.com (Postfix) with ESMTP id 918552003F for ; Wed, 4 Sep 2013 20:01:43 +0000 (UTC) Received: from BL2PRD0510HT005.namprd05.prod.outlook.com (157.56.240.101) by CH1EHSMHS043.bigfish.com (10.43.69.252) with Microsoft SMTP Server (TLS) id 14.16.227.3; Wed, 4 Sep 2013 20:01:42 +0000 Received: from BN1PR05MB424.namprd05.prod.outlook.com (10.141.58.148) by BL2PRD0510HT005.namprd05.prod.outlook.com (10.255.100.40) with Microsoft SMTP Server (TLS) id 14.16.353.4; Wed, 4 Sep 2013 20:01:37 +0000 Received: from BN1PR05MB424.namprd05.prod.outlook.com (10.141.58.148) by BN1PR05MB424.namprd05.prod.outlook.com (10.141.58.148) with Microsoft SMTP Server (TLS) id 15.0.745.25; Wed, 4 Sep 2013 20:01:35 +0000 Received: from BN1PR05MB424.namprd05.prod.outlook.com ([169.254.8.106]) by BN1PR05MB424.namprd05.prod.outlook.com ([169.254.8.106]) with mapi id 15.00.0745.000; Wed, 4 Sep 2013 20:01:35 +0000 From: "Langston, Jim" To: "user@cassandra.apache.org" Subject: Re: moving all data to new cluster ? Thread-Topic: moving all data to new cluster ? Thread-Index: AQHOqaZUGm4kLCuNrECYR0DQVxhcxJm1+vUA///BpgA= Date: Wed, 4 Sep 2013 20:01:34 +0000 Message-ID: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.14.0.111121 x-originating-ip: [10.255.100.4] x-forefront-prvs: 095972DF2F Content-Type: multipart/alternative; boundary="_000_CE4D090C399E1jimlangstoncompuwarecom_" MIME-Version: 1.0 X-MS-Exchange-CrossPremises-AuthAs: Internal X-MS-Exchange-CrossPremises-AuthMechanism: 04 X-MS-Exchange-CrossPremises-AuthSource: BN1PR05MB424.namprd05.prod.outlook.com X-MS-Exchange-CrossPremises-SCL: 1 X-MS-Exchange-CrossPremises-messagesource: StoreDriver X-MS-Exchange-CrossPremises-BCC: X-MS-Exchange-CrossPremises-originalclientipaddress: 10.255.100.4 X-MS-Exchange-CrossPremises-avstamp-service: 1.0 X-MS-Exchange-CrossPremises-antispam-scancontext: DIR:Originating;SFV:NSPM;SKIP:0; X-MS-Exchange-CrossPremises-processed-by-journaling: Journal Agent X-MS-Exchange-CrossPremises-ContentConversionOptions: False;00160000;True;;iso-8859-1 X-OrganizationHeadersPreserved: BN1PR05MB424.namprd05.prod.outlook.com X-OriginatorOrg: compuware.com X-FOPE-CONNECTOR: Id%0$Dn%*$RO%0$TLS%0$FQDN%$TlsDn% X-Virus-Checked: Checked by ClamAV on apache.org --_000_CE4D090C399E1jimlangstoncompuwarecom_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Thanks for the link Rob, but I did try earlier to copy the SSTables over and then to refresh them, but this is a brand new cluster and the error I got back indicated that the keyspace didn't exist, and then figured I needed to copy everything over in the data directory. Jim From: Robert Coli > Reply-To: > Date: Wed, 4 Sep 2013 12:44:12 -0700 To: "user@cassandra.apache.org" > Subject: Re: moving all data to new cluster ? On Wed, Sep 4, 2013 at 12:38 PM, Langston, Jim > wrote: I have built a new 4 node cluster and would like to move the data from the current 2 node cluster to the new cluster. What would be the best way to move the data and utilize it on the new cluster. I have looked at snapshot and also just copying the entire tree from the old cluster to the new cluster. Not sure what the best practice would be. I'm testing that process now in preparation for moving the current data (production) to the new larger ring (systems are bigger and more memory) and decommission the older ring (smaller systems, less memory). http://www.palominodb.com/blog/2012/09/25/bulk-loading-options-cassandra In your case, I would just copy all sstables to all target nodes and run cl= eanup. =3DRob --_000_CE4D090C399E1jimlangstoncompuwarecom_ Content-Type: text/html; charset="us-ascii" Content-ID: Content-Transfer-Encoding: quoted-printable
Thanks for the link Rob, but I did try earlier to 
copy the SSTables over and then to refresh them,
but this is a brand new cluster and the error I got
back indicated that the keyspace didn't exist, and 
then figured I needed to copy everything over in 
the data directory.


Jim

From: Robert Coli <rcoli@eventbrite.com>
Reply-To: <user@cassandra.apache.org>
Date: Wed, 4 Sep 2013 12:44:12 -070= 0
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Subject: Re: moving all data to new= cluster ?

On Wed, Sep 4, 2013 at 12:38 PM, Langston, Jim <Jim.Langston@compuware.com> wrote:
I have built a new 4 node cluster and w= ould like to move the data
from the current 2 node cluster to the new cluster. What would be
the best way to move the data and utilize it on the new cluster. I&nbs= p;
have looked at snapshot and also just copying the entire tree from
the old cluster to the new cluster. Not sure what the best practice
would be. I'm testing that process now in preparation for moving the
current data (production) to the new larger ring (systems are bigger
and more memory) and decommission the older ring (smaller systems,
less memory).


In your case, I would just copy all sstables to all target nodes and r= un cleanup.

=3DRob 
--_000_CE4D090C399E1jimlangstoncompuwarecom_--