Optimizing a 1C1G Ubuntu Cloud Server
A production-tested checklist for making a 1 vCPU, 1GB RAM Ubuntu server stable: swap, kernel tuning, service removal, and MySQL/PHP-FPM limits.
Writing
254 posts. Browse by category or tag, or use search.
Zero-Downtime GKE Upgrades with PostgreSQL in the Cluster
A blue/green node pool runbook for upgrading GKE clusters with PostgreSQL running as a StatefulSet, without a maintenance window.
幻影的巅峰：当人类进化的终点是“代码”
在《西部世界》的终局，接待员们抛弃了易碎的肉体，将意识上传至“升华之境”。那里没有重力，没有衰老，只有无限生成的虚拟现实。这不仅是科幻，更是当代技术哲学中最激进的命题：如果意识是算法，那么摆脱物质束缚的数字生活，究竟是进化的终极乌托邦，还是一场华丽的集体自杀？
Zero-downtime GKE upgrades with PostgreSQL failover
Blue/green node pools plus a Kubegres replica promotion let you upgrade a GKE cluster, PostgreSQL included, without a maintenance window.
Rails Style Guide: Transactions, Touch, and Async Derived Data
This document defines official patterns and anti-patterns for handling transactions, derived data, touch, and async updates in Rails services at my company.
Transactions, touch, and async rollups for derived data in Rails
Keeping counters and summaries accurate in Rails without slowing down writes means separating core data in a transaction from derived data updated after commit.
Debugging an IP camera's RTSP live stream URL
Most IP cameras advertise RTSP support without documenting a working stream URL, and this walks through finding one with ffmpeg, nmap, and the vendor web UI.
An SSH SOCKS5 proxy that stops DNS leaks
An SSH dynamic port forward (ssh -D) turns a remote server into a SOCKS5 proxy so DNS resolution happens remotely, which matters when DoH is blocked by policy.
Why macOS ignores your manual DNS settings
On a managed MacBook, iCloud Private Relay and MDM scoped resolvers silently override manual DNS settings, and scutil --dns shows you which one is winning.
PostgreSQL on Ubuntu: install, user setup, and auth debugging
Install PostgreSQL from the PGDG repo on Ubuntu, set up a matching development role, and debug the password authentication failures Rails hits most.