BestHub
Sign in
Tagged articles
151 articles
Page 2 of 2
Top Architect
Top Architect
Apr 11, 2022 · Databases

Why Using UUID as MySQL Primary Key Is Inefficient: A Performance Comparison with Auto‑Increment and Random Keys

This article investigates MySQL's recommendation against UUID primary keys by creating three tables—auto‑increment, UUID, and random (snowflake) keys—running insert and query benchmarks with SpringBoot/JdbcTemplate, analyzing index structures, and discussing the performance trade‑offs and security considerations of each key strategy.

auto_incrementdatabaseindex
0 likes · 11 min read
Why Using UUID as MySQL Primary Key Is Inefficient: A Performance Comparison with Auto‑Increment and Random Keys
Top Architect
Top Architect
Apr 4, 2022 · Backend Development

Designing a Distributed Global Unique ID Generation System: From UUID to Snowflake

This article explains the challenges of generating globally unique identifiers in distributed systems and presents various solutions—including UUID, database auto‑increment, Redis atomic counters, and the Snowflake algorithm—detailing their requirements, implementations in Java and SpringBoot, and their pros and cons.

Backenddistributed-idjava
0 likes · 15 min read
Designing a Distributed Global Unique ID Generation System: From UUID to Snowflake
Architecture Digest
Architecture Digest
Apr 3, 2022 · Frontend Development

Why NanoID Is Replacing UUID: Features, Advantages, and Limitations

This article examines NanoID as a modern alternative to UUID, detailing its smaller size, higher speed, stronger security, language support, custom alphabets, lack of dependencies, and compatibility, while also discussing its limitations and future prospects for unique identifier generation in JavaScript projects.

JavaScriptUnique IDnanoid
0 likes · 7 min read
Why NanoID Is Replacing UUID: Features, Advantages, and Limitations
Top Architect
Top Architect
Mar 26, 2022 · Information Security

Why NanoID Is Replacing UUID: Features, Advantages, and Limitations

This article explains how NanoID, a compact and faster alternative to UUID, offers better security, smaller size, higher performance, and broad language support, while also discussing its limitations and future prospects for unique identifier generation in software development.

JavaScriptnanoidperformance
0 likes · 8 min read
Why NanoID Is Replacing UUID: Features, Advantages, and Limitations
Programmer DD
Programmer DD
Mar 25, 2022 · Fundamentals

Why NanoID Is Replacing UUID for Faster, Safer IDs

This article compares NanoID and UUID, highlighting NanoID's smaller size, higher security, faster generation speed, language support, and flexibility, while also discussing its limitations and future prospects, to help developers decide when to choose NanoID over UUID.

JavaScriptnanoidperformance
0 likes · 8 min read
Why NanoID Is Replacing UUID for Faster, Safer IDs
Sanyou's Java Diary
Sanyou's Java Diary
Mar 10, 2022 · Backend Development

Choosing the Right Distributed ID Strategy for Microservices

This article reviews common distributed ID generation methods—including UUID, database auto‑increment, segment mode, Redis, Snowflake, Baidu UidGenerator, Meituan Leaf, and Zookeeper—detailing their principles, advantages, drawbacks, and suitable scenarios to help developers select the most appropriate solution for their microservice architecture.

BackendMicroservicesdistributed-id
0 likes · 9 min read
Choosing the Right Distributed ID Strategy for Microservices
ITPUB
ITPUB
Jan 26, 2022 · Backend Development

How to Choose the Right Distributed Unique ID Strategy for Your System

This article explains why globally unique identifiers are essential in distributed systems, outlines the key characteristics of a good ID scheme, and compares several generation methods—including UUID, database auto‑increment, segmented DB ranges, Redis INCR, Zookeeper, Meituan Leaf, Snowflake, and Baidu uid‑generator—highlighting their advantages, drawbacks, and practical implementation details.

databasedistributed-idhigh-availability
0 likes · 18 min read
How to Choose the Right Distributed Unique ID Strategy for Your System
Java Captain
Java Captain
Jan 9, 2022 · Databases

Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL

This article evaluates MySQL insertion performance of three primary key strategies—auto‑increment, UUID, and random Snowflake‑like keys—by building identical tables, running Spring‑Boot/JdbcTemplate benchmarks, analyzing index structures, and discussing the advantages and drawbacks of each approach.

auto_incrementmysqlperformance
0 likes · 9 min read
Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL
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
Top Architect
Top Architect
Nov 8, 2021 · Backend Development

Global Unique ID Generation Strategies: Overview, Advantages, Disadvantages, and Optimizations

