Inexpensive Datamasking for MySQL with ProxySQL - Data Anonymization for Developers Базы данных и системы хранения
René has over 15 years of experience as System, Network and Database Administrator mainly on Linux/Unix platform. In the last 10 years his experience was focused mainly on MySQL, working as Senior MySQL Support Engineer at Sun/Oracle, Senior Operational DBA at Blackbird, and MySQL SRE at Dropbox. 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. From 2013 he is the author on ProxySQL, a high performance and high availability proxy for MySQL solutions.
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.