BestHub
Sign in
Tagged articles
80 articles
Page 1 of 1
James' Growth Diary
James' Growth Diary
May 6, 2026 · Backend Development

How Claude Code’s Task System Uses 7 TaskTypes and 9‑Char IDs for Clear Debugging

The article dissects Claude Code’s task architecture, explaining the 7‑type TaskType union, the 9‑character prefixed ID scheme, the TaskStatus state machine, guard functions, incremental output handling, a minimal kill‑only interface, and a stall‑watchdog that together make concurrent Agent debugging both readable and secure.

ID generationTaskTypebackend design
0 likes · 18 min read
How Claude Code’s Task System Uses 7 TaskTypes and 9‑Char IDs for Clear Debugging
Sohu Tech Products
Sohu Tech Products
Apr 22, 2026 · Databases

How to Resolve ID Conflicts After Sharding? 5 Proven Solutions

When sharding databases, independent auto‑increment IDs can collide, causing data integrity issues; this article explains why the conflict occurs and walks through five practical solutions—including UUID, custom auto‑increment steps, segment mode, Snowflake, and Meituan Leaf—detailing their trade‑offs, performance, and implementation steps.

ID generationLeafdatabase
0 likes · 15 min read
How to Resolve ID Conflicts After Sharding? 5 Proven Solutions
Java Companion
Java Companion
Apr 17, 2026 · Backend Development

Resolving ID Conflicts After Sharding: 5 Practical Solutions

When sharding databases, independent auto‑increment IDs can collide; this article explains why the conflict occurs and evaluates five concrete solutions—UUID, MySQL auto‑increment step, segment allocation, Snowflake algorithm, and Meituan Leaf—detailing their mechanisms, trade‑offs, performance, and suitability.

ID generationMeituan LeafSegment
0 likes · 14 min read
Resolving ID Conflicts After Sharding: 5 Practical Solutions
Selected Java Interview Questions
Selected Java Interview Questions
Feb 26, 2026 · Backend Development

Why Your Snowflake‑Like ID Generator May Duplicate IDs Under High Concurrency

The article analyzes a custom TraceIdGenerator that uses a simple AtomicInteger counter and IP‑based prefix, identifying how its reset logic and CAS competition can cause duplicate IDs in high‑concurrency scenarios, and proposes timestamp checks, larger ranges, retry mechanisms, and true Snowflake implementation as solutions.

AtomicIntegerID generationJava
0 likes · 11 min read
Why Your Snowflake‑Like ID Generator May Duplicate IDs Under High Concurrency
Architect's Guide
Architect's Guide
Jan 24, 2026 · Fundamentals

Why Our Custom Snowflake ID Generator Failed and How to Fix It

A recent production incident revealed duplicate order IDs caused by a flawed custom Snowflake algorithm; this article reviews the standard Snowflake structure, dissects the custom implementation’s critical mistakes—short timestamp, IP‑based business ID, zeroed worker and data‑center IDs—and offers best‑practice recommendations, including using mature libraries and proper worker‑ID strategies.

Distributed SystemsID generationJava
0 likes · 7 min read
Why Our Custom Snowflake ID Generator Failed and How to Fix It
Java Backend Technology
Java Backend Technology
Jan 15, 2026 · Backend Development

Why Our Custom Snowflake ID Generator Failed and How to Build a Reliable One

A recent production incident revealed duplicate order IDs caused by a flawed custom Snowflake implementation; the article reviews the standard Snowflake structure, pinpoints design mistakes such as a 31‑bit timestamp, IP‑based business IDs, and zeroed worker IDs, and offers concrete recommendations and proven library alternatives for safe distributed ID generation.

ID generationJavasnowflake
0 likes · 7 min read
Why Our Custom Snowflake ID Generator Failed and How to Build a Reliable One
Top Architect
Top Architect
Jan 13, 2026 · Backend Development

Why Our Custom Snowflake ID Collided and How to Build a Reliable Generator

A severe production incident caused duplicate order IDs due to a flawed custom Snowflake implementation, prompting a detailed review of the standard algorithm, identification of critical design mistakes, and a set of practical recommendations for safe, scalable ID generation in distributed back‑end systems.

ID generationJavasnowflake
0 likes · 8 min read
Why Our Custom Snowflake ID Collided and How to Build a Reliable Generator
dbaplus Community
dbaplus Community
Jan 7, 2026 · Backend Development

Why Our Custom Snowflake ID Collided and How to Build a Reliable Generator

A recent production incident caused duplicate order IDs due to a flawed custom Snowflake implementation, prompting a deep dive into the standard algorithm, analysis of the mistakes, and a set of best‑practice recommendations for designing robust distributed ID generators.

Design PatternsDistributed SystemsID generation
0 likes · 7 min read
Why Our Custom Snowflake ID Collided and How to Build a Reliable Generator
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Dec 25, 2025 · Backend Development

Comparing Four Distributed ID Generation Strategies: Auto‑Increment, UUID, Snowflake, and Coordination Services

