Tagged articles
Horizontal Partitioning
63 articles · Page 1 of 1
The article explains why sharding should be a last‑resort scaling option, describes vertical and horizontal partitioning, compares hash, range and directory sharding schemes, discusses hotspots, routing, data colocation, migration steps and tool choices, and warns about the operational complexity involved.
Data ConsistencyHorizontal PartitioningSharding
0 likes · 16 min read

The article walks through diagnosing database bottlenecks, explains MySQL replication flow, read‑write separation benefits and limits, shows when to apply vertical versus horizontal partitioning, details sharding‑key selection, cross‑shard challenges, high‑availability steps, and presents a complete e‑commerce case study.
ConsistencyDatabase ReplicationHigh Availability
0 likes · 29 min read

When a single database table grows to millions of rows, query performance and storage become bottlenecks, and this article explains why sharding is needed, introduces Sharding-JDBC as a lightweight solution, and walks through the complete setup, configuration, code implementation, testing, and advanced concepts such as sharding strategies, key generation, binding tables, and broadcast tables for SpringBoot projects.
Horizontal PartitioningMyBatisMySQL
0 likes · 33 min read

This article details a comprehensive sharding strategy for a high‑traffic message table, explaining why early partitioning is essential, how to design language‑based vertical shards combined with hash‑based horizontal shards, calculate table counts and virtual nodes, and execute a zero‑downtime migration using dual‑writes and gradual traffic rollout.
Horizontal PartitioningMySQLPerformance Optimization
0 likes · 16 min read

This article explains why large MySQL tables degrade performance, introduces vertical and horizontal sharding techniques—including range‑based and modulo‑based partitioning—covers the read‑diffusion problem caused by non‑sharding keys, and presents practical solutions such as auxiliary index tables, Elasticsearch integration, and TiDB as a distributed alternative.
ElasticsearchHorizontal PartitioningRange Sharding
0 likes · 15 min read

This article explains why database sharding becomes essential as user growth and data volume surge, describes horizontal and vertical partitioning methods, compares range and hash routing, and reviews popular sharding middleware with their advantages and drawbacks to help you choose the right solution.
Horizontal PartitioningVertical Partitioningdatabase sharding
0 likes · 12 min read

This article explains why and how to shard a MySQL database, covering vertical and horizontal partitioning, distributed transaction handling, unique ID generation, a real‑world e‑commerce case study, and future considerations for distributed architectures.
Horizontal PartitioningVertical Partitioningdatabase sharding
0 likes · 9 min read

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

The article explains why and when to apply database sharding and table partitioning, illustrates real‑world growth scenarios, compares horizontal and vertical splitting methods, reviews common sharding middleware such as Cobar, TDDL, Atlas, Sharding‑jdbc (ShardingSphere) and Mycat, and offers practical recommendations for different company sizes.
Horizontal Partitioningdatabase shardingmiddleware
0 likes · 14 min read

This article provides a comprehensive, step‑by‑step tutorial on using Apache ShardingSphere and Sharding‑JDBC to implement horizontal, vertical, and broadcast sharding, covering core concepts, sharding strategies, configuration examples, and practical code snippets for real‑world database partitioning.
Broadcast TableHorizontal PartitioningSharding-JDBC
0 likes · 22 min read

This article explains why single‑database resources hit limits, introduces horizontal and vertical sharding techniques, discusses how to choose effective split keys, and reviews common key‑generation methods such as auto‑increment, UUID, and Snowflake IDs for scalable database architectures.
Horizontal PartitioningSplit KeyVertical Partitioning
0 likes · 8 min read


ITPUBJun 4, 2023 · Databases
This article explains why database sharding is needed when performance bottlenecks appear, outlines the criteria and timing for adopting sharding, and provides detailed step‑by‑step guidance on both database‑level and table‑level partitioning, including common pitfalls and solutions.
Horizontal PartitioningPerformance Optimizationdatabase sharding
0 likes · 13 min read

