Mar 22, 2013
 Percona Live University - Toronto
  Peter Boros

This talk is an introduction to load balancing between MySQL servers. The talk shows techniques which can be used in general, however we will focus on practical examples using HaProxy. The talk will cover the following topics.

- Load balancing a set of servers which are using master-slave replication.

- Load balancing in MySQL Cluster (ndbcluster).

- Load balancing in Percona XtraDB Cluster.

- Writing custom checks.

- Example scenarios using custom checks.



About the Author

Peter Boros

Peter joined the European consulting team in May 2012. Before joining Percona, among many other things, he worked at Sun Microsystems, specialized there in performance tuning and was a DBA at Hungary's largest social networking site. He also taught many Oracle University MySQL courses. He has been using and working with open source software from early 2000s. Peter's first and foremost professional interest is performance tuning. He currently lives in Herceghalom, Hungary with his wife and son.