Rene Cannao

Rene Cannao

Rene Cannao

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


All Sessions

ProxySQL Use Case Scenarios

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.

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.

Enabling ClickHouse Analytics in Your MySQL Application Using ProxySQL

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

Hands on ProxySQL

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.

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