How multiple indexes affect sharding in mongoDB?

Question

Assume I have a collection with 100 million rows and I will need to do sharding to improve performance. However, the collection is heavily indexed. For some reasons, there are 20 different indexes created for the collection.

Based on my understanding, the collection is going to be sharded based on a shard key, which is similar to an index. How would the rest 20-1 =19 indexes perform after sharding? If I am writing a record, would sharding helps performance at all in this case? Would an index get broke down based on how many shards you have?

D. SM · Answer 1 · 2020-07-24T01:19:23.603

0

The indexes are handled by mongods on each shard. They are separate from decision to shard or shard key choice.

edited Jul 24 '20 at 01:19

answered Jul 23 '20 at 18:58

D. SM

13,584
3
12
21

Would sharding affect writing performance in this case? – Qing Liu Jul 24 '20 at 01:13
Which case are you referring to? – D. SM Jul 24 '20 at 01:18
In my own case where there is a huge collection with 20 indexes. Writing is already slow. Would sharding affect writing performance? – Qing Liu Jul 24 '20 at 15:00
Try it and see? – D. SM Jul 24 '20 at 15:01

How multiple indexes affect sharding in mongoDB?

1 Answers1