This article explains the need for database sharding as applications scale, describes horizontal and vertical partitioning techniques, compares popular sharding middleware, and offers practical guidance on choosing and deploying sharding solutions for different workloads.
Horizontal PartitioningMySQLVertical Partitioning
0 likes · 13 min read

This article explains the concepts of database sharding, compares vertical and horizontal partitioning, discusses ID‑range and modulo sharding methods, analyzes the read‑amplification problem caused by non‑sharding keys, and presents practical solutions such as auxiliary index tables, Elasticsearch integration, and TiDB adoption.
ElasticsearchHorizontal PartitioningMySQL
0 likes · 14 min read


21CTOMar 12, 2023 · Databases
Database sharding—splitting data across multiple databases and tables—is essential as applications scale, and this article explains the motivations, differences between sharding and partitioning, horizontal and vertical splits, common middleware options like Cobar, TDDL, Atlas, ShardingSphere, and Mycat, and how to choose the right solution.
Horizontal PartitioningMySQLdatabase sharding
0 likes · 12 min read

This article explains the concepts, strategies, and practical scenarios for MySQL database partitioning, covering both table splitting (vertical and horizontal) and database splitting (vertical and horizontal), with examples, advantages, and when to apply each technique to handle large-scale data workloads.
Horizontal PartitioningShardingVertical Partitioning
0 likes · 9 min read


ITPUBNov 29, 2022 · Databases
This article explains MySQL's theoretical row limits, why performance degrades long before reaching them, and how horizontal and vertical database sharding can distribute massive datasets across multiple instances to improve load handling and enable seamless scaling.
Horizontal PartitioningMySQLSharding
0 likes · 7 min read

This article explains why database sharding (both vertical and horizontal) is needed to overcome performance bottlenecks, outlines practical thresholds for splitting tables, describes vertical and horizontal partitioning techniques, and discusses key issues such as distributed transactions, cross‑node queries, global primary keys, and scaling strategies.
Horizontal PartitioningVertical Partitioningdatabase sharding
0 likes · 9 min read

This article explains the reasons for database sharding, compares vertical (scale‑up) and horizontal (scale‑out) partitioning methods, illustrates vertical database/table splits and horizontal partition strategies such as HASH, RANGE, LIST, KEY and composite, and discusses the challenges like distributed transactions, cross‑database joins and increased management overhead.
Horizontal PartitioningMySQLPartitioning
0 likes · 14 min read

This article explains the concepts of database and table sharding, why they are needed, various vertical and horizontal splitting strategies, range and hash partitioning methods, their advantages and drawbacks, timing considerations, common challenges such as transactions and distributed IDs, and introduces popular sharding middleware.
Horizontal PartitioningVertical Partitioningdatabase sharding
0 likes · 12 min read

This article provides a comprehensive guide to Sharding-JDBC, covering the challenges of database sharding such as distributed transactions, cross‑node joins, pagination, global key collisions, and demonstrates practical configuration and code examples for vertical and horizontal partitioning using Spring Boot.
Horizontal PartitioningSharding-JDBCSpring Boot
0 likes · 18 min read

This article outlines the background, analysis, design, testing strategy, migration plan, and production quality results for implementing horizontal sharding, table splitting, and Elasticsearch integration in a growing enterprise database system.
Horizontal Partitioningdatabase shardingdual-write
0 likes · 12 min read

Database sharding improves performance by partitioning tables vertically or horizontally and routing rows with consistent hashing, while ShardingJDBC rewrites SQL for physical tables, adds missing columns, corrects pagination, splits batch inserts, and merges results using sorting, grouping, aggregation, and pagination engines.
Consistent HashingHorizontal PartitioningSQL Rewrite
0 likes · 15 min read

This article explains what database sharding (horizontal and vertical partitioning) is, why it is needed, the implementation strategies, and compares two popular solutions—Mycat middleware and Sharding-JDBC—highlighting their advantages, drawbacks, and typical use cases.
Horizontal PartitioningMycatSharding
0 likes · 10 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 PartitioningPerformance Optimizationdistributed transactions
0 likes · 14 min read

