Scaling MySQL with HaProxy

Monday 5:40PM

@ Demo Theater in the Exhibit Hall

MySQL / MariaDB

Lightning Talk



Scaling MySQL infrastructure is challenging, traditional setup don't scale horizontally and require manual configuration management.

This talk is about how we scaled MySQL infrastructure at Indeed. Using HaProxy, we dynamically take backends in/out of rotation based on replication lag. Through this proxy, we load-balance reads across a pool of replicas, ensure replication lag is below a threshold, and easily take replicas out of rotation for maintenance, removing the work of manually updating application's configuration.

You will also learn about different routing strategy we use, such as fail-to-primary vs fail-open, and about surprising application connection pool's behaviors we learned along the way.


Laurent Kolakofsky

Laurent Kolakofsky (



I'm a Site Reliability Engineer at Indeed where get to play with all types of technologies such as load-balancing and service discovery, prior to that I worked in electronic trading solutions for the global financial marketplace. I love distributed systems, automation and databases.


  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(@)
  • +1-888-401-3401
  • +1-919-948-2863