Production Grade ProxySQL in 2021

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? Speakers: René Cannaò and Nick Vyzas – ProxySQL