0

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?

3 Answers 3

0

One thing you could potentially try is PlayOrm with it's Scalable SQL on top of Cassandra and see if that works out. You may want to try 10 nodes or maybe even 20 as it gets faster the more you parallize the disks on the queries.

0

How about taking a look at VoltDB ? Its in memory and fast.

Riak would also fullfill the goals.

//Christian

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .