Riding the Binlog: an in Deep Dissection of the Replication Stream

High Availability
22 September 11:20AM - 12:10PM @ Matterhorn 3

Duration: 
50 minutes conference
Binary Logs are the cornerstone of MySQL Replication, but is it fully understood ? To start apprehending this, we can think of the binary logs as a transport for a Stream of Transactions. Traveling from master to slave, sometimes via Intermediate Masters, this stream evolves: it can shrink by the application of filters, can grow by the addition of slave-local transactions, and two streams can merge by the usage of multi-source replication. After presenting the binary logs Stream Model, the different MySQL use-cases will be mapped to the model, which can serve as a validation of the model. After this validation, the model will be used to make prediction on new use-cases/features that could emerge in the future.


Speakers

Senior System Engineer, Booking.com
Since joining Booking.com in October 2013, Jean-François is working on growing the MySQL/MariaDB installations by removing replication bottlenecks (he also works on other engineering problems that are less relevant here).  Some of his latest projects are making Parallel Replication run faster and deploying Binlog Servers.  He also has a good understanding of replication in general and a respectable understanding of InnoDB, Linux and TCP/IP.  Before Booking.com, he worked as a System/Network/Storage Administrator in a Linux/VMWare environment, as an Architect for a Mobile Services Provider, and as a C and Java Programmer in an IT Service Company.  Even before that, when he was learning computer science, J-F studied cache consistency in distributed systems and network group communication protocols.

Slides