The choice of MongoDB sharding key

The two most prone areas of error

– Incrementing the Sharding key

– Random sharding Key

Sharding Key Selection

Incrementing the Sharding key

– Fewer data files (advantages)

– Because the data file is incremented, the insert write Io is permanently placed on the last piece, resulting in the last write hotspot

– At the same time, as the last piece of data increases, it will continue to migrate to the previous

Sharding Key Selection

Random sharding Key

– Uniform data distribution with insert write IO evenly distributed across multiple slices (advantage)

– Large number of random IO, hard disk loads

This article is from the DBA Sky blog, so be sure to keep this source http://9425473.blog.51cto.com/9415473/1680149

The choice of MongoDB sharding key