Tagged articles

17 articles

Page 1 of 1

Nov 28, 2025 · Databases

How to Achieve MySQL Sub‑Second Scaling for 100M‑10B Rows (Interview Scenario)

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.

ShardingSpheredatabase scalingdouble write

0 likes · 42 min read

How to Achieve MySQL Sub‑Second Scaling for 100M‑10B Rows (Interview Scenario)

Mike Chen's Internet Architecture

Oct 19, 2025 · Databases

Mastering Million-Request Database Design: Vertical & Horizontal Sharding Strategies

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.

database shardinghigh concurrencyhorizontal sharding

0 likes · 6 min read

Mastering Million-Request Database Design: Vertical & Horizontal Sharding Strategies

Architect

Sep 18, 2023 · Databases

Database Sharding: Data Partitioning Strategies, Challenges, and Practical Solutions

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.

Distributed TransactionsID generationglobal primary key

0 likes · 24 min read

Database Sharding: Data Partitioning Strategies, Challenges, and Practical Solutions

dbaplus Community

Sep 11, 2023 · Databases

When and How to Shard Databases: A Practical Guide to Splitting Tables and Schemas

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.

database partitioningglobal primary keyhorizontal sharding

0 likes · 24 min read

When and How to Shard Databases: A Practical Guide to Splitting Tables and Schemas

ITPUB

Apr 1, 2023 · Databases

Mastering Database Sharding: When and How to Split Databases and Tables

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 PartitioningScalabilitydatabase sharding

0 likes · 14 min read

Mastering Database Sharding: When and How to Split Databases and Tables

Java Interview Crash Guide

Dec 10, 2021 · Databases

Mastering Database Sharding: When and How to Split Your Data

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 Generationdatabase partitioningdistributed databases

0 likes · 25 min read

Mastering Database Sharding: When and How to Split Your Data

Su San Talks Tech

Oct 27, 2021 · Databases

Mastering Database Sharding: When and How to Split Databases and Tables

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.

Read-Write SeparationScalabilityhorizontal sharding

0 likes · 15 min read

Aikesheng Open Source Community

Oct 13, 2021 · Databases

MySQL Native Horizontal Sharding with MERGE Tables

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.

MERGE TableSQLdatabase partitioning

0 likes · 11 min read

MySQL Native Horizontal Sharding with MERGE Tables

Java Interview Crash Guide

Dec 17, 2020 · Databases

Mastering Data Sharding: When and How to Split Your Database

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.

Distributed Transactionsdatabase partitioningglobal IDs

0 likes · 28 min read

Mastering Data Sharding: When and How to Split Your Database

Senior Brother's Insights

Dec 2, 2020 · Databases

Mastering Data Sharding: When, How, and What to Watch Out For

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.

Distributed TransactionsGlobal ID Generationdatabase partitioning

0 likes · 24 min read

Mastering Data Sharding: When, How, and What to Watch Out For

Senior Brother's Insights

Jan 14, 2020 · Databases

Mastering Database Sharding: When, Why, and How to Split Your Data

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.

Distributed TransactionsGlobal ID Generationdatabase sharding

0 likes · 24 min read

Mastering Database Sharding: When, Why, and How to Split Your Data

Java Backend Technology

May 8, 2018 · Databases

How MyCat Simplifies Database Sharding and Read/Write Routing

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 MiddlewareMaster‑SlaveMycat

0 likes · 11 min read

How MyCat Simplifies Database Sharding and Read/Write Routing

ITFLY8 Architecture Home

Apr 22, 2018 · Databases

Mastering MySQL Sharding: Vertical, Horizontal, and Hybrid Strategies Explained

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.

AmoebaProxydatabase partitioning

0 likes · 22 min read

Mastering MySQL Sharding: Vertical, Horizontal, and Hybrid Strategies Explained

ITFLY8 Architecture Home

Oct 13, 2016 · Databases

How to Scale Order Systems with Horizontal Database Sharding: A Real‑World Case Study

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.

Data MigrationOracledatabase scaling

0 likes · 14 min read

How to Scale Order Systems with Horizontal Database Sharding: A Real‑World Case Study

Qunar Tech Salon

Feb 18, 2016 · Databases

Challenges and Strategies for Database Vertical and Horizontal Sharding

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.

ORMdatabase shardinghorizontal sharding

0 likes · 15 min read

Challenges and Strategies for Database Vertical and Horizontal Sharding

MaGe Linux Operations

Feb 4, 2016 · Databases

Mastering Database Sharding: Vertical & Horizontal Partitioning Strategies

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.

Distributed Transactionscross-node queriesdatabase partitioning

0 likes · 9 min read

Mastering Database Sharding: Vertical & Horizontal Partitioning Strategies

Java High-Performance Architecture

Aug 18, 2015 · Databases

Vertical vs Horizontal Database Sharding: Benefits, Drawbacks, and When to Use Each

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.

Scalabilitydatabase shardinghorizontal sharding

0 likes · 3 min read

Vertical vs Horizontal Database Sharding: Benefits, Drawbacks, and When to Use Each