BestHub
Sign in
Architect's Guide
Author

Architect's Guide

Dedicated to sharing programmer-architect skills—Java backend, system, microservice, and distributed architectures—to help you become a senior architect.

741
Articles
0
Likes
5.2k
Views
0
Comments
Recent Articles

Latest from Architect's Guide

100 recent articles max
Architect's Guide
Architect's Guide
Oct 6, 2026 · Databases

Illustrated Redis: Architecture, Replication & Persistence Internals

This article provides a comprehensive visual guide to Redis architecture, covering single-instance deployment, high-availability setups with Sentinel, Redis Cluster sharding with hash slots, replication mechanics using replication IDs and offsets, and persistence models including RDB snapshots, AOF logging, and the fork/copy-on-write mechanism.

ClusterCopy-on-WriteRedis
0 likes · 20 min read
Illustrated Redis: Architecture, Replication & Persistence Internals
Architect's Guide
Architect's Guide
Oct 5, 2026 · Backend Development

Open-Source Tool Generates Full-Stack Spring Boot CRUD Code from DB Schema

This article introduces an open-source code generator that automatically creates complete Spring Boot CRUD layers—entities, DAOs, MyBatis mappers, services, converters, and controllers—from database schemas or SQL, featuring customizable templates with dynamic parameters and reusable code blocks for team-specific conventions.

Backend DevelopmentJavaMyBatis
0 likes · 19 min read
Open-Source Tool Generates Full-Stack Spring Boot CRUD Code from DB Schema
Architect's Guide
Architect's Guide
Oct 3, 2026 · Backend Development

NetEase Interview: Debugging 900% CPU Spikes in MySQL and Java Processes

This article details systematic troubleshooting for 900% CPU spikes in MySQL and Java processes, covering top/jstack diagnostics, show processlist analysis, index optimization, cache integration, and fixing busy-wait loops with BlockingQueue.take(), illustrated through real production case studies.

Java thread analysisMySQL performance tuningProduction Debugging
0 likes · 12 min read
NetEase Interview: Debugging 900% CPU Spikes in MySQL and Java Processes
Architect's Guide
Architect's Guide
Sep 30, 2026 · Databases

10 Advanced SQL Techniques for Data Science Interviews

This article explains ten advanced SQL concepts including CTEs, recursive queries, temporary functions, pivoting with CASE WHEN, EXCEPT vs NOT IN, self-joins, ranking functions, delta calculations with LEAD/LAG, running totals, and datetime manipulation, with code examples for data science interview preparation.

CTEDatetime ManipulationPivoting
0 likes · 12 min read
10 Advanced SQL Techniques for Data Science Interviews
Architect's Guide
Architect's Guide
Sep 29, 2026 · Backend Development

Elegant Backend API Design: Unified Response Wrapper with Spring Boot Annotations & AOP

This article walks through designing a clean, unified API response format with categorized error codes, then shows how to automate response wrapping in Spring Boot using a custom @ResponseResult annotation, a handler interceptor, and ResponseBodyAdvice so controllers return plain domain objects while the framework handles consistent JSON serialization.

API designControllerAdviceCustom Annotation
0 likes · 9 min read
Elegant Backend API Design: Unified Response Wrapper with Spring Boot Annotations & AOP
Architect's Guide
Architect's Guide
Sep 28, 2026 · Backend Development

Production Services Randomly Dropping Offline: A Week-Long Debugging Journey to a Linux Kernel Bug

An engineer details a week-long investigation into random microservice disappearances from Nacos in a Spring Cloud Alibaba cluster, systematically ruling out memory, CPU, disk, network, Nacos server/client issues, and JVM problems before discovering a Linux kernel bug causing JVM pauses, resolved by kernel upgrade.

ArthasJVMLinux kernel
0 likes · 9 min read
Production Services Randomly Dropping Offline: A Week-Long Debugging Journey to a Linux Kernel Bug