[CASSANDRA-10757] Cluster migration with sstableloader requires significant compaction time

• Type: Improvement
• Status: Resolved
• Priority: Low
• Resolution: Duplicate
• Component/s: Legacy/Streaming and Messaging, Local/Compaction
• Labels: sstableloader
• Assignee: Unassigned
• Reporter: Juho Mäkinen
• Created: 23/Nov/15 07:44
• Updated: 16/Apr/19 09:30
• Resolved: 04/Apr/16 18:03

Description

When sstableloader is used to migrate data from a cluster into another the loading creates a lot more data and a lot more sstable files than what the original cluster had.

For example in my case a 62 node with 16 TiB of data in 80000 sstables was sstableloaded into another cluster with 36 nodes and this resulted with 42 TiB of used data in a whopping 350000 sstables.

The sstableloadering process itself was relatively fast (around 8 hours), but in the result the destination cluster needs approximately two weeks of compaction to be able to reduce the number of sstables back to the original levels. (The instances are C4.4xlarge in EC2, 16 cores each, compaction running on 14 cores. the EBS disks in each instance provide 9000 iops and max 250 MiB/sec disk bandwidth.).

Could sstableloader process somehow improved to make this kind of migrations less painful and faster?

Issue Links

• duplicates: CASSANDRA-4756 Bulk loading snapshots creates RF^2 copies of the data