How to choose NoSQL database engine?

Posted by Poma on Server Fault See other posts from Server Fault or by Poma
Published on 2012-10-19T14:26:35Z Indexed on 2012/10/19 23:06 UTC
Read the original article Hit count: 196

Filed under:
|
|
|

We have a database with following specs:

  • 30k records, 7mb in size
  • 20 inserts/second
  • 1000 updates/second
  • 1000 range selects/second, by secondary index, approx 10 rows each
  • needs at least one secondary index
  • needs some mechanism to expire keys if they are not updated for 75 secs (can be done via programmatic garbage collector but will require additional 'last_update' index and will add some load)
  • consistency is not required
  • durability is not required
  • db should be stored in memory

For now we use Redis, but it does not have secondary index and it's keys index:foo:* is too slow. Membase also does not have secondary index (as far as I know). MongoDB and MySQL memory engine have table-level locks. What engine will fit our use case?

© Server Fault or respective owner

Related posts about mongodb

Related posts about high-load