Tagged articles
Horizontal Sharding
19 articles · Page 1 of 1
The article explains why high‑traffic MySQL deployments hit performance limits, introduces the concepts of vertical and horizontal sharding, and provides a step‑by‑step guide—including necessity assessment, shard key selection, schema design, middleware integration, and data migration—using an e‑commerce order system as a concrete example.
Horizontal ShardingMySQLSharding
0 likes · 5 min read

The article explains vertical and horizontal sharding concepts, compares their advantages and drawbacks, evaluates popular sharding middleware such as ShardingSphere, details distributed ID generation with Snowflake, offers cross‑database query solutions, and provides practical guidance on when and how to apply sharding in MySQL.
Cross-Database QueriesHorizontal ShardingMySQL
0 likes · 13 min read

The article analyzes a JD interview question on scaling a MySQL order table from 100 million to billions of rows, detailing four practical expansion strategies—stop‑service migration, double‑write migration, ShardingSphere middleware, and dual‑VIP routing—each with step‑by‑step procedures, code samples, risk assessments, and validation methods to enable near‑instant capacity growth without service interruption.
Horizontal ShardingMySQLShardingSphere
0 likes · 42 min read

This article explains how to handle hundred‑thousand to million‑level QPS by using vertical and horizontal database sharding, detailing implementation steps, sharding algorithms, and the trade‑offs such as transaction complexity and distributed ID generation.
Horizontal ShardingVertical Shardingdatabase sharding
0 likes · 6 min read

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.
Horizontal ShardingVertical Shardingdistributed transactions
0 likes · 24 min read

This article explains why relational databases hit performance bottlenecks at large scale, introduces vertical and horizontal sharding techniques, compares their pros and cons, discusses common challenges such as distributed transactions, joins, pagination and global key generation, and offers practical solutions and middleware options.
Horizontal ShardingShardingVertical Sharding
0 likes · 24 min read


ITPUBApr 1, 2023 · Databases
Learn why large-scale internet applications need database sharding, understand the evolution from single databases to split databases and tables, and follow practical steps for assessing, planning, and implementing horizontal and vertical sharding, including sizing calculations, key selection, and query challenges.
Data PartitioningHorizontal ShardingVertical Sharding
0 likes · 14 min read

This article explains the concepts, types, advantages, and challenges of database sharding—including vertical and horizontal partitioning—covers when to consider splitting, practical strategies for handling transactions, joins, pagination, global IDs, and lists popular middleware solutions for implementing sharding in production.
Global ID GenerationHorizontal ShardingVertical Sharding
0 likes · 25 min read

This article explains why and how to split databases and tables in high‑concurrency systems, covering vertical (business‑domain) and horizontal (data‑volume) sharding, practical architectures, read‑write separation, routing algorithms, and real‑world case studies from gaming, membership points, and restaurant ordering platforms.
Horizontal ShardingRead-Write SeparationVertical Sharding
0 likes · 15 min read

This article explains MySQL's native horizontal sharding using MERGE tables, covering the concepts of horizontal versus vertical splitting, table‑level sharding and partitioning, practical examples, advantages, limitations, and suitable use cases for MERGE tables.
Horizontal ShardingMERGE TableMySQL
0 likes · 11 min read

This article explains the concepts, types, advantages, and drawbacks of vertical and horizontal database sharding, discusses the challenges such as distributed transactions, cross‑node joins, pagination, global primary‑key generation, migration, and provides practical guidelines and case studies for deciding when and how to apply sharding.
Horizontal ShardingShardingVertical Sharding
0 likes · 28 min read

This comprehensive guide explains why and when to split relational databases, details vertical and horizontal sharding techniques, discusses associated challenges such as distributed transactions, cross‑node joins, pagination, global primary keys, and offers practical solutions and middleware options.
Global ID GenerationHorizontal ShardingSharding
0 likes · 24 min read

This comprehensive guide explains the motivations, methods, and trade‑offs of database sharding—including vertical and horizontal partitioning, sharding rules, handling cross‑node joins, distributed transactions, global primary key generation, and practical migration strategies—so you can scale relational databases effectively.
Global ID GenerationHorizontal ShardingMySQL
0 likes · 24 min read

This article explains MyCat's role as a database middleware, tracing the evolution from single‑database setups through distributed deployment, caching, master‑slave, vertical and horizontal sharding, and shows how MyCat automates data‑source and shard selection to reduce code complexity.
Database MiddlewareHorizontal ShardingMaster‑Slave
0 likes · 11 min read

This article explores MySQL sharding fundamentals, detailing vertical, horizontal, and combined partitioning methods, their advantages and drawbacks, and surveys various open‑source implementations such as MySQL Proxy, HSCALE, Amoeba, HiveDB, and PL/Proxy, while offering practical guidance on configuration, transaction handling, and common pitfalls.
AmoebaHorizontal ShardingMySQL
0 likes · 22 min read

This article presents a comprehensive, practice‑driven analysis of horizontal database sharding for a high‑traffic e‑commerce order system, covering sharding dimensions, strategies, quantity planning, transparent routing, pagination challenges, lookup mapping, overall architecture, deployment steps, and the measurable performance and cost benefits achieved.
Horizontal ShardingMySQLOracle
0 likes · 14 min read

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.
Horizontal ShardingORMVertical Sharding
0 likes · 15 min read

This article explains the core concepts of database sharding, detailing vertical and horizontal partitioning methods, strategies for combining them, handling shared data, and addressing challenges such as distributed transactions, cross‑node joins, and aggregation queries, with practical insights for scalable system design.
Horizontal ShardingShardingVertical Sharding
0 likes · 9 min read

Vertical sharding splits large tables across multiple servers by whole tables, offering simple partitioning but limited scalability, while horizontal sharding distributes rows of high‑traffic tables based on key rules, improving performance and scalability yet introducing complex partition logic and maintenance challenges.
Horizontal ShardingVertical Shardingdatabase sharding
0 likes · 3 min read
