BestHub
Sign in
Tagged articles
18 articles
Page 1 of 1
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Aug 13, 2025 · Databases

Mastering Data Sharding: Vertical & Horizontal Splitting Strategies for Scalable Systems

This article explains essential data sharding techniques for large-scale architectures, emphasizing the priority of vertical splitting by business modules, followed by horizontal partitioning of hot tables, and outlines stable sharding rules, hotspot avoidance, and minimizing cross‑shard transactions to ensure optimal performance.

Database designdata shardinghorizontal partitioning
0 likes · 4 min read
Mastering Data Sharding: Vertical & Horizontal Splitting Strategies for Scalable Systems
Architect
Architect
Mar 29, 2024 · Databases

Understanding Database Sharding and Partitioning with ShardingSphere

This article explains the fundamentals of database sharding and partitioning, why they are needed for massive data volumes, various vertical and horizontal splitting strategies, routing algorithms, client vs. proxy deployment models, and the practical challenges and solutions when using ShardingSphere 5.x.

PartitioningShardingSpheredatabase sharding
0 likes · 17 min read
Understanding Database Sharding and Partitioning with ShardingSphere
Architect's Guide
Architect's Guide
Jun 20, 2023 · Databases

Why and How to Perform Database Sharding and Table Partitioning

Database sharding and table partitioning are essential scaling techniques that separate data across multiple databases and tables to handle growing user volume, data size, and concurrency, with explanations of when to split, methods (horizontal vs vertical), and a comparison of popular middleware solutions.

Table Partitioningdatabase shardinghorizontal scaling
0 likes · 14 min read
Why and How to Perform Database Sharding and Table Partitioning
dbaplus Community
dbaplus Community
Nov 18, 2022 · Databases

When and How to Shard Databases: A Complete Guide to Partitioning, Algorithms, and Tools

This article explains why and when to apply database sharding, distinguishes between sharding databases, tables, or both, describes horizontal and vertical splitting, guides key selection and sharding algorithms, covers global ID generation, lists open‑source tools, and discusses the operational challenges introduced by sharding.

ID generationPartitioninghorizontal-splitting
0 likes · 17 min read
When and How to Shard Databases: A Complete Guide to Partitioning, Algorithms, and Tools
Architect's Guide
Architect's Guide
Nov 11, 2022 · Databases

Database Sharding: Table Partitioning, Horizontal and Vertical Splitting, and Implementation with Sharding-JDBC and Mycat

This article explains why high‑concurrency big‑data systems need database sharding, describes table‑level partitioning methods (modulus and range), shows how to implement them with MySQL and Java code, compares vertical and horizontal database splitting, and evaluates middleware solutions such as Sharding‑JDBC and Mycat.

Javadatabase partitioninghorizontal scaling
0 likes · 11 min read
Database Sharding: Table Partitioning, Horizontal and Vertical Splitting, and Implementation with Sharding-JDBC and Mycat
Top Architect
Top Architect
Mar 16, 2022 · Databases

Comprehensive Guide to Database Sharding: Vertical & Horizontal Partitioning, Global ID Generation, and Distributed Transaction Challenges

This article explains the concepts, methods, advantages, and drawbacks of database sharding, covering vertical and horizontal partitioning, sharding rules, global primary key generation, distributed transaction issues, cross‑node queries, pagination, data migration, and practical case studies, with code examples and diagrams.

Distributed TransactionsGlobal ID Generationdatabase partitioning
0 likes · 24 min read
Comprehensive Guide to Database Sharding: Vertical & Horizontal Partitioning, Global ID Generation, and Distributed Transaction Challenges
dbaplus Community
dbaplus Community
Nov 18, 2021 · Databases

When Should You Split Your Database Tables? Practical Guidelines and Real‑World Cases

This article examines the signs that a database table has reached its limits, explains why vertical and horizontal sharding are needed, offers concrete sizing formulas, compares hash, range and consistent‑hash partitioning, and shares large‑scale case studies from Suning, JD, Meituan, Ant Financial and Taobao.

