Vertical Partitioning in MySQL: Database, Schema, and Table Level Splitting

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.

Vertical Partitioningdatabase shardingmysql

0 likes · 12 min read

Vertical Partitioning in MySQL: Database, Schema, and Table Level Splitting

Full-Stack Internet Architecture

Jun 11, 2021 · Databases

When Do Database Tables Reach Bottlenecks and How to Split Them: Strategies, Cases, and Best Practices

This article explains how massive e‑commerce platforms identify the point at which database tables become performance bottlenecks, discusses vertical and horizontal sharding strategies, evaluates hash, range and consistent‑hash partitioning, and presents real‑world case studies from Suning, JD, Meituan, Ant Financial and Taobao.

Case Studiestable splitting

0 likes · 16 min read

When Do Database Tables Reach Bottlenecks and How to Split Them: Strategies, Cases, and Best Practices