This article explains why and how to apply vertical (business‑oriented) and horizontal (data‑oriented) sharding, covering single‑database, table splitting, database splitting, combined sharding, read‑write separation, routing algorithms, and real‑world case studies to improve scalability and performance.
Horizontal PartitioningRead-Write SeparationVertical Partitioning
0 likes · 14 min read

This article explains the concepts, characteristics, and practical scenarios of database sharding—including vertical and horizontal table partitioning as well as vertical and horizontal database partitioning—helping developers decide when and how to apply each strategy to improve scalability and performance.
Horizontal PartitioningMySQLSharding
0 likes · 10 min read

This article explains the background, design criteria, and practical implementations of horizontal database sharding—including range, hash, gene, routing‑table, and consistent‑hash methods—while discussing common pitfalls, data‑skew mitigation, and both doubling and consistent‑hash expansion techniques for MySQL clusters.
Consistent HashingHorizontal PartitioningMySQL
0 likes · 24 min read

This article explains the concepts, characteristics, and practical scenarios of vertical and horizontal table partitioning as well as vertical and horizontal database sharding in MySQL, helping developers decide when and how to apply each strategy for large‑scale applications.
Horizontal PartitioningMySQLVertical Partitioning
0 likes · 8 min read

This article explains how to decide between database and table sharding, describes vertical, horizontal, and range partitioning techniques, discusses their trade‑offs and implementation details, and offers practical guidance for solving query challenges in high‑traffic, write‑intensive systems.
Horizontal PartitioningInterview PreparationRange Sharding
0 likes · 10 min read

This article explains the performance bottlenecks of relational databases, introduces sharding concepts such as horizontal, vertical, and table partitioning, discusses associated challenges like distributed transactions and global primary keys, and provides practical solutions and tool recommendations for implementing effective database partitioning.
Global ID GenerationHorizontal PartitioningPerformance Optimization
0 likes · 18 min read

This article explains why database performance bottlenecks arise, outlines criteria for deciding when to shard databases and tables, and provides detailed strategies for SQL tuning, table restructuring, horizontal and vertical splitting, single‑ versus multi‑database sharding, as well as handling cross‑database joins, distributed transactions, pagination, and ID generation.
Horizontal PartitioningPerformance OptimizationSQL Tuning
0 likes · 12 min read

This article explains vertical and horizontal database partitioning, compares hash‑modulo and range sharding schemes, and proposes a hybrid group‑based design that balances uniform data distribution with painless scaling, eliminating hotspots while avoiding costly data migrations.
Hash RoutingHorizontal PartitioningVertical Partitioning
0 likes · 12 min read

The article explains vertical and horizontal database sharding, compares hash-modulo and range partitioning schemes with their advantages and drawbacks, and proposes a hybrid group‑based design that balances load, avoids hotspots, and simplifies scaling without costly data migrations.
Horizontal Partitioningdatabase shardinghash modulo
0 likes · 12 min read

This article explains what database sharding (splitting databases and tables) is, why it improves performance and availability, how to choose between horizontal and vertical partitioning, design ID generation, handle distributed transactions, migrate data smoothly, and configure Alibaba's TDDL middleware with practical code examples.
Horizontal PartitioningTDDLVertical Partitioning
0 likes · 20 min read

This article analyzes common database performance bottlenecks, explains when to apply IO‑ or CPU‑focused optimizations, and provides a detailed guide to horizontal and vertical sharding, partitioning strategies, tooling choices, implementation steps, and practical pitfalls for scalable systems.
Horizontal PartitioningMySQLPerformance Optimization
0 likes · 10 min read

This article introduces Sharding-JDBC, explaining its basic usage, core concepts, sharding strategies, SQL processing workflow, configuration examples, and code snippets, while emphasizing the importance of understanding its underlying principles for effective database horizontal partitioning in Java applications.
Horizontal PartitioningJavaSQL routing
0 likes · 70 min read

This article analyzes common database performance bottlenecks such as I/O and CPU limits, explains how horizontal and vertical sharding (including database and table partitioning) can alleviate these issues, introduces practical tools and step‑by‑step implementation guidance, and discusses related challenges like non‑partition key queries and scaling.
Horizontal PartitioningShardingVertical Partitioning
0 likes · 8 min read

