Professional architects sharing high‑quality architecture insights. Covers high‑availability, high‑performance, high‑stability designs, big data, machine learning, Java, system, distributed and AI architectures, plus internet‑driven architectural adjustments and large‑scale practice. Open to idea‑driven, sharing architects for exchange and learning.
This article explains what MySQL indexes are, how they work, their advantages and drawbacks, the different index types—including primary, ordinary, composite, full‑text, clustered and non‑clustered—and compares B‑Tree with B+Tree structures to help you design faster, more efficient queries.
This article explains how to design custom routing strategies for versioned microservices, including default master branch routing, unified version routing, and service‑specific routing, and shows how to apply these rules to achieve gray deployments with load‑balancing and seamless version isolation.
This article examines the causes and consequences of TCP half‑open and full‑connection queue saturation, explains how the Linux backlog mechanism works, and offers practical solutions for handling listen overloads, drawing on a range of technical references and real‑world troubleshooting experiences.
This article explains how Java handles string literals and the new String() constructor, detailing when objects are created in the string constant pool versus the heap, and demonstrates the resulting reference comparisons with code examples.
This article explains what MySQL indexes are, how they work, their advantages and drawbacks, the different types of indexes—including primary, ordinary, composite, and full‑text—and dives deep into B‑Tree and B+Tree structures, clustering, page organization, and best practices for efficient query performance.
