Frédéric Descamps

In this session we will see how to hack MySQL by extending MySQL Server using the Component Service Infrastructure. We will discover what is it, and how to use it with a practical example written in C++ on how to verify disk space.

Logical dumps are becoming popular again. MySQL Shell parallel dump & load utility changed to way to deal with logical dumps, certainly when using instances in the cloud. MySQL 8.0 released also an awesome physical snapshot feature with CLONE.

In this session, I will show how to use these two ways of saving your data and how to use the generated backup to perform point-in-time recovery like a rockstar with MySQL 8.0 in 2022 !

MySQL Router is part of MySQL InnoDB Cluster and MySQL InnoDB ReplicaSet, but not only.

This piece of software is still unknown by many users but improved a lot during the last year.

In this session, the audience will learn about MySQL Router's REST API. How to enable it and how to use it. We will also see how this API can be integrated into a monitoring solution and I will share my journey dealing with its authentication: I will share my thoughts and best practices.

During this session, I will show how we can start from a single instance to MySQL InnoDB Cluster, the automated HA solution for MySQL, passing by the following architecture:

1. Single MySQL
2. Source / Asynchronous Replica
3. InnoDB ReplicaSet
4. InnoDB Cluster

I will cover the limitations of each options and how to migrate from one to the next one with minimal downtime.

MySQL Shell is a new client for MySQL. It comes with multiple functionalities like the adminAPI commands to setup and operate a MySQL InnoDB Cluster but also check for upgrades, import JSON, parallel import and more... It also allows you to communicate with the MySQL Server in SQL, Python or Javascript ! During this session we will write a plugin from scratch to extend the Shell using the MySQL Shell Plugin Framework. The code will be written live in Python.

Welcome to the FOSDEM MySQL, MariaDB & Friends Devroom 2020

MySQL 8.0 is now also a Document Store where it's very easy to store JSON documents and use CRUD operations. Developers now can deal with their datata without writing a single line of SQL. In this talk, I will show how easy it's for developers to use CRUD operations that allow a cleaner and easier development but also how the DBA can deal with the data and benefits from the power of a RDBMS.

I will illustrate this with examples where we add data/modify data very easily and where we increase the speed of the queries in the background and generate more complicated reports using SQL on the same data.

The best of both worlds in one single product.

Opening the MySQL, MariaDB & Friends Devroom !

Point-in-time recovery can be very long when a large amount of binary logs must be replayed. During this session I will show how this can be accelerated without using any special external tool and how we can benefit from MySQL replication improvements even on a stand-alone server

During this session we will cover the last development in ProxySQL to support regular expressions and how we can use this strong technique in correlation with the query rules to anonymize live data quickly and transparently.

We will explain the mechanism and how to generate these rules quickly. We show live demo with all challenges we got from the Community and we finish the session by an interactive brainstorm testing queries from the audience.

Opening the devroom and welcoming all attendees

The goal of this theoretical presentation if to explain how a transaction is replicated when using Galera.

I discuss about what is certification and group communication explaining how it's performed. I also cover the difference between MySQL 5.6 GTID and Galera GTID.

We always say Galera replication in synchronous... is it really ? Always ? For every steps ?

What are the caveats of such replication ?

After this presentation, the audience should be comfortable with terms like Brute Force Abort, Flow Control, Local Certification Failure... and now what does virtual-synchronous mean.

The plan is to demystify this technology with easy illustrations and analogies.

The goal of this theoretical presentation if to explain how a transaction is replicated when using Galera.

I discuss about what is certification and group communication explaining how it's performed. I also cover the difference between MySQL 5.6 GTID and Galera GTID.

We always say Galera replication in synchronous... is it really ? Always ? For every steps ?

What are the caveats of such replication ?

After this presentation, the audience should be comfortable with terms like Brute Force Abort, Flow Control, Local Certification Failure... and now what does virtual-synchronous mean.

The plan is to demystify this technology with easy illustrations and analogies.

After the nice blog post of Scott Noyes, I decided to dig a bit more on the topic of undelete rows from the binary log.

This is a more detailed 101 session that explain how to find all events to change and show how to deal with that using easy python commands.

We will also see how to un-insert and un-update events.

See https://github.com/lefred/MyUndelete

It also covers different version of MySQL, from 5.5 to 5.6 and MariaDB.

Welcome to the MySQL & Friends Devroom

15 tips to boost your Galera Cluster.

During this presentation, I will show how to implement several stuff that will improve your day-to-day workload.

The points will cover topics like Point in Time Recovery, WAN replication with group segments, Avoiding SST when adding new Percona XtraDB Cluster node, ... the tips will be briefly explained to the audience and then put in practice.

Currently, the covered tips are:

• Point in Time Recovery
• Accelerate XtraBAckup SST
• Move async slave to a new master 5.5
• Move async slave to a new master 5.6
• Allow longer downtime for a node
• Measuring Max Replication Throughput on Percona XtraDB Cluster with wsrep_desync
• Multicast replication
• SSL everywhere
• decode GRA* files
• Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
• Avoiding SST when adding new Percona XtraDB Cluster node
• Play with quorum and weight
• WAN replication with group segments
• Load balancer and TIME_WAIT
• Load balancer and persistent connections

Open and welcome session

select * from greetings join talks where beer not like 'FULL' ;-)