This article compares four major distributed ID generation approaches—database auto‑increment, UUID, Snowflake, and coordination‑service based allocation—detailing their mechanisms, advantages, drawbacks, and suitable scenarios for backend system design.

BackendID generationdatabase auto-increment
0 likes · 5 min read
Comparing Four Distributed ID Generation Strategies: Auto‑Increment, UUID, Snowflake, and Coordination Services
Architect
Architect
Dec 20, 2025 · Backend Development

Why Our Custom Snowflake ID Generator Failed and How to Build a Reliable One

A recent production outage caused by duplicate order IDs revealed critical flaws in a home‑grown Snowflake‑style ID generator, prompting a detailed review of the standard algorithm, an analysis of the custom implementation’s mistakes, and a set of best‑practice recommendations for safe ID generation in distributed systems.

BackendID generationsnowflake
0 likes · 8 min read
Why Our Custom Snowflake ID Generator Failed and How to Build a Reliable One
Java Architect Handbook
Java Architect Handbook
Dec 14, 2025 · Backend Development

Why Our Custom Snowflake ID Failed and How to Build a Reliable One

A recent production incident revealed that a self‑developed Snowflake‑style ID generator caused duplicate order numbers due to a truncated timestamp, unsafe IP‑based business IDs, and unconfigured worker and data‑center IDs, prompting a detailed analysis of the standard algorithm, the flaws in the custom design, and best‑practice recommendations for robust ID generation.

BackendDistributed SystemsID generation
0 likes · 9 min read
Why Our Custom Snowflake ID Failed and How to Build a Reliable One
Architect's Tech Stack
Architect's Tech Stack
Dec 14, 2025 · Backend Development

Why Our Custom Snowflake ID Generator Failed and How to Build a Reliable One

A recent production incident revealed duplicate order IDs caused by a home‑grown Snowflake implementation that misused timestamps, IP‑based business IDs, and unconfigured worker/data‑center IDs, leading to collisions; the article analyzes the flaws, shares lessons, and recommends proven libraries and proper ID‑generation strategies.

BackendID generationJava
0 likes · 7 min read
Why Our Custom Snowflake ID Generator Failed and How to Build a Reliable One
Architect
Architect
Oct 19, 2025 · Databases

Generating Short Sequential Numeric IDs in MySQL Without Snowflake Overhead

This article explores how to replace long UUIDs with short, sequential numeric IDs by evaluating Snowflake, MySQL auto‑increment tables, REPLACE INTO deadlock issues, batch allocation strategies, and a final free‑ID table design that balances performance, simplicity, and low ID waste.

Database designID generationauto_increment
0 likes · 14 min read
Generating Short Sequential Numeric IDs in MySQL Without Snowflake Overhead
ITPUB
ITPUB
Aug 18, 2025 · Databases

Generating Ultra‑Short Numeric IDs in MySQL: From Snowflake to Custom Schemes

This article explores how to replace long Snowflake IDs with concise numeric account IDs by leveraging MySQL auto‑increment tables, addressing deadlock pitfalls of REPLACE INTO, and evaluating alternative batch‑allocation and sharding strategies before presenting a final free‑ID table design.

Database designID generationauto_increment
0 likes · 15 min read
Generating Ultra‑Short Numeric IDs in MySQL: From Snowflake to Custom Schemes
Sohu Smart Platform Tech Team
Sohu Smart Platform Tech Team
Aug 14, 2025 · Backend Development

How to Build a Strictly Incremental Distributed ID System with Redis, MySQL, and Nacos

This article examines the limitations of traditional database‑based ID generation, compares common distributed ID solutions such as UUID, Snowflake, Baidu uid‑generator and Meituan Leaf, and presents a custom strictly incremental ID scheme that combines database segment allocation, Redis caching, and Nacos‑controlled mode switching.

ID generationNacosmysql
0 likes · 11 min read
How to Build a Strictly Incremental Distributed ID System with Redis, MySQL, and Nacos
Sohu Tech Products
Sohu Tech Products
Aug 13, 2025 · Backend Development

How to Build a Strictly Incremental Distributed ID System with Redis, MySQL, and Nacos

This article examines the challenges of distributed ID generation, compares common solutions like UUID and Snowflake, and presents a custom approach that combines MySQL segment tables, Redis caching, and Nacos switches to achieve high‑performance, strictly incremental IDs with automatic failover.

Backend DevelopmentDistributed SystemsID generation
0 likes · 11 min read
How to Build a Strictly Incremental Distributed ID System with Redis, MySQL, and Nacos
Selected Java Interview Questions
Selected Java Interview Questions
Jul 1, 2025 · Backend Development

Why Our Custom Snowflake ID Failed and How to Build Reliable IDs

A recent production incident revealed duplicate order IDs caused by a flawed custom Snowflake generator, prompting a deep dive into the standard algorithm, the mistakes in the bespoke version, and practical recommendations for using proven implementations and proper machine‑ID configuration.