The article provides a comprehensive overview of global unique ID generation in distributed systems, detailing the characteristics of a good ID, comparing five common strategies—database auto‑increment, UUID, Redis, Zookeeper, and Twitter Snowflake—along with their pros, cons, and practical optimization tips.

databasedistributed-systemsglobal ID
0 likes · 11 min read
Global Unique ID Generation Strategies: Overview, Advantages, Disadvantages, and Optimizations
Architecture Digest
Architecture Digest
Sep 28, 2021 · Backend Development

Ensuring Idempotency with Unique IDs: UUID, Snowflake, and Shared Storage Strategies

The article explains why idempotency is essential for reliable services, describes how unique identifiers such as UUIDs and Snowflake-generated IDs can guarantee idempotent operations, and outlines practical storage and query techniques using databases or Redis to prevent duplicate orders, inventory deductions, and payments.

IdempotencyUnique IDdatabase
0 likes · 6 min read
Ensuring Idempotency with Unique IDs: UUID, Snowflake, and Shared Storage 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
Selected Java Interview Questions
Selected Java Interview Questions
Jul 3, 2021 · Backend Development

Designing Idempotent APIs and Global ID Strategies

This article explains the concept of API idempotency, why it is needed for reliable retries, and presents practical designs using global unique identifiers such as UUID and Snowflake, including their advantages, drawbacks, and implementation considerations for backend services.

APIIdempotencydistributed-systems
0 likes · 9 min read
Designing Idempotent APIs and Global ID Strategies
Top Architect
Top Architect
Jun 24, 2021 · Backend Development

Designing Idempotent APIs and Global Unique ID Strategies

This article explains the concept of API idempotency, why it is needed, practical design approaches, and how to generate globally unique identifiers using methods such as UUID and Snowflake to ensure reliable, high‑performance backend services.

BackendIdempotencyapi-design
0 likes · 8 min read
Designing Idempotent APIs and Global Unique ID Strategies
Top Architect
Top Architect
Mar 4, 2021 · Databases

Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL

This article investigates why MySQL recommends auto_increment over UUID or non‑sequential snowflake IDs by creating three tables, running insert and query benchmarks with Spring Boot and JdbcTemplate, analyzing index structures, and summarizing the performance trade‑offs and security considerations of each primary‑key strategy.

auto_incrementindexingperformance
0 likes · 10 min read
Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL
Xianyu Technology
Xianyu Technology
Feb 5, 2021 · Backend Development

Improving Xianyu Messaging Reliability: Architecture, Issues, and Solutions

The article details how Xianyu’s 2020 messaging failures—lost messages, wrong avatars, and order status errors—were traced to duplicate IDs, push‑logic mismatches, and client bugs, and solved by introducing global UUIDs, ACK‑based retries, hierarchical conversation models, hybrid storage caching, and real‑time monitoring, boosting delivery reliability above 99.9%.

BackendMessagingMobile
0 likes · 12 min read
Improving Xianyu Messaging Reliability: Architecture, Issues, and Solutions
Code Ape Tech Column
Code Ape Tech Column
Dec 28, 2020 · Backend Development

Distributed ID Concepts, Implementation Schemes, and Open‑Source Solutions

This article explains the need for globally unique identifiers in distributed systems, compares common generation schemes such as UUID, database auto‑increment, Redis counters, and Snowflake, and reviews open‑source implementations like Meituan Leaf and Baidu UidGenerator with a Java Snowflake example.

distributed-idjavaopen-source
0 likes · 10 min read
Distributed ID Concepts, Implementation Schemes, and Open‑Source Solutions
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 2, 2020 · Databases

Design Principles and Practices for MySQL Primary Keys

This article explains MySQL primary key design principles, compares auto‑increment, UUID and uuid_short approaches, provides SQL examples and performance benchmarks, and offers guidance on choosing business‑related versus unrelated key columns for optimal data integrity and query efficiency.

auto_incrementmysqlprimary key
0 likes · 12 min read
Design Principles and Practices for MySQL Primary Keys
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Nov 4, 2020 · Fundamentals

An Overview of Six Distributed ID Generation Algorithms and Their Trade‑offs

This article introduces the concept of distributed IDs, outlines the required properties of global uniqueness, high availability, performance and simplicity, and compares six generation schemes—UUID/GUID, database auto‑increment, random numbers, random strings, Snowflake, and MongoDB ObjectID—detailing their structures, advantages and disadvantages.

MongoDB ObjectIDauto_incrementdistributed-id
0 likes · 8 min read
An Overview of Six Distributed ID Generation Algorithms and Their Trade‑offs
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Oct 15, 2020 · Databases

