Skip to content
Tagged articles

distributed-id

109 articles · Page 2 of 2
Architecture Digest
Architecture Digest
Jan 5, 2020 · Databases

Data Sharding, Partitioning, and Distributed ID Strategies for Relational Databases

This article explains why relational databases become bottlenecks at large scale, introduces vertical and horizontal sharding techniques, discusses the challenges of distributed transactions, cross‑shard queries, pagination, and global primary‑key generation, and provides practical guidelines and middleware options for implementing sharding in production systems.

Horizontal ScalingMySQLVertical Partitioning
0 likes · 23 min read
Data Sharding, Partitioning, and Distributed ID Strategies for Relational Databases
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.

Snowflakedatabase-auto-incrementdistributed-id
0 likes · 5 min read
Choosing the Right Distributed ID Strategy: UUID, DB, Redis, Snowflake Explained
macrozheng
macrozheng
Sep 19, 2019 · Backend Development

Mastering Distributed ID Generation: From MySQL Auto‑Increment to Snowflake

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.

MySQLSnowflakedistributed-id
0 likes · 13 min read
Mastering Distributed ID Generation: From MySQL Auto‑Increment to Snowflake
Architecture Digest
Architecture Digest
Apr 2, 2019 · Databases

Designing Scalable Database Architecture for High‑Concurrency Systems

This article explains how to design a database architecture that can handle millions of daily active users and tens of thousands of concurrent requests by using multi‑server sharding, extensive table partitioning, read‑write separation, and distributed unique‑ID generation techniques such as Snowflake.

Read-Write SeparationSnowflake IDdatabase sharding
0 likes · 20 min read
Designing Scalable Database Architecture for High‑Concurrency Systems
Meituan Technology Team
Meituan Technology Team
Dec 19, 2016 · Databases

MTDDL: Meituan Distributed Data Layer Middleware Overview

MTDDL, Meituan’s in‑house client‑side sharding middleware, was created to address rapid product‑database growth by offering dynamic data‑source routing, read‑write separation, distributed ID generation, configurable database‑and‑table sharding, connection‑pool management, SQL monitoring, and live configuration updates via annotations and extensible strategies.

JavaSQL MonitoringSharding
0 likes · 12 min read
MTDDL: Meituan Distributed Data Layer Middleware Overview
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.

Snowflakeauto-incrementdatabase design
0 likes · 9 min read
Risks of Auto‑Increment IDs and Distributed ID Solutions