Backend DevelopmentDistributed SystemsID generation
0 likes · 7 min read
Why Our Custom Snowflake ID Failed and How to Build Reliable IDs
dbaplus Community
dbaplus Community
May 25, 2025 · Databases

How to Generate Short, Sequential Numeric IDs Without Snowflake Overhead

To replace long UUIDs with short, sequential numeric account IDs, the article explores the limitations of Snowflake’s 64‑bit IDs, evaluates MySQL auto‑increment and REPLACE INTO approaches, identifies deadlock issues, and ultimately proposes a segmented free‑ID table with batch allocation to achieve compact, ordered IDs.

Distributed SystemsID generationauto_increment
0 likes · 14 min read
How to Generate Short, Sequential Numeric IDs Without Snowflake Overhead
Architecture Digest
Architecture Digest
May 20, 2025 · Backend Development

Designing Short Numeric Account IDs Using MySQL Auto‑Increment and Segment Allocation

This article explores the problem of generating short, sequential numeric account IDs, evaluates the classic Snowflake algorithm, proposes a MySQL auto‑increment based solution with a dedicated ID‑generation table, analyzes deadlock issues, and finally presents a segment‑based ID allocation scheme that reduces waste and supports scaling.

ID generationauto-incrementmysql
0 likes · 12 min read
Designing Short Numeric Account IDs Using MySQL Auto‑Increment and Segment Allocation
Test Development Learning Exchange
Test Development Learning Exchange
Jan 13, 2025 · Backend Development

Building a Python Flask Service for Automatic ID Generation

This guide demonstrates how to build a Python Flask-based RESTful service that generates various types of unique identifiers—including UUIDs, timestamps, Redis counters, Snowflake IDs, and random strings—while covering installation, code implementation, API endpoints, error handling, rate limiting, and extensibility considerations.

APIFlaskID generation
0 likes · 7 min read
Building a Python Flask Service for Automatic ID Generation
Su San Talks Tech
Su San Talks Tech
Jan 7, 2025 · Databases

7 Common Pitfalls of Database Sharding and How to Solve Them

This article examines seven typical challenges that arise after implementing database sharding—such as global ID conflicts, cross‑shard queries, distributed transactions, shard‑key design, data migration, pagination, and operational overhead—and provides practical solutions and code examples to address each issue.

Distributed SystemsID generationdatabase scaling
0 likes · 12 min read
7 Common Pitfalls of Database Sharding and How to Solve Them
Zhuanzhuan Tech
Zhuanzhuan Tech
Nov 28, 2024 · Backend Development

Boosting MyBatis-Plus Batch Insert Performance by 2000% with rewriteBatchedStatements and Pre‑Generated IDs

This article explains how to dramatically improve MyBatis-Plus batch insertion speed—up to 2000%—by enabling rewriteBatchedStatements, pre‑generating primary keys to handle foreign‑key relationships, applying proper JDBC batch settings, and using asynchronous multithreaded insertion with optimized connection‑pool and executor configurations.

Batch InsertID generationJDBC
0 likes · 21 min read
Boosting MyBatis-Plus Batch Insert Performance by 2000% with rewriteBatchedStatements and Pre‑Generated IDs
Sohu Tech Products
Sohu Tech Products
Oct 30, 2024 · Backend Development

Redis Distributed ID Generator with SpringBoot 3.0

The article presents a Redis‑based distributed ID generator for Spring Boot 3.0 that uses an atomic INCR on a Redis string to produce compact, monotonic, globally unique numeric identifiers, synchronizes the maximum value with MySQL on startup, and offers high performance, availability, and low storage overhead.

ID generationSpringBootdistributed-id
0 likes · 9 min read
Redis Distributed ID Generator with SpringBoot 3.0
Su San Talks Tech
Su San Talks Tech
Aug 5, 2024 · Fundamentals

Mastering Distributed Systems: Common Pitfalls and How to Avoid Them

This article explains the core concepts of distributed systems—including the CAP theorem, BASE theory, message‑queue challenges, Redis sentinel issues, sharding strategies, unique ID generation, and distributed transaction patterns—while offering practical guidance to prevent common pitfalls and improve reliability.

CAP theoremDistributed SystemsID generation
0 likes · 27 min read
Mastering Distributed Systems: Common Pitfalls and How to Avoid Them
Architect
Architect
Sep 18, 2023 · Databases

Database Sharding: Data Partitioning Strategies, Challenges, and Practical Solutions

The article explains why relational databases become performance bottlenecks at large scales, introduces vertical and horizontal sharding techniques, discusses their advantages and drawbacks, and provides detailed guidance on handling distributed transactions, joins, pagination, global primary keys, and ID generation strategies.

Distributed TransactionsID generationglobal primary key
0 likes · 24 min read
Database Sharding: Data Partitioning Strategies, Challenges, and Practical Solutions
vivo Internet Technology
vivo Internet Technology
Jun 28, 2023 · Backend Development

Design and Implementation of Vivo's LuBan Distributed ID Service

