Is Cassandra a fit for this use-case or should we just stick with the oldskool MySQL and put things like votes, reviews etc in our C* store?If all your data fits into one computer and you expect only tens of millions records in table then go for SQL. It has far more features and people are comfortable to work with it.
If you want noSQL then go for mongoDB
