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

This article explains the concepts of database and table sharding, why they are needed, various vertical and horizontal splitting strategies, range and hash partitioning methods, their advantages and drawbacks, timing considerations, common challenges such as transactions and distributed IDs, and introduces popular sharding middleware.

Distributed TransactionsVertical Partitioningdatabase sharding

0 likes · 12 min read

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

dbaplus Community

Sep 29, 2021 · Databases

How ByteKV Achieves Strong Consistency and Horizontal Scalability with Range Partitioning

This article explains ByteKV's design—using range partitioning, a custom Raft implementation, multi‑layer architecture, and advanced load‑balancing strategies—to provide strong consistency, flexible data models, and seamless scalability for large‑scale storage workloads.

BlockDBByteRaftSchema Change

0 likes · 47 min read

How ByteKV Achieves Strong Consistency and Horizontal Scalability with Range Partitioning

Architects' Tech Alliance

Oct 15, 2018 · Databases

Data Sharding in Distributed Systems: Partitioning Strategies, Metadata Management, and Consistency Mechanisms

The article explains how distributed storage systems solve the fundamental problems of data sharding and redundancy by describing three sharding methods (hash, consistent‑hash, and range‑based), the criteria for choosing a shard key, the role of metadata servers, and consistency techniques such as leasing, all illustrated with concrete examples and code snippets.

Distributed Systemsconsistent hashingdatabases

0 likes · 25 min read

Data Sharding in Distributed Systems: Partitioning Strategies, Metadata Management, and Consistency Mechanisms

dbaplus Community

Sep 17, 2018 · Databases

Mastering Data Sharding: Hash, Consistent Hash, and Range Partition Strategies Explained

This article explains the core concepts of data sharding in distributed storage systems, compares hash, consistent‑hash, and range‑based partitioning, discusses how to choose sharding keys, examines metadata server designs and high‑availability solutions, and introduces lease‑based cache consistency mechanisms.

consistent hashinghash partitionlease mechanism

0 likes · 28 min read

Mastering Data Sharding: Hash, Consistent Hash, and Range Partition Strategies Explained