BestHub
Sign in
Tagged articles
5 articles
Page 1 of 1
Aikesheng Open Source Community
Aikesheng Open Source Community
May 11, 2022 · Databases

Using Hash Partitioning in MySQL: Scenarios, Queries, and Optimizations

This article explains MySQL hash partition tables, illustrating their suitable use cases such as equality queries on IDs or dates, demonstrating creation, data loading, and query plans, and comparing standard hash partitions with linear hash partitions to highlight performance and data distribution considerations.

Database Optimizationhash partitionmysql
0 likes · 13 min read
Using Hash Partitioning in MySQL: Scenarios, Queries, and Optimizations
macrozheng
macrozheng
May 11, 2022 · Databases

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

This article explains the concepts of database and table sharding, why they are needed, various vertical and horizontal splitting strategies, range and hash partitioning methods, their advantages and drawbacks, timing considerations, common challenges such as transactions and distributed IDs, and introduces popular sharding middleware.

Distributed TransactionsVertical Partitioningdatabase sharding
0 likes · 12 min read
Mastering Database Sharding: When and How to Split Databases and Tables
dbaplus Community
dbaplus Community
Sep 17, 2018 · Databases

Mastering Data Sharding: Hash, Consistent Hash, and Range Partition Strategies Explained

This article explains the core concepts of data sharding in distributed storage systems, compares hash, consistent‑hash, and range‑based partitioning, discusses how to choose sharding keys, examines metadata server designs and high‑availability solutions, and introduces lease‑based cache consistency mechanisms.

consistent hashinghash partitionlease mechanism
0 likes · 28 min read
Mastering Data Sharding: Hash, Consistent Hash, and Range Partition Strategies Explained