DatabaseScaling

Java Architect Essentials

Dec 31, 2020 · Databases

MySQL Single Table Optimization, Sharding, Partitioning, and Scaling Techniques

When a MySQL table grows large, performance degrades sharply, so this guide explains single‑table tuning, proper field choices, index strategies, query best practices, engine differences, system parameters, hardware upgrades, read‑write splitting, caching layers, table partitioning, vertical and horizontal sharding, and how to choose suitable sharding solutions.

DatabaseScalingIndexingMySQL

0 likes · 25 min read

MySQL Single Table Optimization, Sharding, Partitioning, and Scaling Techniques

Architecture Digest

Dec 17, 2019 · Databases

Scaling Dada's Delivery Platform: From Simple Architecture to Read/Write Separation, Vertical and Horizontal Sharding

This article chronicles Dada's rapid growth from a single‑database backend to a multi‑layer architecture that employs MySQL read/write separation, vertical partitioning, and horizontal sharding with a custom ID generator to sustain millions of daily orders while maintaining performance and stability.

BackendArchitectureDatabaseScalingMySQL

0 likes · 14 min read

Scaling Dada's Delivery Platform: From Simple Architecture to Read/Write Separation, Vertical and Horizontal Sharding