The article explains distributed ID concepts and business scenarios, compares nine common generation schemes, and details Vivo’s LuBan service architecture—including three built‑in ID formats, custom SPI extensions, Spring‑Boot SDK usage, performance optimizations, and large‑scale deployment metrics—offering practical guidance for building high‑throughput, globally unique ID systems.

Backend ArchitectureID generationJava
0 likes · 16 min read
Design and Implementation of Vivo's LuBan Distributed ID Service
ITPUB
ITPUB
Jun 4, 2023 · Databases

When to Shard Databases and How to Do It Effectively

This article explains why database sharding is needed when performance bottlenecks appear, outlines the criteria and timing for adopting sharding, and provides detailed step‑by‑step guidance on both database‑level and table‑level partitioning, including common pitfalls and solutions.

ID generationPerformance Optimizationdatabase sharding
0 likes · 13 min read
When to Shard Databases and How to Do It Effectively
macrozheng
macrozheng
Apr 7, 2023 · Backend Development

Designing Scalable Order Systems: Architecture, ID Strategies, and Distributed Transactions

This article explores the comprehensive design of order business systems, covering background considerations, order lifecycle management, technical solutions such as ID generation, parallel and asynchronous processing, timeout handling, distributed transactions, and data strategies like sharding and synchronization.

Backend ArchitectureDistributed TransactionsID generation
0 likes · 12 min read
Designing Scalable Order Systems: Architecture, ID Strategies, and Distributed Transactions
Selected Java Interview Questions
Selected Java Interview Questions
Mar 14, 2023 · Databases

16 Common Redis Use Cases and How to Implement Them

This article outlines sixteen practical Redis usage scenarios—including caching, distributed sessions, locks, ID generation, counters, rate limiting, bitmaps, shopping carts, timelines, message queues, lotteries, likes, tags, filtering, follow relationships, and leaderboards—explaining each concept and providing example code snippets for implementation.

BitmapsID generationdistributed-lock
0 likes · 9 min read
16 Common Redis Use Cases and How to Implement Them
Top Architect
Top Architect
Dec 6, 2022 · Backend Development

Distributed ID Generation: Principles, Requirements, and Common Solutions

The article explains why traditional auto‑increment primary keys are unsuitable for distributed systems, outlines the key requirements for a distributed identifier, and reviews several practical generation schemes—including UUID, database auto‑increment, segment mode, Redis, Snowflake, Baidu UidGenerator, Meituan Leaf, and Didi TinyID—along with their advantages, drawbacks, and sample implementations.

BackendID generationdistributed-id
0 likes · 13 min read
Distributed ID Generation: Principles, Requirements, and Common Solutions
Architect
Architect
Dec 5, 2022 · Backend Development

Distributed ID Generation: Requirements, Schemes, and Implementations

This article explains why distributed systems need special ID generation, outlines the key requirements such as global uniqueness and monotonicity, and compares various solutions including UUID, database auto‑increment, segment mode, Redis, Snowflake, Baidu UidGenerator, Meituan Leaf, and Didi TinyID.

ID generationdistributed-idredis
0 likes · 13 min read
Distributed ID Generation: Requirements, Schemes, and Implementations
Java High-Performance Architecture
Java High-Performance Architecture
Nov 28, 2022 · Backend Development

Mastering Distributed ID Generation: Strategies, Pros, and Code Samples

This article explains why distributed ID generation is essential for modern micro‑service architectures, outlines the key requirements such as global uniqueness and monotonicity, and compares popular solutions like UUID, database auto‑increment, segment mode, Redis, Snowflake, Baidu UidGenerator, Meituan Leaf, and Didi TinyID with practical code examples.

BackendID generationdistributed-id
0 likes · 13 min read
Mastering Distributed ID Generation: Strategies, Pros, and Code Samples
dbaplus Community
dbaplus Community
Nov 18, 2022 · Databases

When and How to Shard Databases: A Complete Guide to Partitioning, Algorithms, and Tools

This article explains why and when to apply database sharding, distinguishes between sharding databases, tables, or both, describes horizontal and vertical splitting, guides key selection and sharding algorithms, covers global ID generation, lists open‑source tools, and discusses the operational challenges introduced by sharding.

ID generationPartitioninghorizontal-splitting
0 likes · 17 min read
When and How to Shard Databases: A Complete Guide to Partitioning, Algorithms, and Tools
Wukong Talks Architecture
Wukong Talks Architecture
Nov 15, 2022 · Backend Development

Investigation of Snowflake ID Generation Failures Caused by Clock Rollback and Mitigation Strategies

This article analyzes a production incident where duplicate IDs were generated by the Snowflake algorithm due to server clock rollback, explains the algorithm's structure and pitfalls, and presents several open‑source solutions such as Meituan Leaf, Baidu UidGenerator, and Redis for reliable distributed ID generation.

Clock rollbackID generationNTP
0 likes · 8 min read
Investigation of Snowflake ID Generation Failures Caused by Clock Rollback and Mitigation Strategies
Top Architect
Top Architect
Nov 3, 2022 · Backend Development

