BestHub
search
Sign in
Tag

Hash Sharding

0 views collected around this technical thread.

vivo Internet Technology
vivo Internet Technology
Oct 20, 2021 · Databases

Database Sharding Strategies: Common Approaches, Pitfalls, and Best Practices

Effective MySQL sharding requires sustainable, low‑skew designs, favoring hash‑based methods with proper coprime counts, two‑stage partitioning, routing tables, or consistent hashing, while supporting expansion via doubling or flexible consistent‑hash growth to avoid hot spots and uneven data distribution.

Data PartitioningHash ShardingMySQL
0 likes · 23 min read
Database Sharding Strategies: Common Approaches, Pitfalls, and Best Practices
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
May 13, 2021 · Databases

Why MongoDB’s Unique Index Fails When Index Keys Exceed 1024 Bytes

The article reproduces a MongoDB issue where queries using a hashed shard key return no results and a compound unique index silently accepts duplicate documents, explains that the failIndexKeyTooLong parameter allows oversized index entries to be stored without indexing, and shows how to reproduce and fix the problem.

Hash ShardingIndexMongoDB
0 likes · 34 min read
Why MongoDB’s Unique Index Fails When Index Keys Exceed 1024 Bytes