Xiao Liu Lab
Author

Xiao Liu Lab

An operations lab passionate about server tinkering 🔬 Sharing automation scripts, high-availability architecture, alert optimization, and incident reviews. Using technology to reduce overtime and experience to avoid major pitfalls. Follow me for easier, more reliable operations!

83
Articles
0
Likes
553
Views
0
Comments
Recent Articles

Latest from Xiao Liu Lab

83 recent articles
Xiao Liu Lab
Xiao Liu Lab
Dec 30, 2025 · Databases

How to Diagnose and Fix ClickHouse CPU Spikes in Minutes

This guide walks you through a step‑by‑step process for quickly identifying the cause of high CPU usage in ClickHouse, from emergency triage and precise diagnosis using system tables to practical optimization techniques and a ready‑to‑run monitoring script.

CPUClickHousePerformance
0 likes · 21 min read
How to Diagnose and Fix ClickHouse CPU Spikes in Minutes
Xiao Liu Lab
Xiao Liu Lab
Dec 30, 2025 · Information Security

Why Our New SSL Certificate Caused Handshake Errors and How We Fixed It

After updating a core API's SSL certificate, a partner reported repeated SSLHandshakeException errors, mistakenly labeling the cert as a development version; thorough verification revealed the issue stemmed from an outdated Java trust store lacking the new Sectigo root, leading to a set of concrete remediation steps and best‑practice lessons.

APICertificateJava
0 likes · 15 min read
Why Our New SSL Certificate Caused Handshake Errors and How We Fixed It
Xiao Liu Lab
Xiao Liu Lab
Dec 28, 2025 · Operations

When to Use Async vs Multithreading: A Practical Guide for Ops Teams

This article explains the fundamental differences between asynchronous programming and multithreading, illustrates each with real‑world operations scenarios, outlines their key advantages and pitfalls, compares them in a concise table, and provides step‑by‑step guidance for communication, deployment, and troubleshooting.

ConcurrencyPerformanceasynchronous
0 likes · 12 min read
When to Use Async vs Multithreading: A Practical Guide for Ops Teams
Xiao Liu Lab
Xiao Liu Lab
Dec 24, 2025 · Operations

How to Build a Full‑Featured Zabbix Monitoring Platform with Docker Compose

This step‑by‑step guide shows how to choose Zabbix over other monitoring tools, deploy a complete Zabbix stack with Docker Compose, configure agents on Linux and Windows, set up auto‑discovery, alerts (email, WeChat, escalation), use proxies for distributed monitoring, and optimize performance for enterprise environments.

AlertingDocker ComposeProxy
0 likes · 27 min read
How to Build a Full‑Featured Zabbix Monitoring Platform with Docker Compose
Xiao Liu Lab
Xiao Liu Lab
Dec 23, 2025 · Databases

Mastering Redis Master‑Slave Replication: Core Concepts, Workflow, and Configuration

This article explains how Redis master‑slave replication provides hot backup, read‑write separation, high availability, and horizontal scaling by detailing its three‑stage workflow, full and partial synchronization mechanisms, key configuration options, and practical analogies for clear understanding.

DatabaseHigh AvailabilityRedis
0 likes · 11 min read
Mastering Redis Master‑Slave Replication: Core Concepts, Workflow, and Configuration
Xiao Liu Lab
Xiao Liu Lab
Dec 23, 2025 · Operations

Master Incident Response: Diagnose and Recover Service Outages in 15 Minutes

When a service crashes and users flood you with complaints, following a structured 15‑minute workflow—first narrowing the impact, then probing six layers (network, system, application, data, external services, security), and finally documenting the incident—lets you pinpoint and fix most outages quickly and reliably.

Operationsnetwork debuggingservice recovery
0 likes · 10 min read
Master Incident Response: Diagnose and Recover Service Outages in 15 Minutes
Xiao Liu Lab
Xiao Liu Lab
Dec 21, 2025 · Databases

Master MySQL for Ops: DML/DQL Tricks, Permissions & Transaction Pitfalls

This guide equips MySQL ops engineers with practical DML/DQL commands, permission management, transaction handling, and common pitfalls, offering step‑by‑step examples, performance tips and safety checklists to ensure reliable database maintenance and troubleshooting.

Database operationsMySQLPermissions
0 likes · 27 min read
Master MySQL for Ops: DML/DQL Tricks, Permissions & Transaction Pitfalls
Xiao Liu Lab
Xiao Liu Lab
Dec 18, 2025 · Operations

scp vs rsync: Choose the Right Tool for Fast, Efficient File Transfers

This guide explains the fundamental differences between scp and rsync, outlines their mechanisms, advantages, and drawbacks, provides practical command examples for various scenarios, highlights common pitfalls, and offers a concise comparison table to help operations engineers select the appropriate tool for secure and efficient file transfers.

LinuxOperationsfile transfer
0 likes · 10 min read
scp vs rsync: Choose the Right Tool for Fast, Efficient File Transfers