global primary key

Architect's Guide

Dec 11, 2024 · Databases

Challenges and Limitations of Database Sharding in Large‑Scale E‑commerce Systems

The article examines why MySQL sharding (分库分表) is adopted for high‑traffic e‑commerce, outlines its inherent problems such as distributed transaction handling, index and global key constraints, operational overhead, and argues that distributed databases like OceanBase offer a more robust alternative.

Database ScalingDistributed DatabaseMySQL

0 likes · 10 min read

Challenges and Limitations of Database Sharding in Large‑Scale E‑commerce Systems

Architect

Sep 18, 2023 · Databases

Database Sharding: Data Partitioning Strategies, Challenges, and Practical Solutions

The article explains why relational databases become performance bottlenecks at large scales, introduces vertical and horizontal sharding techniques, discusses their advantages and drawbacks, and provides detailed guidance on handling distributed transactions, joins, pagination, global primary keys, and ID generation strategies.

ID generationShardingdatabase partitioning

0 likes · 24 min read

Database Sharding: Data Partitioning Strategies, Challenges, and Practical Solutions

Laravel Tech Community

May 23, 2020 · Databases

Database Sharding: Principles, Methods, and Tools

The article explains why and when to apply database sharding, describes horizontal and vertical partitioning methods, lists common sharding tools, and discusses challenges such as distributed transactions, join avoidance, pagination, and global primary key generation.

database shardingdistributed transactionsglobal primary key

0 likes · 14 min read

Database Sharding: Principles, Methods, and Tools