Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

MySQL Load Balancers - MaxScale, ProxySQL, HAProxy, MySQL Router & nginx - a close up look

MySQL Load Balancers - MaxScale, ProxySQL, HAProxy, MySQL Router & nginx - a close up look

 5 October 11:20 AM - 12:10 PM @ Zürich 1
Experience level: 
Advanced
Duration: 
50 minutes conference
Tracks:
Operations and Management
MySQL
Topics:
MySQL
Tools and Techniques
High Availability

Description

Load balancing MySQL connections and queries using HAProxy has been popular in the past years. Recently however, we have seen the arrival of MaxScale, MySQL Router, ProxySQL and now also Nginx as a reverse proxy. For which use cases do you use them and how well do they integrate in your environment? This session aims to give a solid grounding in load balancer technologies for MySQL and MariaDB. We will review the wide variety of open-source options available: from application connectors (php-mysqlnd, jdbc), TCP reverse proxies (HAproxy, Keepalived, Nginx) and SQL-aware load balancers (MaxScale, ProxySQL, MySQL Router), and look at what considerations you should make when assessing their suitability for your environment. We will also look into the best practices for backend health checks to ensure load balanced connections are routed to the correct nodes in several MySQL clustering topologies. This session should give a good understanding of how the different options compare, and enough knowledge to decide which ones to explore further.

Speakers

Krzysztof Książek's picture

Krzysztof Książek

Senior Support Engineer, Severalnines AB

Biography:

Krzysztof Książek, Senior Support Engineer at Severalnines, is a MySQL DBA with experience managing complex database environments for companies like Zendesk, Chegg, Pinterest and Flipboard. He has presented at Percona Live and similar industry events before and is the main author of the Become a MySQL DBA blog & webinar series at Severalnines.

Share this talk


Slides