The presentation will be a real-life study on how we utilize ProxySQL for connection pooling, database failover and load balancing the communication between our (third party) PHP-application and our master-master MySQL-cluster.
Also, we will show monitoring and statistics using Percona Monitoring and Management (PMM).
ProxySQL is a very powerful tool, with extended capabilities, and we want to show that it?s possible to utilize this to gain functionality (seamless database backend switch) and correct problems (applications missing connection pooling).
Tibi joined Percona in 2015 as a Consultant. Before joining Percona, among many other things, he worked at the world?s largest car hire booking service as a Senior Database Engineer. He enjoys trying and working with the latest technologies and applications which can help or work with MySQL together.
Johan Nilsson is currently working as a MySQL-DBA on a large-scale installation with zero downtime requirements at one of Europe?s largest supplier of smart alarms for homes and small businesses. He started his career as an UNIX systems and network administrator in 1999, and gradually shifted to working with database administration on systems with high uptime demands. This became the main focus in 2008. He also holds a Oracle 11g DBA OCP.