we are using MongoDB currently as replica Set to Sync data between our data
to speed up performance we need to implement some kind of cache layer .
we currently considering memcahed & mongodb .
the data stored in the cache is key-value type , with small size strings .
the cache should be distributed at the data center between computers there .
we have mongo version 2.0 and not 2.2 where the TTL collections exists , so
we implemented it by a thread that remove old entries after the TTL .
we expect the cache size to be ~10 milion records .
and we expect the cache to be queried ~1000 times a second .
will the mongoDB holds in this kind of hit rate , where the same collection
will be scaned very often with reads , and written too (in smaller scale) ,
and deleted from ?
won't the memcached solution per data center be better in performance?
this way the primary won't be written at all (just from our MS-SQL DB , not
from the side of the clients),
and the queries to my understanding will be faster (am i right?)
i hesitate to add another layer of the memcached , and if the mongoDB will
handle it i gladly will choose it .