Also for testing purposes, you can send only one replica set to the Test DC.
For instance with a RF=3 and 3 C* racks, you can just rsync/sstableload one
rack. It will be faster and OK for tests.
Best,
Romain
Le Mardi 20 septembre 2016 3h28, Michael Laws <[email protected]> a
écrit :
<!--#yiv1130450435 _filtered #yiv1130450435 {font-family:"Cambria
Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv1130450435
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv1130450435
#yiv1130450435 p.yiv1130450435MsoNormal, #yiv1130450435
li.yiv1130450435MsoNormal, #yiv1130450435 div.yiv1130450435MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri",
sans-serif;}#yiv1130450435 a:link, #yiv1130450435
span.yiv1130450435MsoHyperlink
{color:#0563C1;text-decoration:underline;}#yiv1130450435 a:visited,
#yiv1130450435 span.yiv1130450435MsoHyperlinkFollowed
{color:#954F72;text-decoration:underline;}#yiv1130450435
p.yiv1130450435msonormal0, #yiv1130450435 li.yiv1130450435msonormal0,
#yiv1130450435 div.yiv1130450435msonormal0
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New
Roman", serif;}#yiv1130450435 span.yiv1130450435EmailStyle18
{font-family:"Calibri", sans-serif;color:windowtext;}#yiv1130450435
span.yiv1130450435EmailStyle19 {font-family:"Calibri",
sans-serif;color:windowtext;}#yiv1130450435 span.yiv1130450435EmailStyle20
{font-family:"Calibri", sans-serif;color:windowtext;}#yiv1130450435
span.yiv1130450435EmailStyle21 {font-family:"Calibri",
sans-serif;color:windowtext;}#yiv1130450435 span.yiv1130450435EmailStyle22
{font-family:"Calibri", sans-serif;color:windowtext;}#yiv1130450435
span.yiv1130450435EmailStyle23 {font-family:"Calibri",
sans-serif;color:windowtext;}#yiv1130450435 .yiv1130450435MsoChpDefault
{font-size:10.0pt;} _filtered #yiv1130450435 {margin:1.0in 1.0in 1.0in
1.0in;}#yiv1130450435 div.yiv1130450435WordSection1 {}-->I put together a shell
wrapper around nodetool/sstableloader that I’ve been running for the past few
years – https://github.com/AppliedInfrastructure/cassandra-snapshot-toolsAlways
seemed to work well for these kinds of scenarios… Never really had to think
about where SSTables were on the filesystem, etc. Mike From: Justin Sanciangco
[mailto:[email protected]]
Sent: Monday, September 19, 2016 6:20 PM
To: [email protected]
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 command seemed to worksstableloader -d <target hostname>
<sstable location> Thanks for the help! From: Jeff Jirsa
[mailto:[email protected]]
Sent: Monday, September 19, 2016 5:49 PM
To: [email protected]
Subject: Re: 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
the directory structure on disk, and wants you to be at the equivalent of the
parent/data_files_directory (so if you dump your sstables at
/path/to/data/keyspace/table/, you’d want to run sstableloader from
/path/to/data/ and provide keyspace/table/ as the location). From: Justin
Sanciangco <[email protected]>
Reply-To: "[email protected]" <[email protected]>
Date: Monday, September 19, 2016 at 5:44 PM
To: "[email protected]" <[email protected]>
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? From target hostsstableloader -d
<target hostname> <sstable location> From: Jeff Jirsa
[mailto:[email protected]]
Sent: Monday, September 19, 2016 4:45 PM
To: [email protected]
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 <[email protected]>
Reply-To: "[email protected]" <[email protected]>
Date: Monday, September 19, 2016 at 2:49 PM
To: "[email protected]" <[email protected]>
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 cluster of different size? Appreciate the help…
Thanks,Justin