Distributed ID Generation Service: Principles, Features, and Common Implementations

The article explains the need for globally unique IDs in various business scenarios, outlines essential service characteristics such as uniqueness, ordering, high availability, and security, and details common technical implementations including Snowflake, Redis auto‑increment, short‑URL encoding, and custom coupon code schemes.

ID generationcoupon codeshort URL
0 likes · 18 min read
Distributed ID Generation Service: Principles, Features, and Common Implementations
Baidu Geek Talk
Baidu Geek Talk
Oct 20, 2022 · Backend Development

Choosing the Right Distributed ID Generation Strategy for Different Business Scenarios

This article analyzes the diverse business requirements for unique identifiers—such as order numbers, QR‑code payments, coupons, trace IDs, and short URLs—and compares technical implementations like Redis auto‑increment, Snowflake, and custom base‑62 encoding to help engineers select the most suitable distributed ID generation solution.

Backend ArchitectureID generationTrace ID
0 likes · 19 min read
Choosing the Right Distributed ID Generation Strategy for Different Business Scenarios
Su San Talks Tech
Su San Talks Tech
Jul 21, 2022 · Databases

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

This article explains the three aspects of database sharding—database‑only, table‑only, and both—detailing when to apply each, how to choose sharding keys, common algorithms, ID generation strategies, available open‑source tools, and the new challenges introduced by sharding.

ID generationVertical Scalingdatabase partitioning
0 likes · 16 min read
Mastering Database Sharding: When and How to Split Databases and Tables
Programmer DD
Programmer DD
Jul 20, 2022 · Databases

Mastering MySQL Sharding: Strategies, ID Generation, and Seamless Scaling

This article explains why and how to apply database sharding, introduces key terminology, compares global ID generation methods such as auto‑increment, UUID, COMB and Snowflake, outlines sharding algorithms, discusses challenges like distributed transactions, and presents practical expansion and implementation solutions.

ID generationdatabase scalingmysql
0 likes · 12 min read
Mastering MySQL Sharding: Strategies, ID Generation, and Seamless Scaling
Java Backend Technology
Java Backend Technology
Jun 24, 2022 · Fundamentals

Why NanoID Is Faster, Smaller, and Safer Than UUID – A Deep Dive

NanoID, a modern alternative to UUID, offers significantly smaller IDs, up to 60% faster generation, stronger security via crypto APIs, customizable alphabets, and broad language support, making it a compelling choice for developers seeking efficient, compact, and secure unique identifiers across various platforms.

ID generationJavaScriptSecurity
0 likes · 8 min read
Why NanoID Is Faster, Smaller, and Safer Than UUID – A Deep Dive
macrozheng
macrozheng
Jun 24, 2022 · Backend Development

Choosing the Right Distributed ID Generator: UUID, Snowflake, NanoID

This article examines the trade‑offs of common distributed ID generators—UUID, timestamp‑based schemes, Snowflake, and NanoID—highlighting their size, ordering, performance, and security implications to help developers select the most suitable approach for their systems.

Distributed SystemsID generationnanoid
0 likes · 6 min read
Choosing the Right Distributed ID Generator: UUID, Snowflake, NanoID
ELab Team
ELab Team
Jun 13, 2022 · Backend Development

How Short URLs Are Built: From Hashes to Snowflake IDs

Short URLs are essential for many scenarios, and this article explores their components, including domain and path design, and dives into various path generation methods such as hash functions, auto‑increment IDs, distributed Snowflake algorithms, base‑62 encoding, and the trade‑offs between 301 and 302 redirects.

BackendID generationRedirect
0 likes · 8 min read
How Short URLs Are Built: From Hashes to Snowflake IDs
Top Architect
Top Architect
Feb 22, 2022 · Databases

Database Sharding: Concepts, Global ID Strategies, Partitioning Schemes, and Expansion Solutions

This article explains database sharding fundamentals, including terminology, when to adopt sharding, various global ID generation methods such as auto‑increment, UUID, COMB, and Snowflake, different partitioning strategies, challenges like distributed transactions, and practical expansion and migration solutions.

ID generationPartitioningScalability
0 likes · 14 min read
Database Sharding: Concepts, Global ID Strategies, Partitioning Schemes, and Expansion Solutions
Su San Talks Tech
Su San Talks Tech
Dec 13, 2021 · Backend Development

Why Distributed IDs Matter and 9 Efficient Generation Methods

This article explains the need for globally unique, high‑performance, and easy‑to‑integrate distributed IDs, outlines their essential characteristics, and compares nine common generation approaches—including UUID, database auto‑increment, segment mode, Redis, Snowflake, Baidu uid‑generator, Meituan Leaf, and Didi TinyID—detailing each method’s advantages and drawbacks.

ID generationdistributed-idredis
0 likes · 20 min read
Why Distributed IDs Matter and 9 Efficient Generation Methods
IT Architects Alliance
IT Architects Alliance
Nov 9, 2021 · Operations

