BestHub
Sign in
Tagged articles

Global ID Generation

7 articles · Page 1 of 1
Xiaolin Talks Programming
Xiaolin Talks Programming
Aug 7, 2026 · Backend Development

Spring Boot ShardingSphere Integration: Sharding Strategies, Global IDs & Cross-Shard Query Pitfalls

A production-ready guide to integrating Spring Boot 3.x with ShardingSphere 5.5.0, covering sharding algorithms (hash, range, time-based), global ID generation (Snowflake, segment mode), read-write splitting consistency traps, cross-shard query optimization, connection pool tuning, and a deployment checklist.

Cross-Shard QueriesGlobal ID GenerationRead-Write Splitting
0 likes · 18 min read
Spring Boot ShardingSphere Integration: Sharding Strategies, Global IDs & Cross-Shard Query Pitfalls
Top Architect
Top Architect
Mar 16, 2022 · Databases

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.

Global ID Generationdatabase partitioningdistributed transactions
0 likes · 24 min read
Comprehensive Guide to Database Sharding: Vertical & Horizontal Partitioning, Global ID Generation, and Distributed Transaction Challenges
Java Interview Crash Guide
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 GenerationHorizontal ShardingVertical Sharding
0 likes · 25 min read
Mastering Database Sharding: When and How to Split Your Data
Top Architect
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.

Global ID GenerationHorizontal PartitioningPerformance Optimization
0 likes · 18 min read
Database Sharding: Strategies, Bottlenecks, and Best Practices
Senior Brother's Insights
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.

Global ID GenerationHorizontal ShardingVertical Sharding
0 likes · 24 min read
Mastering Data Sharding: When, How, and What to Watch Out For
Senior Brother's Insights
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.

Global ID GenerationHorizontal ShardingMySQL
0 likes · 24 min read
Mastering Database Sharding: When, Why, and How to Split Your Data
Manbang Technology Team
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.

CantorGlobal ID Generationdistributed systems
0 likes · 11 min read
Global Unique Ordered ID Generation in Distributed Systems