我正在寻找NoSQL来处理极大量的数据。我们现在在MySQL中存储网页文本的缓存版本,但似乎数据库会非常快。
I'm looking at NoSQL for extremely high volumes of data. We're storing cached versions of web page text in MySQL at the moment, but it seems like the database will get huge very quickly.
我的要求是:
- 耐用性,不得在刷新/写入时丢失数据
- 读取速度非常快, >
- 完全一致的复制
- 最好是在内存中加上最终的磁盘写入
我现在在看:MongoDB,Redis,Raik和Cassandra。
I'm looking at: MongoDB, Redis, Raik, and Cassandra right now.
这最符合我的要求吗?
推荐答案将缓存的版本存储在MemCache而不是MySQL中。它将消除大多数写入。写入MySQL是不好的,因为它杀死了查询缓存。当您在MemCache中缓存页面时,您对数据库的写操作将少得多,您的阅读压力也会降低。您可以缓存复杂查询的结果,或者根据需要缓存整个页面。
Store the cached versions in MemCache instead of MySQL. It will eliminate most writes. Writing to MySQL is bad, because it kills the query cache. When you cache the pages in MemCache, you will have far less writes to the database, and you'll have less reading pressure too. You can cache the result of complex queries, or cache entire pages as you like.
也许它不会像Cassandra一样快,但它会给你一个巨大的提升与目前的情况,只有MySQL。而且您不必重写整个应用程序。
Maybe it won't be as fast as Cassandra, but it will give you an enormous boost compared to your current situation with only MySQL. And you won't have to rewrite your entire application.
更多推荐
哪个NoSQL数据库用于极大量的数据
发布评论