Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Inexpensive Datamasking for MySQL with ProxySQL - data anonymization for developers

Inexpensive Datamasking for MySQL with ProxySQL - data anonymization for developers

 27 April - 11:00 AM - 11:50 AM @ Ballroom F
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Operations
Developer
Topics:
MySQL
Tools and Techniques
Programming

Description

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.

Speakers

Frédéric Descamps's picture

Frédéric Descamps

MySQL 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.

René Cannaò's picture

René Cannaò

MySQL SRE, Dropbox / ProxySQL

Biography:

René has 10 years of working experience as System, Network and Database Administrator mainly on Linux/Unix platform. In the last 4-5 years his experience was focused mainly on MySQL, working as Senior MySQL Support Engineer at Sun/Oracle and now as Senior Operational DBA at Blackbird, (formerly PalominoDB). In this period he build an analytic and problem solving mindset and he is always eager to take on new challenges, especially if they are related to high performance.

Share this talk