Javier Jaramago Fernández

ProxySQL is a MySQL protocol aware, high-performance reverse proxy commonly used in MySQL compatible cloud databases. Thanks to these features, ProxySQL offers an extra layer of flexibility and control otherwise very challenging to achieve when designing and adapting your infrastructure to different workloads. In this talk, we aim to discuss how to use these features for being able to lower your required isolation levels and causality checks in a multi-primary Galera cluster, thus attempting to increase the overall performance of the cluster. We will provide concrete examples, benchmarks and extra points on workload adaptability.

ProxySQL has proven itself as the de-facto standard reverse proxy for MySQL, yet, we are always looking for new features and improvements. During this past year starting with v2.1.0, four new major ProxySQL versions were released, and with them new features of all sorts were introduced, ranging from protocol changes, authentication improvements, clustering improvements, new monitoring features (for Galera, Group Replication, Aurora AWS) to DDOS protection. Join us for a deeper dive on the details of these (and more) new features, what they have to offer and how you can get the most out of them.