Hands on ProxySQL
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) 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.