vertical sharding

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

JD Tech

Jun 8, 2018 · Backend Development

System Splitting and Architectural Evolution: Strategies for Scaling and Decoupling

The article explains how increasing business complexity and throughput demands drive system splitting—horizontal scaling, vertical and business sharding, and database partitioning—and describes the subsequent architectural evolution toward micro‑services, caching, indexing, and asynchronous processing to improve capacity, robustness, and performance.

architecturecachinghorizontal scaling

0 likes · 10 min read

System Splitting and Architectural Evolution: Strategies for Scaling and Decoupling

Qunar Tech Salon

Feb 18, 2016 · Databases

Challenges and Strategies for Database Vertical and Horizontal Sharding

The article examines the increasing storage bottleneck in large-scale web systems, explains vertical and horizontal database sharding, discusses the technical difficulties they introduce—including join rewrites, transaction handling, and ORM integration—and proposes practical approaches to minimize service impact and manage distributed transactions.

ORMdatabase shardingdistributed transactions

0 likes · 15 min read

Challenges and Strategies for Database Vertical and Horizontal Sharding

Art of Distributed System Architecture Design

Nov 6, 2015 · Databases

Airbnb’s Database Scaling Using MySQL Replication and Vertical Sharding

Airbnb tackled rapid data growth by vertically partitioning tables across multiple MySQL databases using Amazon RDS replication, minimizing downtime through read‑replica promotion, and implementing a staged migration that reduced primary database writes by 33%, cut size by 20%, and improved stability and scalability.

AirbnbAmazon RDSDatabase Scaling

0 likes · 12 min read

Airbnb’s Database Scaling Using MySQL Replication and Vertical Sharding