Welcome to Percona Live Online 2021
Online Open Source Database Conference
Back To Schedule
Thursday, May 13 • 09:00 - 10:00
Production Grade ProxySQL in 2021

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.

Widespread adoption of ProxySQL, the high performance, high availability, protocol-aware proxy for MySQL has lead to a plethora of different and highly innovative solutions for the inevitable scalability issues that MySQL DBAs run into with highly demanding workloads and the fast paced data growth of this modern era.

This talk aims to provide insights into real world MySQL scalability solutions implemented using ProxySQL by deep diving into the key areas to focus on when rolling out ProxySQL in production, examples on how to bulletproof the failover process and many other pertinent tuning recommendations.

- Where should I deploy ProxySQL?
- What hardware does ProxySQL need to run on?
- What does a typical production grade deployment look like?
- How should I design my ProxySQL query rules to ensure an efficient yet granularly controlled ruleset?
- What are the steps in planning a failover process?
- What should I do to achieve a transparent failover?
- What are the key variables I must tune on my production deployment?

avatar for Rene Cannao

Rene Cannao

René has over 2 decades of experience as System, Network and Database Administrator, focusing mainly on MySQL. 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... Read More →

Nick Vyzas

Nick focuses on maximizing the scalability, availability, and performance of MySQL environments of all shapes and sizes with ProxySQL. Over the last 15 years his focus has been on MySQL database administration and open source software projects at various companies around the world... Read More →

Thursday May 13, 2021 09:00 - 10:00 EDT
Room #1