Top Architect
Author

Top Architect

Top Architect focuses on sharing practical architecture knowledge, covering enterprise, system, website, large‑scale distributed, and high‑availability architectures, plus architecture adjustments using internet technologies. We welcome idea‑driven, sharing‑oriented architects to exchange and learn together.

3.1k
Articles
0
Likes
7.0k
Views
0
Comments
Recent Articles

Latest from Top Architect

100 recent articles max
Top Architect
Top Architect
Jan 20, 2026 · Operations

Turn a Raspberry Pi Zero W into a Mini Web Server with SSH and Ngrok

This guide explains what a Raspberry Pi Zero W is, lists its hardware specs, walks through downloading and flashing Raspbian Lite, enabling head‑less SSH and Wi‑Fi, configuring apt sources, installing and testing nginx, and exposing the server to the internet via an ngrok tunnel.

SSHSystem SetupZero W
0 likes · 15 min read
Turn a Raspberry Pi Zero W into a Mini Web Server with SSH and Ngrok
Top Architect
Top Architect
Jan 18, 2026 · Databases

Boost Your SQL Query Speed: Proven Optimization Techniques

This guide walks through the SQL query processing workflow, explains how parsing, optimization, and execution plans affect performance, and provides concrete techniques—such as selecting specific columns, avoiding DISTINCT, using proper indexes, preferring EXISTS over COUNT, limiting result sets, and replacing HAVING with WHERE—to dramatically speed up queries while keeping statements concise.

Database PerformanceIndexesQuery Optimization
0 likes · 8 min read
Boost Your SQL Query Speed: Proven Optimization Techniques
Top Architect
Top Architect
Jan 17, 2026 · Backend Development

Why We Rebuilt a Java Scheduler and How the New Lightweight Framework Works

Faced with limitations of existing tools like Quartz, XXL-Job, and PowerJob, the author explains the motivation for creating a custom scheduling framework, describes its architecture—including gRPC communication, protobuf serialization, a self-implemented name server for load balancing, a simple message queue, and time-wheel scheduling—provides code examples, and shares diagrams of discovery and dispatch processes.

JavaLoad BalancingMessage Queue
0 likes · 17 min read
Why We Rebuilt a Java Scheduler and How the New Lightweight Framework Works
Top Architect
Top Architect
Jan 13, 2026 · Backend Development

Why Our Custom Snowflake ID Collided and How to Build a Reliable Generator

A severe production incident caused duplicate order IDs due to a flawed custom Snowflake implementation, prompting a detailed review of the standard algorithm, identification of critical design mistakes, and a set of practical recommendations for safe, scalable ID generation in distributed back‑end systems.

ID generationJavaSnowflake
0 likes · 8 min read
Why Our Custom Snowflake ID Collided and How to Build a Reliable Generator
Top Architect
Top Architect
Jan 12, 2026 · Backend Development

How to Build a Robust Asynchronous Processing SDK with Spring, Kafka, and XXL‑Job

This article explains the design and implementation of a generic asynchronous processing SDK for Java, covering its purpose, advantages, core principles, component choices, design patterns, configuration via Apollo, usage steps, safety considerations, and provides complete SQL and Spring configuration examples along with a GitHub repository link.

AsynchronousJavaKafka
0 likes · 11 min read
How to Build a Robust Asynchronous Processing SDK with Spring, Kafka, and XXL‑Job