Author

Architect Chen

Sharing over a decade of architecture experience from Baidu, Alibaba, and Tencent.

136

Articles

Likes

586

Views

Comments

Latest from Architect Chen

100 recent articles max

Architect Chen

Jun 12, 2026 · Databases

How to Prevent MySQL Deadlocks in High‑Concurrency Apps: 5 Proven Solutions

The article defines MySQL deadlocks, illustrates how circular lock waits between transactions cause them, and presents five practical mitigation techniques—consistent lock ordering, shortening transactions, optimizing indexes, breaking large SQL statements into smaller batches, and implementing application‑level retry logic—to reduce deadlock occurrences in high‑concurrency environments.

Index OptimizationMySQLconcurrency

0 likes · 5 min read

How to Prevent MySQL Deadlocks in High‑Concurrency Apps: 5 Proven Solutions

Architect Chen

Jun 11, 2026 · Fundamentals

Understanding Java Thread Deadlocks: 5 Common Scenarios and How to Fix Them

The article defines Java thread deadlock, illustrates five typical deadlock patterns with diagrams, shows how they cause threads to wait indefinitely, and presents five practical solutions—including consistent lock ordering, reducing nested locks, shrinking lock scope, using timed locks, and adopting lock‑free designs.

JavaLockPerformance

0 likes · 3 min read

Understanding Java Thread Deadlocks: 5 Common Scenarios and How to Fix Them

Architect Chen

Jun 10, 2026 · Databases

12 Essential MySQL Online Commands Every DBA Should Know

This guide lists the most frequently used MySQL commands for checking version, connections, process lists, killing queries, global status, configuration variables, lock waits, slow‑query settings, table sizes, index information, execution plans, and replication status, each with practical usage scenarios.

DBADatabase AdministrationMySQL

0 likes · 5 min read

12 Essential MySQL Online Commands Every DBA Should Know

Architect Chen

Jun 9, 2026 · Big Data

How Kafka Prevents Duplicate Consumption: Three Main Solutions

The article explains why Kafka does not guarantee exactly‑once delivery and presents three practical approaches—business‑level idempotence, manual offset management, and Kafka’s transaction/EOS features—to reliably avoid duplicate message processing.

ConsumerKafkaOffset Management

0 likes · 4 min read

How Kafka Prevents Duplicate Consumption: Three Main Solutions

Architect Chen

Jun 8, 2026 · Information Security

Complete Guide to Single Sign-On: Principles, Architecture, and Flow

This article explains Single Sign-On (SSO) fundamentals, detailing its three core components—CAS Server, CAS Client, and Browser—illustrating the overall architecture and walking through the complete authentication flow from accessing a service to ticket validation.

ArchitectureAuthenticationSSO

0 likes · 4 min read

Complete Guide to Single Sign-On: Principles, Architecture, and Flow

Architect Chen

Jun 7, 2026 · Databases

Complete 2026 Guide to Redis Commands: Everything You Need to Know

This article offers a comprehensive 2026 overview of Redis commands, organized by function, with clear usage examples, return values, performance notes, and best‑practice recommendations such as avoiding KEYS in production and using SCAN, making it a practical reference for developers and architects.

CacheCommandsHash

0 likes · 6 min read

Complete 2026 Guide to Redis Commands: Everything You Need to Know

Architect Chen

Jun 6, 2026 · Operations

9 Essential Docker Commands for Live Operations

This guide walks through the nine most frequently used Docker commands for online operations, showing how to list containers, view logs, exec into containers, monitor resource usage, inspect details, manage images, restart services, and clean up unused resources, with practical examples and troubleshooting scenarios.

CLIContainer ManagementDocker

0 likes · 6 min read

9 Essential Docker Commands for Live Operations

Architect Chen

Jun 5, 2026 · Databases

Complete 2026 Guide to MySQL Commands: Syntax, Usage, and Best Practices

This article provides a comprehensive, step‑by‑step reference of essential MySQL commands—including connection, database and table creation, data manipulation, schema alteration, and query optimization with EXPLAIN—complete with code examples, parameter explanations, and performance warnings for safe production use.

CRUDDDLDML

0 likes · 6 min read

Complete 2026 Guide to MySQL Commands: Syntax, Usage, and Best Practices

Architect Chen

Jun 4, 2026 · Databases

Comprehensive Guide to MySQL Master‑Slave Replication (Principles, Architecture, Implementation)

This article explains MySQL master‑slave replication in detail, covering its role in high‑availability and read/write separation, the core binlog mechanism, typical one‑master‑multiple‑slaves architecture, and the step‑by‑step data flow from write operations on the master to replay on the replicas.

BinlogDatabase ArchitectureMySQL

0 likes · 4 min read

Comprehensive Guide to MySQL Master‑Slave Replication (Principles, Architecture, Implementation)

Architect Chen

Jun 3, 2026 · Fundamentals

What TPS Threshold Defines High Concurrency? A Complete Guide

The article explains TPS (Transactions Per Second), shows how to calculate it with a concrete example, and outlines industry‑based concurrency tiers—from less than 100 TPS for ordinary systems up to 50,000+ TPS for billion‑level traffic platforms—helping readers understand what counts as high concurrency.

Performance MetricsScalabilityTPS

0 likes · 3 min read

What TPS Threshold Defines High Concurrency? A Complete Guide