Go to MySQL. Cassandra will greatly complicate the work, it still lacks tools, manuals, etc. And that changes quickly, so you also have to change your code.
Take a look in this article - this explains why I think that it is not yet time for regular projects to go to Kassandra.
In case your sky-rockets application needs more scalability than MySQL, then you will have enough people to handle the transition to Cassandra. Just draw your data access level so you can switch later without changing the rest of the code.
Update: Pay attention to the date of reply. This will by definition become obsolete, so check to see if there are already good tools, tutorials, etc.
Bozho
source share