Re: Export/Importing keyspace from a different sized cluster

2016-09-20 Thread Romain Hardouin
s were on the 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 | CQL spec

RE: Export/Importing keyspace from a different sized cluster

2016-09-19 Thread Michael Laws
on the 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
"user@cassandra.apache.org" <user@cassandra.apache.org> Date: Monday, September 19, 2016 at 5:44 PM To: "user@cassandra.apache.org" <user@cassandra.apache.org> Subject: RE: Export/Importing keyspace from a different sized cluster So if I rsync the the sstables sa

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 <jsancian...@blizzard.

Re: Export/Importing keyspace from a different sized cluster

2016-09-19 Thread Jeff Jirsa
.org" <user@cassandra.apache.org> Date: Monday, September 19, 2016 at 2:49 PM To: "user@cassandra.apache.org" <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

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

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