range partitioning

High Availability Architecture

Oct 26, 2021 · Databases

Practical Guide to Horizontal Database Sharding: Design Principles, Common Schemes, and Expansion Strategies

This article explains the background, design criteria, and practical implementations of horizontal database sharding—including range, hash, gene, routing‑table, and consistent‑hash methods—while discussing common pitfalls, data‑skew mitigation, and both doubling and consistent‑hash expansion techniques for MySQL clusters.

Database ScalingHorizontal PartitioningMySQL

0 likes · 24 min read

Practical Guide to Horizontal Database Sharding: Design Principles, Common Schemes, and Expansion Strategies

Code Ape Tech Column

Mar 22, 2021 · Databases

Database Sharding: Horizontal Partitioning, Hash Modulo and Range Schemes, and a Hybrid Design

The article explains vertical and horizontal database sharding, compares hash-modulo and range partitioning schemes with their advantages and drawbacks, and proposes a hybrid group‑based design that balances load, avoids hotspots, and simplifies scaling without costly data migrations.

Database ShardingHorizontal Partitioninghash modulo

0 likes · 12 min read

Architecture Digest

Mar 13, 2021 · Databases

Database Sharding: Vertical vs Horizontal Partitioning, Hash Modulo and Range Schemes

This article explains vertical and horizontal database sharding, compares hash‑modulo and range‑based partitioning schemes, and discusses their advantages, drawbacks, and the impact on scaling and hotspot problems in large‑scale applications.

Database ShardingHorizontal Splittinghash modulo

0 likes · 7 min read

Database Sharding: Vertical vs Horizontal Partitioning, Hash Modulo and Range Schemes

Architect's Tech Stack

Apr 26, 2019 · Databases

Database Sharding: Vertical vs Horizontal Partitioning and Hash vs Range Strategies

The article explains vertical and horizontal database sharding, compares hash-modulo and range-based partitioning schemes, discusses their advantages and drawbacks such as hotspot issues and migration challenges, and highlights the trade‑offs when scaling large‑scale order data.

Horizontal PartitioningShardingVertical Partitioning

0 likes · 8 min read

Database Sharding: Vertical vs Horizontal Partitioning and Hash vs Range Strategies