Which Primary Key Is Faster in MySQL? Auto‑Increment vs UUID vs Snowflake

This article creates three MySQL tables with auto‑increment, UUID, and Snowflake‑generated random keys, runs identical insert workloads using Spring Boot and JdbcTemplate, measures performance, compares index structures, discusses the pros and cons of each key type, and concludes with best‑practice recommendations.

Spring Bootauto_incrementindex
0 likes · 10 min read
Which Primary Key Is Faster in MySQL? Auto‑Increment vs UUID vs Snowflake
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
Programmer DD
Programmer DD
Sep 19, 2020 · Databases

Why MySQL Auto‑Increment Outperforms UUID: Full Performance Test and Analysis

This article examines MySQL's recommendation to use auto_increment primary keys instead of UUID or Snowflake IDs by creating three tables, running insertion benchmarks with Spring Boot, comparing index structures, and discussing the performance trade‑offs and practical drawbacks of each approach.

Database designauto_incrementindex
0 likes · 9 min read
Why MySQL Auto‑Increment Outperforms UUID: Full Performance Test and Analysis
Architecture Digest
Architecture Digest
Sep 11, 2020 · Databases

Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL

This article investigates why MySQL recommends auto_increment primary keys over UUID or snowflake IDs by creating three tables with different key strategies, running insertion benchmarks using Spring Boot, and analyzing index structures, performance results, and the trade‑offs of each approach.

Database Indexauto_incrementmysql
0 likes · 10 min read
Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL
MaGe Linux Operations
MaGe Linux Operations
Aug 23, 2020 · Databases

Choosing the Right Primary Key Strategy: UUID, Snowflake, Redis, and More

This article reviews common primary key generation methods—including auto‑increment drawbacks and five alternatives such as UUID, step, segment, Snowflake, and Redis—explaining their mechanisms, advantages, and trade‑offs to help you select the best fit for high‑concurrency and distributed systems.

databaseprimary keysharding
0 likes · 9 min read
Choosing the Right Primary Key Strategy: UUID, Snowflake, Redis, and More
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 12, 2020 · Backend Development

Distributed ID Generation Techniques Discussed in an Interview with Java Implementations

During a technical interview, the candidate explains various distributed ID generation methods—including database auto‑increment, sharding, batch allocation, UUID, Redis atomic counters, and the Snowflake algorithm—analyzes their pros and cons, and provides Java code examples for Redis‑based and Snowflake ID generators.

distributed-idjavaredis
0 likes · 18 min read
Distributed ID Generation Techniques Discussed in an Interview with Java Implementations
Top Architect
Top Architect
Jun 8, 2020 · Backend Development

Ensuring Idempotency with Unique IDs: UUID, Snowflake, and Distributed ID Generation

The article explains why idempotency is essential for reliable services, describes how unique identifiers such as UUIDs, Snowflake IDs, and database‑generated keys can be used to achieve it, and offers practical guidance on shared storage, avoiding unnecessary queries, and handling duplicate requests in distributed systems.

IdempotencyUnique IDdatabase
0 likes · 8 min read
Ensuring Idempotency with Unique IDs: UUID, Snowflake, and Distributed ID Generation
Architecture Digest
Architecture Digest
May 11, 2020 · Backend Development

Ensuring Idempotency in Distributed Systems: Unique ID Generation Strategies

The article explains why idempotency is essential for reliable service calls, discusses using unique identifiers such as UUIDs and Snowflake algorithms, compares centralized and client‑side ID generation, and offers practical storage and query‑optimisation techniques to prevent duplicate orders and resource waste.

Distributed SystemsIdempotencyUnique ID
0 likes · 6 min read
Ensuring Idempotency in Distributed Systems: Unique ID Generation Strategies
21CTO
21CTO
Feb 20, 2020 · Backend Development

How to Choose the Right Global Unique ID Strategy for Distributed Systems

Generating globally unique IDs in distributed systems requires balancing uniqueness, monotonicity, high availability, security, and storage efficiency, and this article compares common solutions—including database auto‑increment, Redis/MongoDB/Zookeeper, UUID versions, and the Snowflake algorithm—detailing their advantages, drawbacks, and practical implementation tips.

BackendUnique IDdistributed-systems
0 likes · 9 min read
How to Choose the Right Global Unique ID Strategy for Distributed Systems
FunTester
FunTester
Dec 7, 2019 · Backend Development

Generating Unique Order Numbers in Java: Risks, Testing, and Improved Approaches

