Feb 19, 2024 · Databases

Choosing and Generating Sharding Keys for Database Partitioning

This article explains how to select appropriate sharding keys based on business requirements and data access patterns, describes vertical and horizontal partitioning methods, and presents common techniques such as equal‑value, index, and gene methods along with key generation strategies like auto‑increment, UUID, Snowflake algorithm, and open‑source middleware.

Horizontal PartitionVertical Partitiondatabase

0 likes · 10 min read

Choosing and Generating Sharding Keys for Database Partitioning

IT Architects Alliance

Jul 26, 2021 · Databases

How to Diagnose and Fix Database IO/CPU Bottlenecks with Sharding

The article explains how IO and CPU bottlenecks increase active database connections, then details horizontal and vertical sharding techniques, practical tools, step‑by‑step implementation, and common pitfalls to help engineers relieve pressure on database resources.

CPU BottleneckHorizontal PartitionIO Bottleneck

0 likes · 10 min read

How to Diagnose and Fix Database IO/CPU Bottlenecks with Sharding