Frederic Descamps

Frederic Descamps

Frederic Descamps

Community Manager, Oracle

Biography:

Frédéric Descamps is MySQL Community Manager for EMEA & APAC. He joined the MySQL Community Team in May 2016. "@lefred" has been an OpenSource and MySQL consultant for more than 15 years. His favorite topics are High Availability and Performance.


All Sessions

MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial

During this tutorial, attendees will get their hands on virtual machines and migrate standard Master - Slave architecture to the new MySQL InnoDB Cluster (native Group Replication) with minimal down time. After explaining what group replication is and how it works (the magic behind it), we will experiment with multiple use cases to understand MySQL Group Replication. We will also get the attendees more comfortable with this new technology.

During our experiments, we will try to:
- Cleanly stop a node
- Kill a node
- Re-join a node
- Produce conflicts and see how the cluster behaves
- Create data inconsistency
- Recover from full cluster outage

And finally, we will check how we can integrate MySQL InnoDB Cluster with external routing solutions like ProxySQL. We will also see how to use what the cluster exposes to performance_schema and sys schema to make the right choice.

MySQL Document Store: When SQL and NoSQL Live Together ... in Peace!

Starting with MySQL 5.7 a new Document Store feature has been introduced that makes working with JSON documents an integral part of the MySQL experience. The new X DevAPI gives MySQL users the best of both worlds - SQL and NoSQL - and allows an entirely new category of use cases for managing data. It is constantly evolving based on the community feedback and can be run on top of the brand new MySQL InnoDB Cluster feature. This session gives an overview of the Document Store possibilities and we will migrate data from MongoDB to MySQL and finally play with the data using NoSQL and SQL.

Introduction to MySQL InnoDB Cluster

The new MySQL InnoDB Cluster is an out-of-the-box high availability (HA) solution for MySQL 5.7 and later. It combines the MySQL Server, the MySQL Router and the MySQL Shell for an easy-to-use, integrated solution. Setting up and managing the cluster with the new MySQL Shell puts HA into the hands of everybody, making it a core part of every MySQL installation This session starts with a FAQ covering myths and reality about MySQL InnoDB Cluster and then gives a high-level overview of the MySQL InnoDB Cluster feature set, shows how to use it and why there is no excuse to treat HA as an afterthought anymore.

We will also cover the concept of MySQL Group Replication and explain the best practices.

The session ends with an overview of the latest development.

Inexpensive Datamasking for MySQL with ProxySQL - Data Anonymization for Developers

During this session we will cover the last development in ProxySQL to support regular expressions (RE2 and PCRE) and how we can use this strong technique in correlation with ProxySQL's 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.

Percona Live

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863