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.
ProxySQL aims to be the most powerful proxy in the MySQL ecosystem. It is protocol-aware and able to provide high availability (HA) and high performance with no changes in the application, using several built-in features and integration with clustering software.
During this session we will quickly introduce its main features, so to better understand how it works. We will then describe multiple use case scenarios in which ProxySQL empowers large MySQL installations to provide HA with zero downtime, read/write split, query rewrite, sharding, query caching, and multiplexing using SSL across data centers.
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.
ClickHouse is an open source column-oriented database management system capable of real time generation of analytical data reports using SQL queries.
Acting as a data bridge between MySQL protocol and ClickHouse protocol, ProxySQL now enables MySQL clients to execute queries in ClickHouse through it.
In this session we will show how to configure ClickHouse as a backend for ProxySQL, and how a MySQL client (for example in PHP) will be able to execute data reports in ClickhHouse
ProxySQL is an open source proxy for MySQL that is able to provide HA and high performance with no changes in the application, using several built-in features and integration with clustering software. Those are only a few of the features you'll learn about in this hands on tutorial.