MySQL Character Set Implementation: From System Tables to Source Code

This article explores MySQL character set implementation by analyzing system tables (CHARACTER_SETS and COLLATIONS) in information_schema and tracing internal source code structures like CHARSET_INFO, initialization logic, and client connection handling.

Character SetClient-Server ProtocolDatabase Internals

0 likes · 6 min read

MySQL Character Set Implementation: From System Tables to Source Code

System Architect Go

Dec 20, 2020 · Databases

Understanding the MySQL Client/Server Protocol: Connection and Replication

This article explains the MySQL client‑server communication protocol, detailing the connection phase—including handshake, authentication, and packet structure—as well as the replication process, covering registration as a slave, binlog streaming, and the various binlog event types and their formats.

BinlogClient-Server ProtocolHandshake

0 likes · 12 min read

Understanding the MySQL Client/Server Protocol: Connection and Replication