BestHub
Sign in
Tagged articles

uuid

160 articles · Page 2 of 2
Java Architect Essentials
Java Architect Essentials
Sep 12, 2022 · Databases

Why MySQL Discourages UUIDs as Primary Keys: Performance Comparison with Auto‑Increment and Random Keys

This article investigates MySQL's recommendation against using UUIDs as primary keys by creating three tables (auto‑increment, UUID, and random snowflake IDs), benchmarking insert speeds with Spring Boot/JdbcTemplate, analyzing index structures, and discussing the advantages and drawbacks of each key strategy.

MySQLauto_incrementperformance
0 likes · 10 min read
Why MySQL Discourages UUIDs as Primary Keys: Performance Comparison with Auto‑Increment and Random Keys
Tencent Cloud Developer
Tencent Cloud Developer
Aug 24, 2022 · Backend Development

Go Distributed ID Generation: UUID, ShortUUID, XID, KSUID, ULID, Snowflake, and Segment Modes

The article surveys Go‑based distributed ID generation techniques—from UUID, short‑UUID, XID, KSUID, ULID, and Snowflake to database auto‑increment, Redis, ZooKeeper, and segment/leaf approaches—detailing their characteristics, trade‑offs, implementation snippets, and strategies for ordering, uniqueness, and clock‑rollback handling.

DatabaseGoRedis
0 likes · 12 min read
Go Distributed ID Generation: UUID, ShortUUID, XID, KSUID, ULID, Snowflake, and Segment Modes
Top Architect
Top Architect
Aug 11, 2022 · Databases

Primary Key and Index Design for Distributed Databases

The article explains why auto‑increment primary keys are unsuitable for sharded databases, recommends using globally unique ordered identifiers such as UUIDs or Snowflake IDs, and discusses index design strategies—including index tables, embedding shard keys, and handling global tables—to ensure efficient single‑shard queries.

Distributed Databasesglobal tablesindex design
0 likes · 10 min read
Primary Key and Index Design for Distributed Databases
Su San Talks Tech
Su San Talks Tech
Aug 11, 2022 · Backend Development

How to Choose the Right Distributed ID Generator for Your System

This article examines common distributed ID generation strategies—including UUID, Snowflake-like algorithms, database auto‑increment, and Redis atomic increment—detailing their requirements, advantages, drawbacks, and suitable scenarios to help engineers select the most appropriate solution for high‑performance, secure systems.

Redisdistributed IDsnowflake
0 likes · 12 min read
How to Choose the Right Distributed ID Generator for Your System
IT Xianyu
IT Xianyu
Jul 12, 2022 · Frontend Development

Understanding NanoID: Features, Advantages, Limitations, and Usage in JavaScript

This article introduces NanoID as a modern alternative to UUID, explains how to install and use it in JavaScript projects, compares performance, size, and security, discusses customization options and limitations, and suggests when to prefer NanoID for future development.

JavaScriptNode.jsUnique IDs
0 likes · 6 min read
Understanding NanoID: Features, Advantages, Limitations, and Usage in JavaScript
Programmer DD
Programmer DD
Jul 8, 2022 · Databases

Why Auto‑Increment Beats UUID in MySQL: Performance Test & Deep Dive

This article investigates MySQL’s recommendation against UUIDs, comparing auto‑increment, UUID, and Snowflake‑style random keys through insertion and query benchmarks, analyzing their index structures, performance impacts, and trade‑offs, and concludes why sequential primary keys generally outperform non‑sequential identifiers.

DatabaseIndexMySQL
0 likes · 12 min read
Why Auto‑Increment Beats UUID in MySQL: Performance Test & 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
Top Architect
Top Architect
Apr 30, 2022 · Backend Development

Scaling Strategies, Hardware Expansion, and Distributed ID Generation in Backend Systems

The article explains why capacity expansion is needed, compares whole‑machine and component‑level scaling, introduces the AKF splitting principle, discusses challenges of distributed architectures, and reviews database clustering and distributed ID generation techniques such as UUID and Snowflake.

Backend ArchitectureElastic Scalingdistributed ID
0 likes · 12 min read
Scaling Strategies, Hardware Expansion, and Distributed ID Generation in Backend Systems
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.

DatabaseIndexMySQL
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.

Redisbackenddistributed ID
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.

MicroservicesRedisbackend
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.

MySQLauto_incrementperformance
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.

Redisdistributed IDid generation
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.

DatabaseIdempotencyUnique ID
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.

Redisglobal unique IDid generation
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.

API DesignIdempotencybackend
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.

Indexingauto_incrementperformance
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%.

backenddistributed-systemsmessaging
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.

MySQLSQLauto_increment
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
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 DesignIndexMySQL
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.

MySQLauto_incrementdatabase index
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.

DatabaseShardingprimary key
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.

Redisdistributed IDjava
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.

DatabaseIdempotencyUnique ID
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.

IdempotencyUnique IDdistributed systems
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.

Unique IDbackenddistributed-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 testingClient‑ServerMobile App
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.

Shardingid generationprimary key
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.

DebuggingSerializationatexit
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 HandlingSerializationfunctions
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