hotspot mitigation — 6 Technical Articles

Jun 21, 2021 · Databases

Mastering TiDB: Essential Naming, Design, and SQL Best Practices

This comprehensive guide provides TiDB developers and administrators with standardized naming conventions, object‑design principles, data‑model considerations, SQL development rules, transaction limits, implicit type‑conversion pitfalls, result‑set stability tips, index strategies, auto‑increment handling, timeout settings, JDBC configuration, hotspot mitigation, pagination techniques, and unique ID generation methods.

SQL Best PracticesTiDBTransaction Limits

0 likes · 53 min read

Mastering TiDB: Essential Naming, Design, and SQL Best Practices

Programmer DD

Mar 30, 2021 · Databases

Combining Horizontal and Vertical Sharding to Eliminate Hotspots Without Data Migration

This article explains vertical and horizontal database partitioning, compares hash‑modulo and range sharding schemes, and proposes a hybrid group‑based design that balances uniform data distribution with painless scaling, eliminating hotspots while avoiding costly data migrations.

Hash RoutingScalabilityVertical Partitioning

0 likes · 12 min read

Combining Horizontal and Vertical Sharding to Eliminate Hotspots Without Data Migration

Java Backend Technology

Mar 11, 2021 · Databases

Combine Hash and Range Sharding to Prevent Hotspots Without Data Migration

This article explains how to split large-scale database tables using vertical and horizontal partitioning, compares hash-modulo and range-based sharding, and proposes a hybrid approach that leverages both methods to balance data distribution, avoid hotspot issues, and eliminate the need for costly data migrations during scaling.

Hash ShardingRange Shardingdata migration

0 likes · 13 min read

Combine Hash and Range Sharding to Prevent Hotspots Without Data Migration

dbaplus Community

Jun 9, 2019 · Databases

Combining Hash and Range Sharding to Avoid Hotspots Without Data Migration

This article explains vertical and horizontal database sharding, compares hash-modulo and range-based partitioning, and proposes a hybrid design that balances load, prevents hotspots, and eliminates costly data migrations during scaling.

capacity planningdistributed databaseshash modulo

0 likes · 11 min read

Combining Hash and Range Sharding to Avoid Hotspots Without Data Migration

Java Backend Technology

Apr 23, 2019 · Databases

Avoid Hotspots and Data Migration: Hybrid Hash‑Range Sharding Strategy

This article explains vertical and horizontal database partitioning, compares hash‑modulo and range sharding schemes, and proposes a hybrid approach that balances load, prevents hotspots, and eliminates the need for costly data migrations during scaling.

Scalabilitydatabase partitioninghash modulo

0 likes · 12 min read

Avoid Hotspots and Data Migration: Hybrid Hash‑Range Sharding Strategy

dbaplus Community

Mar 10, 2019 · Operations

How Alibaba’s Table Store Auto‑Solves Hotspot Issues with Real‑Time Load Balancing

This article explains the architecture and mechanisms of Alibaba Cloud's Table Store load‑balancing system, detailing how it collects metrics, detects user‑access and machine hotspots, and automatically applies actions such as partition moves, splits, merges, and isolation to maintain high availability and performance.

Alibaba CloudMonitoringNoSQL

0 likes · 17 min read

How Alibaba’s Table Store Auto‑Solves Hotspot Issues with Real‑Time Load Balancing