This article explains common I/O and CPU bottlenecks in databases, compares horizontal and vertical sharding techniques, outlines practical partitioning strategies, introduces popular sharding tools, and provides step‑by‑step guidance for implementing and scaling sharded architectures.
Horizontal PartitioningPerformance OptimizationVertical Partitioning
0 likes · 10 min read

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

This article explains common database performance bottlenecks such as IO and CPU limits, introduces horizontal and vertical sharding concepts, compares sharding tools, outlines practical implementation steps, discusses common pitfalls, and provides scaling strategies to keep your data layer responsive under heavy load.
Horizontal PartitioningPerformance OptimizationVertical Partitioning
0 likes · 11 min read

This article analyzes common database I/O and CPU bottlenecks, explains horizontal and vertical sharding concepts, presents practical sharding rules, discusses tooling such as Sharding‑Sphere, TDDL and Mycat, and outlines step‑by‑step procedures and common pitfalls for scaling relational databases.
Horizontal PartitioningPerformance OptimizationSharding
0 likes · 11 min read

This article explains why and when to split databases, compares vertical and horizontal sharding methods, outlines practical steps for determining split mode, fields, rules and quantity, and discusses scaling, read/write separation, and common challenges with solutions.
Horizontal PartitioningRead-Write SeparationVertical Partitioning
0 likes · 15 min read

This article explains the reasons for splitting databases, describes vertical and horizontal sharding techniques, compares their benefits and drawbacks, and advises performing horizontal sharding before vertical partitioning to improve scalability and performance in large‑scale applications.
Horizontal PartitioningMySQLVertical Partitioning
0 likes · 9 min read

This article explains the concepts, benefits, and challenges of database sharding—including vertical and horizontal partitioning, common splitting strategies, handling distributed transactions, cross‑node joins, pagination, global primary keys, and migration—while offering practical guidelines on when to adopt sharding and which tools can assist.
Horizontal PartitioningVertical Partitioningdatabase sharding
0 likes · 26 min read

This tutorial explains DBLE's core horizontal sharding mechanism, detailing the purpose of data partitioning for massive tables and walking through the three essential XML configuration files—rule.xml, schema.xml, and server.xml—that define sharding rules, schema mappings, and system parameters.
DBLEHorizontal PartitioningXML configuration
0 likes · 6 min read

This article examines common database performance bottlenecks such as I/O and CPU limits, explains when to apply horizontal or vertical sharding, partitioning, and scaling techniques, compares tools like ShardingSphere, TDDL, and Mycat, and provides practical steps for implementation, migration, and troubleshooting.
Horizontal PartitioningPerformance OptimizationVertical Partitioning
0 likes · 9 min read

This article reviews the complete process of database and table sharding, covering when to shard, range and hash strategies, combining both, data migration challenges, business compatibility, and long‑term archiving to keep MySQL workloads manageable.
Hash ShardingHorizontal PartitioningRange Sharding
0 likes · 11 min read


21CTOMay 9, 2019 · Databases
This article explains common I/O and CPU bottlenecks in databases, compares horizontal and vertical sharding techniques, introduces practical tools, outlines migration steps, and discusses typical challenges such as non‑partition‑key queries, cross‑shard pagination, and scaling.
BottleneckHorizontal PartitioningSharding
0 likes · 8 min read

The article explains vertical and horizontal database sharding, compares hash-modulo and range-based partitioning schemes, discusses their advantages and drawbacks such as hotspot issues and migration challenges, and highlights the trade‑offs when scaling large‑scale order data.
Horizontal PartitioningShardingVertical Partitioning
0 likes · 8 min read

The article explains common database performance bottlenecks such as I/O and CPU limits, and details horizontal and vertical sharding techniques—including database and table partitioning—along with tools, implementation steps, common issues, scaling strategies, and practical examples for improving scalability and reliability.
Horizontal PartitioningShardingVertical Partitioning
0 likes · 10 min read


