Mastering Global ID Generation: From MySQL Auto‑Increment to Snowflake & Leaf

This article compares common global ID generation strategies for microservice architectures, covering database‑level solutions like auto‑increment configuration and MyCat + ZooKeeper, as well as application‑level approaches such as UUID, Snowflake, Leaf (segment and Snowflake modes), Redis, and ZooKeeper, with configuration steps, code samples, and pros‑cons.

JavaLeafdistributed-id

0 likes · 16 min read

Mastering Global ID Generation: From MySQL Auto‑Increment to Snowflake & Leaf

Java High-Performance Architecture

Mar 8, 2023 · Backend Development

How Snowflake Generates 64‑Bit Unique IDs: Deep Dive & Java Implementation

This article explains the SnowFlake distributed ID algorithm, detailing its 64‑bit structure, bit allocation for timestamps, datacenter and worker IDs, sequence numbers, and provides a complete Java implementation along with its advantages and limitations.

Backendalgorithmdistributed-id

0 likes · 10 min read

How Snowflake Generates 64‑Bit Unique IDs: Deep Dive & Java Implementation

Architecture Digest

Sep 11, 2019 · Databases

Distributed ID Generation Mechanisms: Auto‑Increment, Multi‑Master, Segment Mode, Snowflake and Redis

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.

Segmentdatabasedistributed-id

0 likes · 13 min read

Distributed ID Generation Mechanisms: Auto‑Increment, Multi‑Master, Segment Mode, Snowflake and Redis

Java Backend Technology

Sep 30, 2018 · Backend Development

Choosing the Right Distributed ID Generation Strategy: UUID, Snowflake, Redis, and More

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.

ZooKeeperbackend-developmentdistributed-id

0 likes · 13 min read

Choosing the Right Distributed ID Generation Strategy: UUID, Snowflake, Redis, and More