I am evaluating what might be the best migration option.
Currently, I am on a sharded MySQL (horizontal partition), with most of my data stored in JSON blobs. I do not have any complex SQL queries (already migrated away after since I partitioned my db).
Right now, it seems like both MongoDB and Cassandra would be likely options. My situation:
- Lots of reads in every query, less regular writes
- Not worried about “massive” scalability
- More concerned about simple setup, maintenance and code
- Minimize hardware/server cost