Tagged articles
vertical splitting
18 articles · Page 1 of 1
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.
Data ShardingHorizontal Partitioningdatabase design
0 likes · 4 min read

This article explains the concepts of database sharding and partitioning, compares common middleware solutions, and offers practical guidance on choosing and implementing horizontal or vertical splits to handle rapid growth and high concurrency in modern applications.
Horizontal ScalingPartitioningdatabase sharding
0 likes · 12 min read

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.
MySQLPartitioningShardingSphere
0 likes · 17 min read

This article explains why database sharding is needed, the problems caused by oversized databases and tables, and how to apply vertical and horizontal splitting using MyCat, including configuration examples, splitting strategies, and testing procedures.
MySQLMycatSharding
0 likes · 10 min read

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.
Horizontal ScalingTable Partitioningdatabase sharding
0 likes · 14 min read

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.
Partitioninghorizontal-splittingid-generation
0 likes · 17 min read

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.
Horizontal ScalingJavaMySQL
0 likes · 11 min read

This article explains the concepts, motivations, strategies, and challenges of database and table sharding, covering vertical and horizontal partitioning, range and hash algorithms, when to adopt them, and popular middleware solutions for scalable MySQL architectures.
Horizontal ScalingMySQLPartitioning
0 likes · 13 min read

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.
Global ID GenerationHorizontal ScalingSharding
0 likes · 24 min read

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.
Horizontal Partitioningdistributed transactionslarge-scale systems
0 likes · 14 min read

This article explains vertical and horizontal database sharding, compares hash‑modulo and range‑based partitioning schemes, and discusses their advantages, drawbacks, and the impact on scaling and hotspot problems in large‑scale applications.
database shardinghash modulohorizontal-splitting
0 likes · 7 min read

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.
CachingHorizontal Scalingdatabase sharding
0 likes · 8 min read

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.
MySQLbig datadatabase optimization
0 likes · 15 min read


21CTOMay 23, 2018 · Backend Development
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.
Horizontal Scalingdatabase shardingmicroservices
0 likes · 9 min read

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.
Horizontal Scalingarchitecture evolutiondatabase sharding
0 likes · 9 min read


AntTechMay 17, 2018 · Backend Development
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.
Shardinghorizontal-splittingpayment
0 likes · 15 min read

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

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.
ORMdatabasedistributed transactions
0 likes · 14 min read
