albertyw/albertyw.com

Cassandra Compaction Strategies

cassandra-compaction-strategies

1488703300

When setting up Cassandra tables, you should specify the compaction strategy
Cassandra should use to store data internally.  To do so, just add

```sql
WITH compaction = { 'class': '<compactionName>' }
```

to an `ALTER TABLE` or `CREATE TABLE` command.

|             Name             | Acronym |       Used For      |
|------------------------------|---------|---------------------|
| SizeTieredCompactionStrategy | STCS    | Insert-Heavy Tables |
| LeveledCompactionStrategy    | LCS     | Read-Heavy Tables   |
| DateTieredCompactionStrategy | DTCS    | Time Series Data    |