BestHub
Sign in
Tagged articles

Snowflake ID

12 articles · Page 1 of 1
dbaplus Community
dbaplus Community
Jun 7, 2026 · Backend Development

Midnight Crash: The ‘Impossible’ MyBatis‑Plus Pitfalls That Can Break Production

The article catalogs six production‑ready pitfalls of MyBatis‑Plus—duplicate Snowflake IDs, batch‑insert disorder, enum storage errors, camel‑case mismatches, auto‑fill failures, and JSON field loss—explains their root causes with concrete examples and code, and provides practical solutions to keep the framework reliable in high‑concurrency environments.

Auto FillBatch InsertEnum Mapping
0 likes · 16 min read
Midnight Crash: The ‘Impossible’ MyBatis‑Plus Pitfalls That Can Break Production
Senior Xiao Ying
Senior Xiao Ying
Feb 26, 2026 · Databases

Vertical vs Horizontal Sharding in MySQL: Strategy Selection and Middleware Guide

The article explains vertical and horizontal sharding concepts, compares their advantages and drawbacks, evaluates popular sharding middleware such as ShardingSphere, details distributed ID generation with Snowflake, offers cross‑database query solutions, and provides practical guidance on when and how to apply sharding in MySQL.

Cross-Database QueriesHorizontal ShardingMySQL
0 likes · 13 min read
Vertical vs Horizontal Sharding in MySQL: Strategy Selection and Middleware Guide
SpringMeng
SpringMeng
Dec 8, 2025 · Databases

Why Using Snowflake IDs or UUIDs as MySQL Primary Keys Hurts Performance

This article experimentally compares auto‑increment, UUID and Snowflake‑generated primary keys in MySQL, analyzes their index structures, shows insertion‑time benchmarks, discusses the trade‑offs of each approach, and concludes that sequential auto‑increment keys deliver the best overall performance.

Index PerformanceInnoDBMySQL
0 likes · 10 min read
Why Using Snowflake IDs or UUIDs as MySQL Primary Keys Hurts Performance
Selected Java Interview Questions
Selected Java Interview Questions
Jun 23, 2025 · Backend Development

Why Did My Snowflake IDs Collide? Lessons and Fixes for Distributed Systems

An unexpected primary-key duplicate error in a low-traffic Spring Cloud app revealed that multiple servers shared the same Snowflake workId, causing ID collisions; the article explains Snowflake's structure, its pros and cons, and offers three practical methods—including IP-based calculation, environment variables, and middleware—to ensure globally unique workIds.

ID collisionMybatisPlusSnowflake ID
0 likes · 6 min read
Why Did My Snowflake IDs Collide? Lessons and Fixes for Distributed Systems
Top Architect
Top Architect
Jan 6, 2023 · Databases

Why MySQL Discourages UUID Primary Keys and a Performance Comparison of Auto‑Increment, UUID, and Random Long IDs

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

IndexingMySQLPerformance
0 likes · 11 min read
Why MySQL Discourages UUID Primary Keys and a Performance Comparison of Auto‑Increment, UUID, and Random Long IDs
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.

Distributed IDHigh concurrencyRead‑Write Separation
0 likes · 20 min read
Designing Scalable Database Architecture for High‑Concurrency Systems
Architecture Digest
Architecture Digest
Nov 14, 2017 · Backend Development

Architecture and Technical Practices of JD.com’s Jingmai Message Center

The article details the Jingmai Message Center’s end‑to‑end architecture, covering message ingestion via Anycall and MQ, protocol conversion, Netty‑based push system, Snowflake ID generation, Elasticsearch storage, multi‑level caching, distributed locking, and the overall design principles that enable a scalable, reliable messaging platform.

CachingMicroservicesNetty
0 likes · 9 min read
Architecture and Technical Practices of JD.com’s Jingmai Message Center