Reproducing the sstable File Configuration to Another Keyspace by sstableloader

Asked 2 years ago, Updated 2 years ago, 76 views

This is the Cassandra 3.0 environment.

For testing, I would like to replicate the sstable file in one keyspace to another keyspace and test the compaction.

With sstableloader, I thought it would be possible, so I will try it, but it doesn't work well.
The method you tried is
·Retrieve snapshot with original keyspace.
·Copy all the files inside snapshot to the keyspace to which you want to copy.
·sstableloader-dlocalhost<directory path of keyspace to which to copy>
That's it.

After the implementation, I checked with select and found that the table storage data was copied.
The file configuration of the destination sstable changed when the sstableloader was performed.
And when I restarted Cassandra, I tried to see the sstable in sstabledump, but there was an error and it seemed to be broken.

Is it possible to do what I'm trying to do?
Also, if possible, how do I get it right?

I would appreciate it if you could let me know.

cassandra

2022-09-30 16:32

1 Answers

This is a self-answer.
There seems to be no problem so far simply copying the sstable and restarting Cassandra.


If the nodetool refresh works after copying in other previous answers
There was one, but there was no error when executing the command, but when I selected it, there was an error.

After all, I think it would be good to copy and restart.
If there is a problem, could you please point it out?


2022-09-30 16:32

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.