BestHub
Sign in
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
554
Views
0
Comments
Recent Articles

Latest from Xiao Liu Lab

83 recent articles
Xiao Liu Lab
Xiao Liu Lab
Dec 7, 2025 · Operations

How to Diagnose and Prevent 502 Bad Gateway Errors in an Nginx‑PHP‑MySQL Stack

This article walks through a real‑world 502 outage, explains why the error is rarely a simple gateway failure, shows how to use enhanced Nginx upstream logs and automated scripts to pinpoint timeouts, misconfigurations, and database bottlenecks, and provides concrete tuning, monitoring, and self‑healing measures to stop the problem from recurring.

502MySQLOperations
0 likes · 11 min read
How to Diagnose and Prevent 502 Bad Gateway Errors in an Nginx‑PHP‑MySQL Stack
Xiao Liu Lab
Xiao Liu Lab
Dec 3, 2025 · Databases

Secure, Efficient MySQL Automated Backup Script – Zero Maintenance

This guide presents a fully automated MySQL backup script that securely filters system databases, compresses backups with gzip, logs each operation, automatically removes expired files, and includes step‑by‑step configuration, deployment, scheduling, troubleshooting, and optimization tips for production environments.

BackupDatabaseMySQL
0 likes · 11 min read
Secure, Efficient MySQL Automated Backup Script – Zero Maintenance
Xiao Liu Lab
Xiao Liu Lab
Dec 1, 2025 · Operations

Master WebSocket Debugging with websocat: Install, Test, and Proxy

This guide introduces websocat, a Rust‑based command‑line utility for WebSocket, covering installation via package managers or source, basic echo testing, setting up local servers, bidirectional TCP‑WebSocket proxying, secure connections, performance tuning, and integration with systemd and Nginx.

Command-lineDebuggingProxy
0 likes · 6 min read
Master WebSocket Debugging with websocat: Install, Test, and Proxy
Xiao Liu Lab
Xiao Liu Lab
Nov 30, 2025 · Backend Development

Mastering SSE and WebSocket with Nginx: Complete Configuration Guide

This guide explains the differences between Server‑Sent Events and WebSocket, shows when to choose each technology, and provides step‑by‑step Nginx configuration snippets—including global mapping, SSE and WebSocket location blocks, troubleshooting tips, and a minimal debug setup—to ensure reliable real‑time communication in production.

Real‑time communicationSSEServer Configuration
0 likes · 8 min read
Mastering SSE and WebSocket with Nginx: Complete Configuration Guide
Xiao Liu Lab
Xiao Liu Lab
Nov 27, 2025 · Information Security

Master NPS: Deploy Secure Intranet Penetration with Docker and TLS

This guide explains what NPS (Network Penetration Service) is, why it’s needed, its core advantages, and provides step‑by‑step instructions for deploying the server and client on Linux, Windows, or Docker, configuring TLS, managing tunnels, and troubleshooting common issues.

Docker deploymentNPSNetwork Security
0 likes · 9 min read
Master NPS: Deploy Secure Intranet Penetration with Docker and TLS
Xiao Liu Lab
Xiao Liu Lab
Nov 26, 2025 · Information Security

Why SecureCRT Fails on New Linux and How to Fix It

After upgrading to recent Linux distributions, SecureCRT often cannot establish SSH connections due to disabled legacy algorithms, but the issue can be resolved by updating SecureCRT or manually enabling modern key‑exchange and host‑key types in its settings.

LinuxSSHSecureCRT
0 likes · 4 min read
Why SecureCRT Fails on New Linux and How to Fix It
Xiao Liu Lab
Xiao Liu Lab
Nov 25, 2025 · Cloud Native

Step‑by‑Step Guide to Deploy Harbor 2.14.1 Private Registry with HTTPS and Trivy

This tutorial walks you through installing a private, secure Harbor 2.14.1 container registry on Linux, covering system prerequisites, Docker setup, offline installer download, detailed harbor.yml configuration, firewall adjustments, optional self‑signed certificates, installation scripts, verification, image push testing, common admin commands, production best practices, and troubleshooting tips.

Container RegistryHarborKubernetes
0 likes · 11 min read
Step‑by‑Step Guide to Deploy Harbor 2.14.1 Private Registry with HTTPS and Trivy
Xiao Liu Lab
Xiao Liu Lab
Nov 24, 2025 · Information Security

Why MySQL Returns ‘Plugin Not Loaded’ for One Missing User but ‘Access Denied’ for Another

When logging into a new MySQL 8.4 instance with a non‑existent user, one login attempt yields a "Plugin 'mysql_native_password' is not loaded" error while another returns the usual "Access denied", a difference caused by MySQL's hidden decoy‑user mechanism that randomizes authentication plugins for nonexistent accounts.

DatabaseMySQLPlugin
0 likes · 7 min read
Why MySQL Returns ‘Plugin Not Loaded’ for One Missing User but ‘Access Denied’ for Another