According the cassandra migration (see qestions: https://community.datastax.com/questions/3042/migrate-cassandra-to-new-service-provider-and-redu.html?childToView=3074#answer-3074 current at step 7) i have seen that i have much growing sstables > 500GB after the datasync from a existing DC. On the basis of the big sstable i will get trouble with compactions and nodetool garbagecollection because of free diskspace. I have to add a third virtual DC (DC2new) to the existing C* cluster and I would like to avoid much growing sstables. Here my questions:
a) Is it possible to set a max size for sstable for the datasync?
b) On the existing DC I would like to split some sstables in smaller pieces like 100GB or Max 150GB. Is this possible and make sense?
Many thanks in advance.