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.
The article examines the 2012 GitHub data‑leak caused by MySQL master‑slave failover and auto_increment misuse, explains why developers' expectations of uniqueness, monotonicity and continuity are unrealistic, and proposes half‑sync replication and distributed ID algorithms like Snowflake as more reliable solutions.
The September 2021 DB‑Engines ranking shows Oracle, MySQL and SQL Server plummeting while MongoDB, Snowflake and ClickHouse surge, highlighting a shift toward niche and cloud‑native databases, and the article also recommends ten essential database books for professionals.
The September 2021 DB‑Engines ranking shows longtime leaders Oracle, MySQL and Microsoft SQL Server losing hundreds of points, while MongoDB, Snowflake and ClickHouse surge in popularity, Redis and InfluxDB dominate their niches, and the report stresses that selecting a database should prioritize business needs over mere ranking.
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.
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.
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.
This article explains the concept of idempotency in API design, why it matters, two main strategies to achieve it, and how global unique identifiers such as UUID and Snowflake can be used to guarantee single‑execution semantics while maintaining performance and scalability.
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.
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.
This article explains the background of migrating from MySQL to TiDB, introduces the Snowflake algorithm’s 64‑bit ID structure, discusses its advantages and disadvantages, provides a Python implementation, and highlights its impact on achieving globally unique, time‑ordered identifiers in distributed systems.
This article explains the concept of distributed unique identifiers, compares segment‑mode and Snowflake implementations, provides a full Java Snowflake code example, and reviews open‑source solutions such as Meituan Leaf and Baidu UidGenerator, offering guidance on selecting and using these ID generation tools in backend systems.
This article examines common distributed ID generation methods—including UUID, MySQL auto‑increment, multi‑instance auto‑increment, Snowflake, and Redis—detailing their advantages, drawbacks, and practical use cases, and presents advanced designs such as database‑driven ID blocks, concurrency handling, and double‑buffer techniques for high‑traffic systems.
The DB‑Engines March 2021 ranking evaluates 364 databases, highlighting shifts among the top ten—including Microsoft SQL Server’s steep decline, MySQL’s growth surge, PostgreSQL’s continued rise, and Snowflake’s dramatic climb—while offering trend graphs and insights for professionals choosing the right database technology.
The article explains how a team building a SQL Server data catalog decided to decouple persistence by moving ID generation from the database to the domain layer, adopting 64‑bit Snowflake‑style identifiers instead of auto‑increment keys or UUIDs to improve flexibility, scalability, and performance.
This article explains Twitter's Snowflake algorithm, detailing its 64‑bit structure, the role of each bit segment, a step‑by‑step Java implementation, and the algorithm's performance advantages and practical limitations in distributed backend systems.
This article explains common I/O and CPU bottlenecks in databases, introduces horizontal and vertical sharding techniques, discusses tools, global primary‑key generation methods, Snowflake ID algorithm, migration challenges, and provides practical guidance on when and how to apply database partitioning to improve performance and scalability.
The latest DB‑Engines popularity ranking reveals Oracle, MySQL and SQL Server still dominate the top three, while PostgreSQL, MariaDB, Azure SQL Database and Snowflake surge ahead, highlighting a stable yet evolving landscape where cloud‑native databases are gaining rapid momentum.
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.
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.
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.
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.
This article analyses the limitations of existing global unique ID solutions such as Snowflake, presents the design of a new high‑performance, time‑independent Mist algorithm with extended lifespan, and describes its practical Redis‑backed service Medis, including performance benchmarks and architectural considerations.
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.
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.
This article reviews common unique identifier generation techniques—including database auto‑increment, UUID, Redis counters, Snowflake, Zookeeper, and MongoDB ObjectId—detailing their advantages, drawbacks, and practical implementation examples with C# code snippets.
Distributed systems need globally unique, often monotonic IDs, and this article examines common ID generation strategies—Snowflake, database auto‑increment, segment allocation, multi‑master databases, and Raft‑based consensus—evaluating each for high availability and high performance, and highlighting trade‑offs and implementation details.
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.
This article explores various distributed ID generation methods, focusing on Twitter's Snowflake algorithm, detailing its structure, advantages, drawbacks, and comparisons with UUID, database auto-increment, and Redis, while providing implementation insights and references to related open-source solutions.
This article explains why distributed IDs are essential, outlines the key requirements for a global unique identifier, and compares nine popular generation strategies—including UUID, database auto‑increment, segment mode, Redis, Snowflake, TinyID, Baidu uid‑generator, and Meituan Leaf—detailing their advantages, drawbacks, and sample implementations.
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.
This tutorial demonstrates how to configure and use DBLE's global sequence feature, covering the timestamp‑based Snowflake algorithm and the offset‑setup type, including server.xml settings, table definitions, insertion behavior, and handling of restarts to ensure unique identifiers.
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.
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.
This article reviews various distributed ID generation strategies—including MySQL auto‑increment tables, multi‑master configurations, segment allocation, Snowflake algorithm, and open‑source solutions like Baidu uid‑generator and Meituan Leaf—highlighting their designs, trade‑offs, and implementation details for high‑performance backend systems.
This article reviews various distributed ID generation strategies—including database auto‑increment tables, dual‑master MySQL setups, segment allocation, the Snowflake algorithm, and Redis INCR—detailing their designs, SQL examples, scalability trade‑offs, and open‑source implementations.
This article examines Snowflake’s rapid rise as a cloud‑native data warehouse, contrasts its architecture and operational advantages with Oracle’s legacy system, and explains how shifting market dynamics, open‑source alternatives, and cloud adoption are reshaping the database landscape.
This article examines various distributed ID generation methods—including UUID, MySQL auto‑increment, Snowflake, and Redis—explaining their advantages, drawbacks, and how top companies combine block allocation and double‑buffering to achieve uniqueness, scalability, and high performance.
Database bottlenecks often require sharding; this guide explains core concepts of database partitioning, global ID generation methods, shard allocation strategies, smooth scaling techniques, and popular solutions, helping engineers decide when and how to implement effective sharding without premature over‑design.
This article explains how Snowflake’s cloud‑native data‑sharing capabilities let users across companies securely access shared datasets without costly extraction or duplication, transforming traditional data‑warehouse and BI workflows and unlocking fresh, detailed insights for businesses.
This article explains how a high‑throughput payment platform uses database sharding by user ID, Snowflake‑style globally unique order IDs, asynchronous replication for eventual consistency, multi‑level data caching, and coarse‑fine traffic pipelines to achieve millions of requests per second with robust high‑availability.
This article compares various distributed unique identifier generation methods—including UUID, database auto‑increment, Redis INCR, Zookeeper, segmented DB caches, and the Snowflake algorithm—detailing their principles, advantages, drawbacks, and suitable use‑cases to help developers select the optimal solution for their systems.
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.
This article explains the need for compact, time‑ordered unique IDs in distributed systems, describes Twitter's Snowflake 64‑bit ID structure, provides a full Java implementation with bit‑allocation details, and demonstrates its high‑performance generation of millions of IDs.
This article explains the necessity of globally unique and trend‑ordered identifiers for business systems, compares database auto‑increment, UUID, Redis, Snowflake, and MongoDB ObjectId solutions, and outlines their advantages, drawbacks, and best‑practice design criteria.
This article describes the background, requirements, existing industry solutions, and the final optimized implementation of a high‑performance, globally unique user ID generator based on MySQL auto‑increment, Redis, and atomic memory segments, including performance results from production deployment.
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.
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.
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.
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.
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.
The talk explains how LeTV’s BOSS platform used sharding, a custom distributed ORM called Mango, and Snowflake‑style ID generation together with cluster‑level request routing to expand its order processing from hundreds of thousands to over a million transactions per second.