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.
Speakers: René Cannaò Javier Jaramago Fernández