ITPUBMay 28, 2018 · Databases
This article explains why and how relational databases should be sharded, covering vertical and horizontal partitioning techniques, common pitfalls such as distributed transactions and join queries, and practical guidelines for deciding when to split data and which tools to use.
Horizontal PartitioningShardingVertical Partitioning
0 likes · 22 min read

This article examines why large‑scale MySQL deployments encounter CPU, I/O and memory bottlenecks, compares vertical and horizontal data‑sharding strategies, evaluates open‑source middleware ShardingJdbc versus MyCat, and provides a detailed Spring Boot integration design with routing rules and practical use‑case examples.
Horizontal PartitioningMySQLShardingJDBC
0 likes · 16 min read

This article explains the fundamentals of database sharding, including horizontal partitioning, routing, load balancing, clustering, and read/write separation, and discusses practical strategies such as range, hash, and mapping partitions to improve scalability, availability, and performance for high‑traffic web applications.
Horizontal Partitioningdatabase shardingload balancing
0 likes · 17 min read

Facing a 200 GB order table that strained performance during flash‑sale spikes, Meituan first vertically split the schema, then horizontally sharded orders by user and merchant IDs using a 32 × 32 hash scheme with embedded timestamp‑based IDs, enabling scalable clusters, flexible migration stages, and simplified queries while preserving transaction integrity.
Horizontal PartitioningVertical Partitioningdatabase sharding
0 likes · 11 min read

This article explains the principles, architecture, and performance of Sharding-JDBC, covering sharding scenarios, rule configuration, JDBC rewriting, SQL parsing and routing, result merging, and future roadmap, while comparing it with other open‑source sharding solutions.
Horizontal PartitioningJDBCSharding-JDBC
0 likes · 16 min read

Learn why massive MySQL tables need partitioning and how techniques like table splitting, merge storage engine, vertical partitioning, and horizontal sharding—combined with master‑slave replication and proxies such as Amoeba—can reduce load, improve query speed, and enhance scalability.
Horizontal PartitioningMySQLTable Partitioning
0 likes · 6 min read


21CTOApr 27, 2016 · Databases
This article explains how a rapidly growing order database exceeding 200 GB can be scaled using vertical and horizontal partitioning, various sharding strategies, custom ID generation, migration phases, and practical considerations for transactions and complex queries.
Horizontal PartitioningVertical Partitioningdata migration
0 likes · 9 min read

The article outlines a comprehensive database sharding solution for a massive order system, describing vertical and horizontal partitioning, various sharding strategies, a custom ID scheme, transaction handling, complex query constraints, and a three‑stage data migration plan to achieve long‑term scalability.
Horizontal PartitioningVertical Partitioningdata migration
0 likes · 10 min read


ITPUBMar 18, 2016 · Databases
This article explains two practical horizontal sharding techniques for large databases—using an MD5 hash of the user UID to distribute rows across 256 tables, and right‑shifting the UID to create scalable table ranges—while discussing their capacity limits and extensibility.
Horizontal PartitioningMD5 hashbit shifting
0 likes · 5 min read


21CTOMar 16, 2016 · Databases
This article explains two practical horizontal sharding techniques for large‑scale projects—MD5‑based hashing and bit‑shifting of user IDs—detailing their PHP implementations, scalability limits, and how to extend table counts as data grows.
Horizontal PartitioningMD5 hashingPHP
0 likes · 5 min read

Horizontal sharding splits a large table into multiple databases using hash‑modulo routing, improving performance and scalability; the article explains the basic algorithm, shows example calculations for a 4‑shard setup, and demonstrates how to expand shards from four to eight.
Hash RoutingHorizontal Partitioningdatabase sharding
0 likes · 2 min read

This article analyzes YouPai.com's evolution from a simple master‑slave setup to horizontal sharding using a mapping table, detailing migration steps, access flow, and challenges such as cross‑database joins, consistency, and ID generation.
Horizontal PartitioningMapping TableMaster-Slave Replication
0 likes · 6 min read