Why Scale and How: Hardware Expansion, AKF Splitting Principle, Distributed ID Generation, and Elastic Scaling

The article explains the reasons for scaling, outlines hardware and component expansion strategies, introduces the AKF splitting principle for distributed systems, discusses database clustering and distributed ID generation methods such as UUID and Snowflake, and describes elastic scaling challenges and solutions.

Distributed SystemsID generationcapacity planning
0 likes · 14 min read
Why Scale and How: Hardware Expansion, AKF Splitting Principle, Distributed ID Generation, and Elastic Scaling
Architecture Digest
Architecture Digest
Nov 9, 2021 · Operations

Scaling Strategies: Hardware Expansion, AKF Partitioning, and Distributed ID Generation

This article explains why scaling is necessary, outlines hardware and component expansion strategies, introduces the AKF partitioning principle for horizontal and vertical scaling, discusses challenges after splitting, and reviews database clustering and distributed ID generation techniques such as UUID and Snowflake, highlighting their advantages and drawbacks.

Distributed SystemsID generationdatabase clustering
0 likes · 15 min read
Scaling Strategies: Hardware Expansion, AKF Partitioning, and Distributed ID Generation
Java High-Performance Architecture
Java High-Performance Architecture
Nov 1, 2021 · Operations

Why Scaling Matters: Hardware Expansion, Distributed ID & Elastic Capacity Strategies

The article explains why performance optimization has limits and outlines practical scaling methods—including whole‑machine and component upgrades, AKF splitting, database clustering, distributed ID generation (UUID and Snowflake), and elastic scaling—while also discussing the challenges each approach introduces.

ID generationcapacity planningdatabase clustering
0 likes · 14 min read
Why Scaling Matters: Hardware Expansion, Distributed ID & Elastic Capacity Strategies
IT Architects Alliance
IT Architects Alliance
Aug 24, 2021 · Backend Development

Distributed ID Generation Schemes and the rpcxio/did Service

This article reviews common ID generation strategies—including UUID/GUID, auto‑increment integers, random numbers, short strings, Twitter's Snowflake, and MongoDB ObjectID—compares their advantages and drawbacks, and introduces the rpcxio/did distributed ID service with performance benchmarks.

ID generationperformancesnowflake
0 likes · 12 min read
Distributed ID Generation Schemes and the rpcxio/did Service
Code Ape Tech Column
Code Ape Tech Column
Aug 18, 2021 · Backend Development

Global Unique ID Overview and Generation Strategies

This article explains the concept, essential characteristics, and common generation strategies—including database auto‑increment, UUID, Redis, Zookeeper, and Twitter's Snowflake—highlighting their advantages, drawbacks, and practical optimization tips for building reliable distributed systems.

ID generationglobal unique IDredis
0 likes · 12 min read
Global Unique ID Overview and Generation Strategies
Wukong Talks Architecture
Wukong Talks Architecture
Aug 13, 2021 · Backend Development

Understanding the Snowflake ID Generation Algorithm and Its Variants (Baidu UIDGenerator, Meituan Leaf‑Snowflake)

This article explains Twitter's Snowflake distributed ID algorithm, its 64‑bit structure, advantages and drawbacks, and compares it with Baidu's UIDGenerator and Meituan's Leaf‑Snowflake implementations, helping readers choose the most suitable unique‑ID solution for their backend systems.

BackendID generationUnique ID
0 likes · 5 min read
Understanding the Snowflake ID Generation Algorithm and Its Variants (Baidu UIDGenerator, Meituan Leaf‑Snowflake)
Sohu Tech Products
Sohu Tech Products
May 19, 2021 · Backend Development

Design Principles and Architecture of Large‑Scale Instant Messaging Systems

This article explores core concepts, ID design, read/write fan-out, push‑pull models, and industry implementations for large‑scale instant messaging systems, discussing trade‑offs in message diffusion, unique identifier strategies, real‑time delivery, ordering, unread counts, multi‑device sync, and deployment considerations.

ID generationInstant MessagingScalability
0 likes · 23 min read
Design Principles and Architecture of Large‑Scale Instant Messaging Systems
dbaplus Community
dbaplus Community
Apr 5, 2021 · Databases

When and How to Apply Database Sharding: Practical Guidelines and Pitfalls

This article explains why database performance bottlenecks arise, outlines criteria for deciding when to shard databases and tables, and provides detailed strategies for SQL tuning, table restructuring, horizontal and vertical splitting, single‑ versus multi‑database sharding, as well as handling cross‑database joins, distributed transactions, pagination, and ID generation.

Distributed TransactionsID generationPerformance Optimization
0 likes · 12 min read
When and How to Apply Database Sharding: Practical Guidelines and Pitfalls
Alibaba Cloud Developer
Alibaba Cloud Developer
Mar 21, 2021 · Databases

Mastering Database Sharding: Theory, Design, and TDDL Implementation

This article explains what database sharding (splitting databases and tables) is, why it improves performance and availability, how to choose between horizontal and vertical partitioning, design ID generation, handle distributed transactions, migrate data smoothly, and configure Alibaba's TDDL middleware with practical code examples.

