Niu Liu

Jul 5, 2026 · Databases

How to Build a MySQL Protocol Server from Scratch for the DSP Database

This article walks through the complete implementation of a MySQL‑compatible front‑end protocol in the DSP (Sloth) database, covering why MySQL compatibility matters, Netty pipeline design, packet framing, three‑step handshake, two‑level command routing, result‑set encoding, length‑encoded integers, variable substitution, and current limitations.