Master Database Sharding: Solving Read Diffusion with Range and Modulo Strategies

This article explains why large MySQL tables degrade performance, introduces vertical and horizontal sharding techniques—including range‑based and modulo‑based partitioning—covers the read‑diffusion problem caused by non‑sharding keys, and presents practical solutions such as auxiliary index tables, Elasticsearch integration, and TiDB as a distributed alternative.

ElasticsearchRange ShardingTiDB

0 likes · 15 min read

Master Database Sharding: Solving Read Diffusion with Range and Modulo Strategies

ITPUB

May 21, 2023 · Databases

Mastering Database Sharding: When, How, and Pitfalls of Partitioning

This article explains the concept, motivations, design methods, common patterns, and trade‑offs of database sharding (both table and database level), offering practical code examples, scalability criteria, and guidance on avoiding over‑engineering while considering alternatives like TiDB.

Hash ShardingPartitioningRange Sharding

0 likes · 19 min read

Mastering Database Sharding: When, How, and Pitfalls of Partitioning

Architect

Sep 28, 2021 · Databases

Database Sharding Strategies: When to Use Vertical, Horizontal, and Range Partitioning

This article explains how to decide between database and table sharding, describes vertical, horizontal, and range partitioning techniques, discusses their trade‑offs and implementation details, and offers practical guidance for solving query challenges in high‑traffic, write‑intensive systems.

Interview PreparationRange ShardingScalability

0 likes · 10 min read

Database Sharding Strategies: When to Use Vertical, Horizontal, and Range Partitioning

Java Backend Technology

Mar 11, 2021 · Databases

Combine Hash and Range Sharding to Prevent Hotspots Without Data Migration

This article explains how to split large-scale database tables using vertical and horizontal partitioning, compares hash-modulo and range-based sharding, and proposes a hybrid approach that leverages both methods to balance data distribution, avoid hotspot issues, and eliminate the need for costly data migrations during scaling.

Data MigrationHash ShardingRange Sharding

0 likes · 13 min read

Combine Hash and Range Sharding to Prevent Hotspots Without Data Migration

Programmer DD

Jul 30, 2019 · Databases

Mastering Database Sharding: When and How to Split Tables and Schemas

This article reviews the complete process of database and table sharding, covering when to shard, range and hash strategies, combining both, data migration challenges, business compatibility, and long‑term archiving to keep MySQL workloads manageable.

Data MigrationHash ShardingRange Sharding

0 likes · 11 min read

Mastering Database Sharding: When and How to Split Tables and Schemas