Firebird Wire Protocol Carlos Guzman Alvarez, Mark Rotteveel Version 0.15, 26 December 2021 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 5.1.1. Deviations for protocol version 11 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 5.2.1. Deviations for protocol version 11 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Serge Klochkov (Integrations Team) 31 October 2023 Agenda Motivation and Context 01 MySQL Wire Protocol Compatibility 02 MySQL SQL Dialect Compatibility 03 2 Motivation 3 ClickHouse and Other Databases not like that. MySQL user’s password has to be encrypted with Double SHA1 What does “MySQL Wire Protocol” mean? 6 ● TCP Connection ● MySQL authentication support ● Incoming command packets handler Result set protocols - text and binary * https://dev.mysql.com/doc/dev/mysql-server/latest/PAGE_PROTOCOL.html How it started … 7 What is “command \x16”? ? QuickSight Tableau Online How it started

.............................................................. 1529 47.3. Streaming Replication Protocol Interface .............................................. 1531 xi PostgreSQL 17beta1 Documentation ..................................................................... 2384 53. Frontend/Backend Protocol ........................................................................... 2385 53.1. Overview Documentation 53.4. Streaming Replication Protocol ........................................................... 2402 53.5. Logical Streaming Replication Protocol ........................................

.............................................................. 1610 47.3. Streaming Replication Protocol Interface .................................................... 1612 47.4. Logical Decoding SQL Interface ..................................................................... 2523 53. Frontend/Backend Protocol ................................................................................. 2525 53.1. Overview .... 2541 53.4. Streaming Replication Protocol ................................................................. 2542 53.5. Logical Streaming Replication Protocol .....................................

.......................... 1492 xi PostgreSQL 16.1 Documentation 49.3. Streaming Replication Protocol Interface .............................................. 1493 49.4. Logical Decoding SQL Interface ..................................................................... 2325 55. Frontend/Backend Protocol ........................................................................... 2327 55.1. Overview ....... 2342 55.4. Streaming Replication Protocol ........................................................... 2343 55.5. Logical Streaming Replication Protocol ........................................

.............................................................. 1573 49.3. Streaming Replication Protocol Interface .................................................... 1575 49.4. Logical Decoding SQL Interface ..................................................................... 2452 55. Frontend/Backend Protocol ................................................................................. 2454 xviii PostgreSQL .... 2469 55.4. Streaming Replication Protocol ................................................................. 2471 55.5. Logical Streaming Replication Protocol .....................................

.....................................................................1926 48. Frontend/Backend Protocol................................................................................................ ..............................................................1939 48.3. Streaming Replication Protocol.................................................................................1940 48.4. Message ............................................................1962 48.7. Summary of Changes since Protocol 2.0...................................................................1964 49. PostgreSQL Coding

.....................................................................1812 48. Frontend/Backend Protocol.............................................................................................1813 ..............................................................1825 48.3. Streaming Replication Protocol..........................................................................1825 48.4. Message Data ............................................................1846 48.7. Summary of Changes since Protocol 2.0............................................................1847 49. PostgreSQL Coding Conventions

.....................................................................1861 46. Frontend/Backend Protocol................................................................................................ ..............................................................1874 46.3. Streaming Replication Protocol.................................................................................1874 46.4. Message ............................................................1895 46.7. Summary of Changes since Protocol 2.0...................................................................1896 47. PostgreSQL Coding

.....................................................................1744 46. Frontend/Backend Protocol.............................................................................................1745 ..............................................................1756 46.3. Streaming Replication Protocol..........................................................................1757 46.4. Message Data ............................................................1776 46.7. Summary of Changes since Protocol 2.0............................................................1777 47. PostgreSQL Coding Conventions