ID generationTDDLVertical Partitioning
0 likes · 20 min read
Mastering Database Sharding: Theory, Design, and TDDL Implementation
21CTO
21CTO
Jan 19, 2021 · Backend Development

Why We Shifted Away from Database‑Generated IDs to 64‑Bit Domain IDs

The article explains how our team, while building a SQL Server data catalog, adopted decoupling principles to avoid coupling business logic to a specific database, opting for domain‑generated 64‑bit IDs instead of database‑generated keys, and discusses the benefits of Snowflake‑style ID generators.

64-bit integerDistributed SystemsDomain-Driven Design
0 likes · 6 min read
Why We Shifted Away from Database‑Generated IDs to 64‑Bit Domain IDs
High Availability Architecture
High Availability Architecture
Jan 8, 2021 · Backend Development

Why We Shifted Away from Database-Generated IDs to 64‑Bit Integer IDs

The article explains how decoupling persistence from a specific database engine and moving ID generation to the domain layer using 64‑bit integer identifiers—leveraging the Twitter Snowflake algorithm and the IdGen library—improves scalability, reduces coupling, and avoids the storage overhead of UUIDs.

64-bit integerBackend ArchitectureDistributed Systems
0 likes · 6 min read
Why We Shifted Away from Database-Generated IDs to 64‑Bit Integer IDs
Architect
Architect
Oct 13, 2020 · Fundamentals

Distributed ID Generation Schemes and the rpcxio/did Service

This article reviews various ID generation methods—including UUID/GUID, auto‑increment integers, random numbers, Snowflake, and MongoDB ObjectID—explains their advantages and drawbacks, and introduces the rpcxio/did distributed ID service with performance benchmarks and deployment considerations.

Distributed SystemsID generationsnowflake
0 likes · 12 min read
Distributed ID Generation Schemes and the rpcxio/did Service
Java Backend Technology
Java Backend Technology
Aug 30, 2020 · Databases

Mastering Database Sharding: Core Concepts, Middleware, and Common Challenges

Sharding splits a single database into multiple servers to improve performance, covering vertical and horizontal partitioning, middleware options, and key challenges such as distributed transactions, cross‑node joins, ID generation, pagination, routing transparency, and choosing between frameworks or custom solutions.

Distributed TransactionsID generationdatabase partitioning
0 likes · 16 min read
Mastering Database Sharding: Core Concepts, Middleware, and Common Challenges
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 2, 2020 · Databases

Using Distributed Timestamp Global Sequence in Dble: Environment Setup and Verification

This article explains the distributed‑timestamp global sequence in Dble, detailing its 63‑bit ID structure, the required Zookeeper and configuration file settings, schema and server adjustments, and step‑by‑step commands to create a table, insert data, and verify that the generated IDs correctly encode instance, cluster, and timestamp information.

Database MiddlewareDistributed TimestampID generation
0 likes · 7 min read
Using Distributed Timestamp Global Sequence in Dble: Environment Setup and Verification
Programmer DD
Programmer DD
May 20, 2020 · Backend Development

Choosing the Right Unique ID Strategy: From Auto‑Increment to Snowflake

This article reviews common system‑wide unique ID generation techniques—including database auto‑increment, UUIDs, Redis counters, Twitter's Snowflake, Zookeeper sequences, and MongoDB ObjectId—detailing their advantages, drawbacks, optimization tips, and providing C# code examples for implementation.

ID generationUnique IDcsharp
0 likes · 15 min read
Choosing the Right Unique ID Strategy: From Auto‑Increment to Snowflake
Selected Java Interview Questions
Selected Java Interview Questions
Oct 11, 2019 · Databases

Primary Key Strategies After Database Sharding

After splitting a database into multiple shards, generating globally unique primary keys becomes essential, and this article examines various solutions—including auto‑increment IDs, sequence steps, UUIDs, timestamp concatenation, and the Snowflake algorithm—detailing their advantages, drawbacks, and suitable scenarios.

ID generationprimary keysharding
0 likes · 11 min read
Primary Key Strategies After Database Sharding
ITPUB
ITPUB
May 28, 2018 · Databases

Mastering Database Sharding: When and How to Split Your Data

This article explains why and how relational databases should be sharded, covering vertical and horizontal partitioning techniques, common pitfalls such as distributed transactions and join queries, and practical guidelines for deciding when to split data and which tools to use.

Distributed TransactionsID generationVertical Partitioning
0 likes · 22 min read
Mastering Database Sharding: When and How to Split Your Data
Java Backend Technology
Java Backend Technology
Apr 23, 2018 · Backend Development

Mastering Distributed ID Generation: Snowflake, Custom ID Generators, and Base62 Conversion

This article explores the challenges of generating globally unique, trend‑ordered IDs in distributed systems, compares database auto‑increment, UUID and ID‑grouping approaches, explains Twitter's Snowflake algorithm, provides a full Java implementation with Base62 conversion utilities, and introduces the Vesta ID‑generator framework.

