Client/Server Protocol

Understand the MariaDB client/server protocol. This section details how clients communicate with the server, including connection, authentication, query execution, and result set handling.

Client/Server Protocol Overview

Protocol Data Types

This page defines the fundamental data types used in the MariaDB client/server protocol, including integers, strings, and binary representations.

MariaDB Protocol Differences with MySQL

Learn about the specific extensions and differences in the MariaDB protocol compared to MySQL, such as extended capability flags and metadata.

Client/Server Protocol Documentation

0 - Packet

Understand the standard packet structure in the MariaDB protocol, including the packet header, length, sequence number, and payload handling.

1 - Connecting

Learn about the connection phase in the client/server protocol. This section details how clients establish initial communication with the server, including handshaking and authentication processes.

2 - Text Protocol

Understand the text protocol in the Server's client/server communication. This section details how SQL commands and results are exchanged as plain text, including command types and packet structures.

3 - Binary Protocol (Prepared Statements)

Understand the binary protocol for prepared statements. This section details how prepared statements are exchanged efficiently between client and server, optimizing performance and security.

4 - Server Response Packets

Understand server response packets in MariaDB's client/server protocol. This section details the various types of packets sent by the server, including OK, Error, and Result Set packets.

Replication Protocol Documentation

Replication Protocol

Understand the replication protocol. This section details how primary and replica servers communicate, exchanging binary log events to ensure data consistency and enable high availability.

_{This page is licensed: CC BY-SA / Gnu FDL}