[cassandra] Update the directory_entry table to LCS compaction
After the LCS algorithm validation in #4898 (closed), the production could be migrated.
The plan of the migration:
- Stop the compaction on all the nodes (
⚠ lost after a restart)
seq 1 8 | xargs -t -i{} /opt/cassandra/bin/nodetool -h cassandra0{} -u cassandra --password $PASS disableautocompaction swh directory_entry
seq 1 8 | xargs -t -i{} /opt/cassandra/bin/nodetool -h cassandra0{} -u cassandra --password $PASS statusautocompaction swh directory_entry
should be 8 times 'not running'
- Update the
directory_entry
table compaction algorithm
alter table directory_entry with compaction = {'class' : 'LeveledCompactionStrategy', 'sstable_size_in_mb':'40960'} ;
- Server by server do:
- Stop the server
- Delete the directory
/srv/cassandra/instance1/data/swh/directory_entry-b74d85d02d2e11ed970a612d80206516
- Start the server
- Launch a full repair of the table for this server:
/opt/cassandra/bin/nodetool -u cassandra --password $PASS repair -pr --full -j4 -os swh directory_entry