Distributed TransactionsPerformance Optimizationhorizontal partitioning
0 likes · 14 min read
When Should You Split Your Database Tables? Practical Guidelines and Real‑World Cases
IT Architects Alliance
IT Architects Alliance
Jan 10, 2021 · Backend Development

How to Split Complex Systems and Evolve Architecture for Scalability

The article explains why growing business complexity and throughput demands force system decomposition and architectural upgrades, detailing horizontal scaling, vertical and business splitting, database sharding, caching strategies, and the evolution from monolithic to micro‑service structures.

MicroservicesPerformance OptimizationSystem Architecture
0 likes · 8 min read
How to Split Complex Systems and Evolve Architecture for Scalability
Architecture Digest
Architecture Digest
Jun 11, 2019 · Databases

Database Optimization for Billion‑Scale Data: Partitioning, Sharding, and Vertical Splitting in MySQL

This article explains how a high‑traffic messaging platform with tens of millions of users and billions of daily records can be optimized using MySQL partitioning, sharding (both client‑side and proxy‑side), vertical database splitting, and practical migration scripts to maintain performance and availability.

Big DataDatabase Optimizationmysql
0 likes · 15 min read
Database Optimization for Billion‑Scale Data: Partitioning, Sharding, and Vertical Splitting in MySQL
21CTO
21CTO
May 23, 2018 · Backend Development

How to Evolve a Monolithic System into a Distributed, Service‑Oriented Architecture

This article explains why growing business complexity and throughput demands force a system to be split and refactored, describing horizontal scaling, vertical and business splitting, database sharding, and the resulting architectural evolution toward micro‑services.

MicroservicesSystem Architecturedatabase sharding
0 likes · 9 min read
How to Evolve a Monolithic System into a Distributed, Service‑Oriented Architecture
Architecture Digest
Architecture Digest
May 23, 2018 · Backend Development

System Splitting and Architectural Evolution: From Monolith to Distributed Services

The article reviews how increasing business complexity and throughput demands drive the need to split applications and databases, adopt horizontal and vertical scaling, implement business and service-level partitioning, and evolve system architecture toward micro‑services, caching, and asynchronous processing.

Microservicesarchitecture evolutiondatabase sharding
0 likes · 9 min read
System Splitting and Architectural Evolution: From Monolith to Distributed Services
AntTech
AntTech
May 17, 2018 · Backend Development

Challenges and Solutions for Transforming Traditional Payment Systems to Distributed Architecture

The article examines how the rapid growth of mobile and aggregated payments strains traditional IOE‑based payment systems, and outlines a comprehensive distributed transformation strategy that includes vertical service‑oriented splitting, horizontal sharding by data type, and practical approaches to handling distributed transactions, cross‑shard queries, scaling, disaster recovery, and operational monitoring.

horizontal-splittingpaymentsharding
0 likes · 15 min read
Challenges and Solutions for Transforming Traditional Payment Systems to Distributed Architecture
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Nov 13, 2016 · Databases

How to Scale an Order System Beyond 200GB with Vertical & Horizontal Sharding

This article explains how a massive order database exceeding 200 GB was vertically and horizontally sharded, introduces query, range, and hash sharding strategies, presents a custom timestamp‑based unique ID scheme, and outlines a multi‑phase data migration plan to achieve long‑term scalability.

Data Migrationhorizontal-splittingorder system scaling
0 likes · 9 min read
How to Scale an Order System Beyond 200GB with Vertical & Horizontal Sharding
Architect
Architect
Jan 31, 2016 · Databases

Understanding Database Vertical and Horizontal Splitting, Their Challenges, and Practical Solutions

The article explains the concepts of vertical and horizontal database splitting, compares their technical difficulties, discusses the impact on joins and transactions, and proposes practical approaches such as careful SQL refactoring, ORM decoupling, and selective use of distributed‑transaction techniques to maintain system stability and scalability.

Distributed TransactionsORMScalability
0 likes · 14 min read
Understanding Database Vertical and Horizontal Splitting, Their Challenges, and Practical Solutions