HA and clustering solution: ProxySQL as an intelligent router for Galera and Group Replication

Wednesday 11:20 AM - 12:10 PM

@ Jones


50 minutes conference


Operations, Developer

Both Galera and Group Replication provide clustering solution with virtual synchronous replication. The different replication technologies used by these two products ensure that data is replicated, consistent and safe and that several failure scenarios can be handled maintaining high availability. Although the database layer is highly available, applications rarely know the status of the various nodes in the cluster, therefore sending traffic to the wrong node(s) in a degraded system can lead to a high error rate.
ProxySQL has the ability to regularly check the status of the various nodes in the cluster, and determine which nodes are healthy and where to send traffic.
This session will present how to configure ProxySQL as a middle layer between the application and a clustering solution with either Galera or Group Replication, what algorithms are used to route traffic to the right node(s) and ensure that high availability is achieved even in case of degraded cluster conditions.


René Cannaò

René Cannaò (ProxySQL)



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.


  Download Slides  

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863