Tagged articles
Vertical Partitioning
47 articles · Page 1 of 1
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 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 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


ITPUBOct 1, 2023 · Backend Development
This article explains how to design a scalable architecture for classification‑info platforms that handle billions of rows, ten‑thousand attributes, and hundred‑thousand QPS by using vertical partitioning, unified post, category, and search services, along with compressed JSON extensions and external indexing.
Vertical Partitioninglarge-scale datascalable architecture
0 likes · 12 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

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, 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

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 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 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 PartitioningRange ShardingVertical Partitioning
0 likes · 10 min read

The article explains MySQL vertical partitioning techniques—including instance‑level database splitting, schema‑level splitting, and column‑level table splitting—detailing their advantages, drawbacks, and step‑by‑step command‑line procedures with code examples for implementing each method in production environments.
MySQLVertical Partitioningdatabase sharding
0 likes · 12 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 PartitioningVertical Partitioning
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 PartitioningSQL TuningVertical Partitioning
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

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 PartitioningMySQLVertical Partitioning
0 likes · 10 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 PartitioningVertical Partitioningdatabase sharding
0 likes · 10 min read

This article explains MySQL performance bottlenecks, compares IO and CPU limits, introduces horizontal and vertical sharding and partitioning concepts, presents practical scenarios, outlines common tools such as Sharding‑Sphere, TDDL and Mycat, and provides step‑by‑step guidance for implementation, troubleshooting and scaling.
Horizontal ScalingMySQLSharding
0 likes · 8 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 PartitioningVertical Partitioningdatabase sharding
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 PartitioningShardingVertical Partitioning
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 why relational databases become bottlenecks at large scale, introduces vertical and horizontal sharding techniques, discusses the challenges of distributed transactions, cross‑shard queries, pagination, and global primary‑key generation, and provides practical guidelines and middleware options for implementing sharding in production systems.
Horizontal ScalingMySQLVertical Partitioning
0 likes · 23 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

The article explains how MySQL multi‑source replication can be employed to back up, horizontally or vertically partition, and merge data from several servers into a single target database, illustrating three typical scenarios and providing example SQL for data consolidation.
Multi-Source ReplicationMySQLVertical Partitioning
0 likes · 5 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 PartitioningVertical Partitioningdatabase sharding
0 likes · 9 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

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

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

This article details Dazhong Dianping's practical approach to sharding its massive order database, covering vertical and horizontal partitioning strategies, specific sharding algorithms, unique ID design, data migration phases, and lessons learned for long‑term scalability.
Horizontal ScalingShardingUnique ID
0 likes · 12 min read

The article explains that 503 errors under high concurrency are usually caused by database bottlenecks and outlines a systematic approach—including read‑write separation, caching with memcached, consistent hashing, vertical partitioning, and horizontal sharding—to improve website scalability and reliability.
503 errorCachingMemcached
0 likes · 11 min read
