Shulou(Shulou.com)06/01 Report--

The two most common misunderstandings

-incremental sharding key

-Random sharding key

The choice of Sharding key

Incremental Sharding key

-less data file movement (advantage)

-because the data file is incremented, the write IO of insert will be permanently placed on the last piece, creating a write hotspot for the last piece.

-at the same time, as the amount of data of the last piece increases, it will continue to migrate to the previous piece.

The choice of Sharding key

Random sharding key

-the data is evenly distributed, and the write IO of insert is evenly distributed on multiple chips (advantage)

-A large number of random IO, the disk is overloaded

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.