ID generationJavabase62
0 likes · 16 min read
Mastering Distributed ID Generation: Snowflake, Custom ID Generators, and Base62 Conversion
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Apr 7, 2018 · Backend Development

Why and How to Split Monolithic Applications: A Practical Guide

This article explains why monolithic applications need to be split, outlines the preparatory steps for understanding business complexity and defining service boundaries, and provides detailed practical guidance on database vertical and horizontal splitting, global ID generation, migration, cut‑over strategies, consistency, and post‑split stability.

BackendConsistencyID generation
0 likes · 17 min read
Why and How to Split Monolithic Applications: A Practical Guide
Dada Group Technology
Dada Group Technology
Nov 17, 2017 · Backend Development

Designing a High‑Availability Distributed ID Generator: From UUID to Snowflake

This article examines the requirements for globally unique IDs in distributed systems, compares classic generation schemes such as UUID, Flickr, Snowflake and TDDL, and details a customized Snowflake‑based implementation with ZooKeeper‑managed worker IDs, clock‑rollback handling, deployment optimizations, and JVM tuning to achieve high performance and reliability.

BackendDistributed SystemsID generation
0 likes · 15 min read
Designing a High‑Availability Distributed ID Generator: From UUID to Snowflake
Meituan Technology Team
Meituan Technology Team
Apr 21, 2017 · Backend Development

Design and Implementation of Meituan's Distributed ID Generation System Leaf

Meituan’s Leaf system merges segment‑based caching with Snowflake‑style bit fields to deliver globally unique, trend‑increasing 64‑bit IDs at ultra‑low latency, using double‑buffered DB segments, master‑slave MySQL replication, Zookeeper‑assigned worker IDs, and clock‑rollback safeguards, achieving ~50 k QPS and 1 ms 99.9th‑percentile response across billions of daily IDs.

BackendDistributed SystemsID generation
0 likes · 18 min read
Design and Implementation of Meituan's Distributed ID Generation System Leaf
ITPUB
ITPUB
Feb 10, 2017 · Backend Development

How to Generate Globally Unique IDs in Distributed Systems: Snowflake and Its Variants

This article explains the challenges of generating globally unique IDs across distributed shards, outlines the requirements for such IDs, and details Twitter's Snowflake algorithm—including its structure, generation process, and clock handling—before exploring three notable Snowflake variants and their trade‑offs.

BackendDistributed SystemsID generation
0 likes · 10 min read
How to Generate Globally Unique IDs in Distributed Systems: Snowflake and Its Variants
Meituan Technology Team
Meituan Technology Team
Nov 18, 2016 · Databases

Vertical and Horizontal Database Sharding Strategies for Large-Scale Order Systems

Facing a 200 GB order table that strained performance during flash‑sale spikes, Meituan first vertically split the schema, then horizontally sharded orders by user and merchant IDs using a 32 × 32 hash scheme with embedded timestamp‑based IDs, enabling scalable clusters, flexible migration stages, and simplified queries while preserving transaction integrity.

ID generationVertical Partitioningdatabase sharding
0 likes · 11 min read
Vertical and Horizontal Database Sharding Strategies for Large-Scale Order Systems
Alibaba Cloud Developer
Alibaba Cloud Developer
Sep 26, 2016 · Artificial Intelligence

Can Machine Learning Predict China’s Car License Lottery? Secrets in 13‑Digit IDs

This article investigates whether the 13‑digit user IDs used in Chinese car‑license lotteries are truly random, revealing how the ID generation, seed‑based selection, and hidden patterns—especially the influential seventh digit—affect outcomes, and demonstrates that simple linear models can achieve an AUC of around 0.8 in predicting winners, while also discussing the system’s opacity across major cities.

ID generationcar license lotterydata analysis
0 likes · 17 min read
Can Machine Learning Predict China’s Car License Lottery? Secrets in 13‑Digit IDs
Architecture Digest
Architecture Digest
Apr 27, 2016 · Databases

Database Sharding Strategies: Vertical and Horizontal Partitioning, ID Generation, and Migration Phases

The article outlines a comprehensive database sharding solution for a massive order system, describing vertical and horizontal partitioning, various sharding strategies, a custom ID scheme, transaction handling, complex query constraints, and a three‑stage data migration plan to achieve long‑term scalability.

Data MigrationID generationScalability
0 likes · 10 min read
Database Sharding Strategies: Vertical and Horizontal Partitioning, ID Generation, and Migration Phases
Architecture Digest
Architecture Digest
Apr 3, 2016 · Backend Development

Design and Implementation of Albianj Distributed Framework Components

The article details the design and implementation of Albianj's core backend components—including distributed lock considerations, unique ID generators, logging, caching, dynamic configuration, and RESTful services—highlighting their architecture, operational principles, and the practical benefits observed in real-world deployments.

AlbianjConfigurationDistributed Systems
0 likes · 22 min read
Design and Implementation of Albianj Distributed Framework Components