Re: Export/Importing keyspace from a different sized cluster

2016-09-20 Thread Romain Hardouin
 From: Justin Sanciangco [mailto:jsancian...@blizzard.com] Sent: Monday, September 19, 2016 6:20 PM To: user@cassandra.apache.org Subject: RE: Export/Importing keyspace from a different sized cluster I am running cqlsh 5.0.1 | Cassandra 2.1.11.969 | DSE 4.8.3 | CQL spec 3.2.1 |   Doing the below

RE: Export/Importing keyspace from a different sized cluster

2016-09-19 Thread Michael Laws
filesystem, etc. Mike *From:* Justin Sanciangco [mailto:jsancian...@blizzard.com] *Sent:* Monday, September 19, 2016 6:20 PM *To:* user@cassandra.apache.org *Subject:* RE: Export/Importing keyspace from a different sized cluster I am running cqlsh 5.0.1 | Cassandra 2.1.11.969 | DSE 4.8.3

RE: Export/Importing keyspace from a different sized cluster

2016-09-19 Thread Justin Sanciangco
: Export/Importing keyspace from a different sized cluster Something like that, depending on your version (which you didn’t specify). Note, though, that sstableloader is notoriously picky about the path to sstables. In particular, it really really really wants a directory structure that matches

Re: Export/Importing keyspace from a different sized cluster

2016-09-19 Thread Jeff Jirsa
uot; Date: Monday, September 19, 2016 at 5:44 PM To: "user@cassandra.apache.org" Subject: RE: Export/Importing keyspace from a different sized cluster So if I rsync the the sstables say from source node 1 and source node 2 to target node 1. Would I just run the command like this?

RE: Export/Importing keyspace from a different sized cluster

2016-09-19 Thread Justin Sanciangco
Subject: Re: Export/Importing keyspace from a different sized cluster You can ship the sstables to the destination (or any other server with Cassandra binary tools installed) via ssh/rsync and run sstableloader on the destination cluster as well. From: Justin Sanciangco mailto:jsancian

Re: Export/Importing keyspace from a different sized cluster

2016-09-19 Thread Jeff Jirsa
2:49 PM To: "user@cassandra.apache.org" Subject: Export/Importing keyspace from a different sized cluster Hello, Assuming I can’t get ports opened from source to target cluster to run sstableloader, what methods can I use to load a single keyspace from one cluster to another clust

Re: Export/Importing keyspace from a different sized cluster

2016-09-19 Thread Ben Slater
CQLSH COPY FROM / COPY TO? There are some significant performance improvements in recent versions: https://issues.apache.org/jira/browse/CASSANDRA-11053 On Tue, 20 Sep 2016 at 07:49 Justin Sanciangco wrote: > Hello, > > > > Assuming I can’t get ports opened from source to target cluster to run >

Export/Importing keyspace from a different sized cluster

2016-09-19 Thread Justin Sanciangco
Hello, Assuming I can't get ports opened from source to target cluster to run sstableloader, what methods can I use to load a single keyspace from one cluster to another cluster of different size? Appreciate the help... Thanks, Justin