Utilizing ProxySQL for Connection Pooling in PHP

Tuesday 2:20PM-3:10PM

@ Swift Suite 1

MySQL / MariaDBOpen Source Databases

50 minutes conference

Intermediate

Tracks:
Developer, Operations

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).


Speakers

Tibor Korocz

Tibor Korocz (Percona)

Architect

Biography:

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

Johan Nilsson (Verisure)

System Specialist

Biography:

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.


Slides



  Download Slides  

Percona Live

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
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA