We have 2 - 3 installations with single node Cassandra. They working fine, no problems there,
except if Cassandra stops, everything stops. Even on one node, we usually "rolling" 500-600 GB data, sometimes even 2-3 TB. We use mostly standard configuration with almost no changes there.
Here are some considerations for bloom filter config, but they are for old Cassandra version:
We found that it works much better and faster than MySQL. We did test Postgres, but it was terribly slow. We were in big hurry so we did not analyze why Postgres was so slow.
Another lesson we learned - when you do single node, put only Cassandra on single server. Keep webserver / client on different server.
In our latest project we did use TokuDB. It is something like MySQL "plugin". We know Toku from 5-6 years, but until recently it was paid software with free demo. TokuDB is currently GPL.
We also did test MongoDB. It is quite fast, but it have been eaten our HDD very fast.
So little recap what we have:
- Cassandra single nodes - 600-700 GB data
- MySQL with MyISAM - 30-40 GB data
- TokuDB - 100 GB data (this equals to 500 GB MyISAM / InnoDB).
Feel free to contact me if you have non Cassandra related questions.