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 5, 2026 · Backend Development

Reverting Mistaken Commits Locally and Remotely with IntelliJ IDEA

This guide explains how to revert mistakenly pushed code by either manually comparing and deleting unwanted changes or using IntelliJ IDEA's Git reset options (soft, mixed, hard, keep) followed by a force push, ensuring both local and remote repositories return to a specific commit.

Force PushGitintellij-idea
0 likes · 6 min read
Reverting Mistaken Commits Locally and Remotely with IntelliJ IDEA
Top Architect
Top Architect
Jan 3, 2026 · Databases

How to Safely Add a Column to a Billion‑Row Order Table Without Downtime

When a core order table with tens of millions of rows needs a new business field, executing a plain ALTER TABLE can lock the table and disrupt services, so the article explores master‑slave switching, online schema‑change tools, extension tables, JSON fields, and a clever reuse of an existing redundant column to achieve the change with minimal risk.

DDLJSONMySQL
0 likes · 9 min read
How to Safely Add a Column to a Billion‑Row Order Table Without Downtime
Top Architect
Top Architect
Jan 2, 2026 · Backend Development

Mastering Apollo Config Center: Dynamic Spring Boot Configuration from Basics to Kubernetes Deployment

This comprehensive guide walks you through the fundamentals, architecture, and key features of Ctrip's Apollo configuration center, then shows step‑by‑step how to create a Spring Boot client, manage environments, clusters, and namespaces, and finally package and deploy the application on Kubernetes with live configuration updates.

ApolloConfiguration ManagementKubernetes
0 likes · 27 min read
Mastering Apollo Config Center: Dynamic Spring Boot Configuration from Basics to Kubernetes Deployment
Top Architect
Top Architect
Jan 2, 2026 · Databases

Boost MySQL Performance: Master Pagination, Indexes, JOINs, and Query Rewrite Techniques

This article walks through common MySQL performance pitfalls such as inefficient pagination, implicit type conversion, costly UPDATE/DELETE subqueries, mixed sorting, and EXISTS clauses, and demonstrates practical rewrites—including index usage, JOIN conversion, condition push‑down, early LIMIT, and WITH‑clauses—to transform slow queries into millisecond‑level executions.

MySQLPaginationQuery Rewrite
0 likes · 13 min read
Boost MySQL Performance: Master Pagination, Indexes, JOINs, and Query Rewrite Techniques
Top Architect
Top Architect
Jan 1, 2026 · Backend Development

Why Overusing If‑Else Breaks Your Backend and How a Flow Engine Fixes It

The article explains how excessive if‑else branching in business‑centered back‑ends leads to tangled, hard‑to‑maintain code, and demonstrates how a flow‑engine combined with plugin extensions can isolate business logic, improve extensibility, and simplify testing, using the open‑source MemberClub project as a concrete example.

SpringBootbackend architectureflow engine
0 likes · 9 min read
Why Overusing If‑Else Breaks Your Backend and How a Flow Engine Fixes It
Top Architect
Top Architect
Jan 1, 2026 · Backend Development

Spring Boot 4.0 & Spring Framework 7: Deep Dive into New Features and Migration Guide

Spring Boot 4.0 and Spring Framework 7 introduce a comprehensive overhaul—including Jakarta EE 11, JDK 25, JSpecify null‑safety, Project Leyden AOT, declarative HTTP clients, Jackson 3, native API versioning, built‑in resilience, OpenTelemetry, and a dual‑track Spring AI roadmap—providing developers with a modern, cloud‑native Java stack.

AIJavaSpring Boot
0 likes · 9 min read
Spring Boot 4.0 & Spring Framework 7: Deep Dive into New Features and Migration Guide
Top Architect
Top Architect
Dec 29, 2025 · Databases

Why Top Companies Prefer PostgreSQL Over MySQL: A Deep Technical Comparison

The article examines why leading Chinese tech firms are increasingly adopting PostgreSQL instead of MySQL, detailing PostgreSQL‑based products, comparing data‑type support, sequence handling, extensions, monitoring tools, replication mechanisms, licensing, community openness, and MVCC implementation, while also outlining MySQL's limitations.

Database comparisonMySQLPostgreSQL
0 likes · 11 min read
Why Top Companies Prefer PostgreSQL Over MySQL: A Deep Technical Comparison
Top Architect
Top Architect
Dec 28, 2025 · Backend Development

Why FastExcel Is the Next‑Gen High‑Performance Excel Library for Java Developers

FastExcel, a Java library born from the discontinuation of EasyExcel, offers seamless migration, MIT‑licensed open‑source code, and dramatic performance gains for processing massive Excel files, while also introducing innovative features like selective row reading and Excel‑to‑PDF conversion, and it paves the way for the AI‑driven database tool Chat2DB.

Chat2DBEasyExcelExcel
0 likes · 18 min read
Why FastExcel Is the Next‑Gen High‑Performance Excel Library for Java Developers
Top Architect
Top Architect
Dec 25, 2025 · Backend Development

Auto‑Inject UserId and OrderId into Logs with Spring AOP and MDC

This guide shows how to eliminate manual logging of user and order identifiers in a Java e‑commerce system by declaring log placeholders, storing values in ThreadLocal, and using a custom @UserLog annotation with Spring AOP to automatically populate MDC variables for Log4j2.

AOPAnnotationJava
0 likes · 9 min read
Auto‑Inject UserId and OrderId into Logs with Spring AOP and MDC