Timeline for Is it possible to delegate responsibility for specific indexes for a collection to specific shards in a mongoDB database?
Current License: CC BY-SA 3.0
3 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Apr 4, 2017 at 15:18 | answer | added | JJussi | timeline score: 0 | |
Mar 7, 2017 at 22:22 | comment | added | Antonios | Each shard will have to maintain all indexes. With sharding you will achieve to maintain smaller "local" indexes but each shard must have all indexes. Assuming you searching for price:{$gt:10}. Most probably this query will hit all three shards. If you are missing the {price:1} index on one shard the query will perform a full collection scan which will slow down your database. If I understand your question you want to scale writes. The best way is a shard key like {_id:hashed} or any other field that can achieve write scale and a minimal set of indexes - consider partial indexes as well. | |
Mar 1, 2017 at 15:08 | history | asked | Adé | CC BY-SA 3.0 |