Nov 5, 2026 · Databases

ShardingSphere Sharding: Production Patterns, Pitfalls & Source-Code Deep Dive

This article details Spring Boot database sharding with ShardingSphere, covering sharding strategies, configuration, five-step SQL routing, rewrite and merge engines, distributed ID generation, pagination pitfalls, cross-shard joins, scaling procedures, and eight common pitfalls with troubleshooting tips.

PaginationSQL routingShardingSphere

0 likes · 22 min read

ShardingSphere Sharding: Production Patterns, Pitfalls & Source-Code Deep Dive

Wukong Talks Architecture

May 16, 2023 · Databases

Understanding Sharding: 21 Common Concepts of Database Partitioning

This article introduces the fundamental concepts of database sharding, including data fragmentation, nodes, logical and physical tables, broadcast and single tables, sharding keys, strategies, algorithms, binding tables, SQL parsing, routing, rewriting, execution, result merging, distributed primary keys, data masking, distributed transactions, migration, and shadow databases, providing a comprehensive guide for designing and operating a sharded architecture.

Broadcast TableHorizontal ScalingSQL routing

0 likes · 19 min read

Understanding Sharding: 21 Common Concepts of Database Partitioning