A Cloudflare WARP Failure and VPS Recovery Notes

A recovery note from a Cloudflare WARP failure that broke VPS connectivity, with the failure mode and rescue path documented.

May 15, 2024 · 2 min · 420 words · Jack Yu

How to Use the HTTP API in TiDB with TLS Enabled

Many customers have TLS enabled, which is different from the lab environment.

May 22, 2023 · 1 min · 56 words · Jack Yu

How to Deploy a Secure Transparent Gateway

After moving house, there are many more devices at home that need internet access. However, I don’t want to configure a proxy on each device, so I thought of using a transparent…

October 12, 2022 · 3 min · 499 words · Jack Yu

How to Set Up a Minecraft Bedrock Server Using Multipass

Recently, both of my kids have become interested in Minecraft, and some of their peers are also playing it. We previously bought the Switch version, but its online capabilities…

May 2, 2022 · 5 min · 894 words · Jack Yu

How to Create GitHub Verified Commits on a MacBook M1

One day, I impulsively turned on GitHub’s Vigilant mode.

February 12, 2022 · 1 min · 204 words · Jack Yu

How to Play Minecraft (Bedrock Edition) Cross-Platform

During the Chinese New Year holiday, I spent some time at home playing on the Switch with my child, and I ended up purchasing Minecraft (Bedrock Edition). In order to play…

February 3, 2022 · 1 min · 140 words · Jack Yu

How to Compare Data Consistency between MySQL and PostgreSQL

Recently, I encountered a problem where a user wanted to synchronize data from PostgreSQL to TiDB (which uses the same protocol as MySQL) and wanted to know whether the data after…

May 9, 2021 · 3 min · 461 words · Jack Yu

How to Configure a Chinese LaTeX Environment on Windows

Initially, I didn’t think this was something worth writing about, because CTex was previously working smoothly for everyone. However, it turns out that CTex hasn’t been updated…

March 31, 2021 · 3 min · 455 words · Jack Yu

How to Automatically Publish a Blog Using GitHub Actions

In this post, I used Travis to enable automatic blog publishing. However, I recently discovered that Travis does not run automatically anymore (though it works manually). I…

December 16, 2020 · 2 min · 331 words · Jack Yu

How to Implement a Simple Load Using Sysbench

Sysbench is a tool commonly used in database testing. Since version 1.0, it has supported more powerful custom functions, allowing users to conveniently write some Lua scripts to…

December 14, 2020 · 3 min · 499 words · Jack Yu