Mastering Database Sharding: Solving Read Amplification and Partition Strategies

This article explains database sharding concepts, compares vertical and horizontal partitioning, details ID‑range and modulo sharding methods, discusses the read‑amplification issue caused by non‑shard queries, and presents solutions such as auxiliary index tables, Elasticsearch integration, and TiDB as alternatives.

TiDBmysqlread amplification

0 likes · 13 min read

Mastering Database Sharding: Solving Read Amplification and Partition Strategies

Su San Talks Tech

Mar 14, 2023 · Databases

How to Solve Read‑Amplification in MySQL Sharding: Strategies & Tips

This article explains the concepts of database sharding, compares vertical and horizontal partitioning, discusses ID‑range and modulo sharding methods, analyzes the read‑amplification problem caused by non‑sharding keys, and presents practical solutions such as auxiliary index tables, Elasticsearch integration, and TiDB adoption.

ElasticsearchTiDBdatabase scaling

0 likes · 14 min read

How to Solve Read‑Amplification in MySQL Sharding: Strategies & Tips

dbaplus Community

Aug 5, 2020 · Databases

How JIMKV Unifies Cache and Storage to Power High‑Performance Distributed Databases

The article details JD Retail's JIMKV distributed database, explaining its unified cache‑storage architecture, fault‑detection and elastic‑scaling mechanisms, hot‑cold data tiering, read/write amplification mitigation, real‑world product‑detail use case, and future plans for intelligent operations and OLAP support.

KV Storecache storage integrationdistributed database

0 likes · 18 min read

How JIMKV Unifies Cache and Storage to Power High‑Performance Distributed Databases