The article examines a Java method that creates unique transaction order numbers by combining a timestamp with a four‑digit random code, discusses its collision risk, evaluates testing strategies—including stress testing and UUID replacement—and provides sample code for both generation and duplicate detection.

javaorder-numberunique identifier
0 likes · 6 min read
Generating Unique Order Numbers in Java: Risks, Testing, and Improved Approaches
Java High-Performance Architecture
Java High-Performance Architecture
Dec 3, 2019 · Backend Development

Choosing the Right Distributed ID Strategy: UUID, DB, Redis, Snowflake Explained

Distributed ID systems must be globally unique, incremental, highly available, and secure; this article compares common generation methods—including UUID, database auto‑increment, Redis atomic counters, and the Snowflake algorithm—detailing their advantages, drawbacks, and suitable use‑cases for modern high‑throughput services.

database auto-incrementdistributed-idsnowflake
0 likes · 5 min read
Choosing the Right Distributed ID Strategy: UUID, DB, Redis, Snowflake Explained
Qunar Tech Salon
Qunar Tech Salon
Nov 14, 2019 · Mobile Development

Implementing A/B Testing for Low‑Frequency Mobile App Home UI with a Hybrid Client‑Server Approach

This article explains the challenges of low‑frequency home‑page UI A/B testing in a mobile app and presents a hybrid client‑server solution that assigns UUIDs to users, uses MurmurHash for logical grouping, maps to business groups, and outlines server‑side handling and best practices.

A/B testingMurmurHashUser Segmentation
0 likes · 7 min read
Implementing A/B Testing for Low‑Frequency Mobile App Home UI with a Hybrid Client‑Server Approach
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
Java Architecture Diary
Java Architecture Diary
Mar 30, 2019 · Backend Development

Which Java UUID Generator Is Fastest? JMH Benchmark Comparison

This article explains the purpose of UUIDs, common use cases, compares several Java UUID generation libraries, and presents JMH benchmark results showing that the mica implementation based on Java 9 outperforms JDK 8 ThreadLocalRandom and Hutool FastSimpleUUID by three to four times.

JMHbenchmarkjava
0 likes · 4 min read
Which Java UUID Generator Is Fastest? JMH Benchmark Comparison
MaGe Linux Operations
MaGe Linux Operations
Mar 9, 2019 · Fundamentals

Unlock Hidden Python Tricks: Variable Arguments, Glob, Debugging, UUID, Serialization & More

This article reveals several lesser‑known Python features—including functions that accept arbitrary arguments, powerful file searching with glob, debugging with inspect, generating unique IDs via uuid, data serialization, string compression, and registering shutdown hooks—providing practical code examples for each.

atexitcompressiondebugging
0 likes · 5 min read
Unlock Hidden Python Tricks: Variable Arguments, Glob, Debugging, UUID, Serialization & More
MaGe Linux Operations
MaGe Linux Operations
Aug 10, 2018 · Fundamentals

Unlock Hidden Python Tricks: Variable Arguments, Glob, UUID, Serialization & More

This article introduces several often‑overlooked Python features—including functions that accept arbitrary arguments, file searching with glob, debugging with inspect, generating unique IDs via uuid, data serialization, string compression, and registering shutdown functions with atexit—providing concise examples and visual code snippets.

file-handlingfunctionsprogramming
0 likes · 5 min read
Unlock Hidden Python Tricks: Variable Arguments, Glob, UUID, Serialization & More
21CTO
21CTO
Oct 15, 2017 · Backend Development

Mastering Distributed Unique IDs: From Auto‑Increment to Snowflake

This article surveys various distributed unique ID generation techniques—including Oracle auto‑increment, Redis batch allocation, UUID versions, Hibernate and MongoDB strategies, and Twitter’s Snowflake—explaining their structures, trade‑offs, and practical implementation considerations for reliable, collision‑free identifiers.

Unique IDbackend-developmentdistributed-systems
0 likes · 10 min read
Mastering Distributed Unique IDs: From Auto‑Increment to Snowflake
Hujiang Technology
Hujiang Technology
Nov 9, 2016 · Databases

Risks of Auto‑Increment IDs and Distributed ID Solutions

The article explains how exposing auto‑increment primary keys can leak business information, illustrates the danger with historical examples, and evaluates alternative ID generation strategies such as encoding, UUIDs, and Snowflake‑style distributed IDs, including performance comparisons in MySQL.

Database designauto_incrementdistributed-id
0 likes · 9 min read
Risks of Auto‑Increment IDs and Distributed ID Solutions