问题:
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. 目前,我在分片的MySQL(水平分区)上,我的大部分数据存储在JSON Blob中。 I do not have any complex SQL queries (already migrated away after since I partitioned my db). 我没有任何复杂的SQL查询(自从对数据库进行分区以来,已经迁移了)。
Right now, it seems like both MongoDB and Cassandra would be likely options. 现在,似乎MongoDB和Cassandra都是可能的选择。 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 最小化硬件/服务器成本
解决方案:
参考一: https://stackoom.com/question/C8Wv/MongoDB与Cassandra的比较
参考二: https://oldbug.net/q/C8Wv/MongoDB-vs-Cassandra-closed