There is a stigma attached to database proxies when it comes to MySQL. This tutorial hopes to blow away that stigma by showing you what can be done with a proxy designed from the ground up to be performant. That proxy is ProxySQL. In this tutorial we will not only explain how ProxySQL can make your databases (MariaDB, MySQL, Percona Server for MySQL) process more transactions than without a proxy, we will show you how you can leverage ProxySQL to pre-qualify upgrades, test the impact of schema changes, perform seamless failovers, rewrite offensive queries on the fly, and help you install and configure the proxy to manage queries.
René founded ProxySQL in 2016 after developing it since 2013. He has over 15 years of experience as Database Administrator mostly on MySQL, working as Senior MySQL Support Engineer at Sun/Oracle, Senior Operational DBA at Blackbird, and consulting for small and large companies like Dropbox. In this period he build an analytic and problem solving mindset, he is always eager to take on new challenges, especially if they are related to high performance.