Comprehensive Guide to Database Sharding: Vertical & Horizontal Partitioning, Global ID Generation, and Distributed Transaction Challenges

This article explains the concepts, methods, advantages, and drawbacks of database sharding, covering vertical and horizontal partitioning, sharding rules, global primary key generation, distributed transaction issues, cross‑node queries, pagination, data migration, and practical case studies, with code examples and diagrams.

Distributed TransactionsGlobal ID Generationdatabase partitioning

0 likes · 24 min read

Comprehensive Guide to Database Sharding: Vertical & Horizontal Partitioning, Global ID Generation, and Distributed Transaction Challenges

Java Interview Crash Guide

Dec 10, 2021 · Databases

Mastering Database Sharding: When and How to Split Your Data

This article explains the concepts, types, advantages, and challenges of database sharding—including vertical and horizontal partitioning—covers when to consider splitting, practical strategies for handling transactions, joins, pagination, global IDs, and lists popular middleware solutions for implementing sharding in production.

Global ID Generationdatabase partitioningdistributed databases

0 likes · 25 min read

Mastering Database Sharding: When and How to Split Your Data

Top Architect

Jun 22, 2021 · Databases

Database Sharding: Strategies, Bottlenecks, and Best Practices

This article explains the performance bottlenecks of relational databases, introduces sharding concepts such as horizontal, vertical, and table partitioning, discusses associated challenges like distributed transactions and global primary keys, and provides practical solutions and tool recommendations for implementing effective database partitioning.

Distributed TransactionsGlobal ID GenerationPerformance Optimization

0 likes · 18 min read

Database Sharding: Strategies, Bottlenecks, and Best Practices

Senior Brother's Insights

Dec 2, 2020 · Databases

Mastering Data Sharding: When, How, and What to Watch Out For

This comprehensive guide explains why and when to split relational databases, details vertical and horizontal sharding techniques, discusses associated challenges such as distributed transactions, cross‑node joins, pagination, global primary keys, and offers practical solutions and middleware options.

Distributed TransactionsGlobal ID Generationdatabase partitioning

0 likes · 24 min read

Mastering Data Sharding: When, How, and What to Watch Out For

Senior Brother's Insights

Jan 14, 2020 · Databases

Mastering Database Sharding: When, Why, and How to Split Your Data

This comprehensive guide explains the motivations, methods, and trade‑offs of database sharding—including vertical and horizontal partitioning, sharding rules, handling cross‑node joins, distributed transactions, global primary key generation, and practical migration strategies—so you can scale relational databases effectively.

Distributed TransactionsGlobal ID Generationdatabase sharding

0 likes · 24 min read

Mastering Database Sharding: When, Why, and How to Split Your Data

Manbang Technology Team

Sep 28, 2018 · Backend Development

Global Unique Ordered ID Generation in Distributed Systems

This article presents a high-availability global unique ordered ID generation solution, Cantor, which addresses the limitations of UUIDs and auto-increment IDs in distributed systems by combining time-based and node-specific sequences for scalability and performance.

CantorDistributed SystemsGlobal ID Generation

0 likes · 11 min read

Global Unique Ordered ID Generation in Distributed Systems