Hi, we are running test cassandra cluster of 8 nodes running in single DC using Simple snitch and DateTieredCompactionStrategy after adding new node(9th) to the cluster we see that number of sstables on newly joined server roughly equals to sum of all sstables on all servers in the cluster. and that number is huge as tens of thousands of sstables on newly added server.
Q1:is that what we should expect to happen? Furthermore newly added server seems isn't overloaded, basically there are no pending/scheduled compactions but the number of sstables isn't decreasing. Q2:what could be the reason of not reducing number of sstables? Q3:what we need to do to reduce number of sstables per server? Thanks for your help