Back to Webinars

How To Set Up SQL Load Balancing with HAProxy

Baptiste Hassmann
Webinar Replay
Webinar Slides
Please Sign In to View Content
To view the webinar replay video or slides, "How To Set Up SQL Load Balancing with HAProxy", you must be signed in using your Severalnines.com account. If you don't already have an account you can create one in just a couple minutes. Just click on the "Login to View" button below.
Posted in:
SQL Load Balancing HA Proxy MySQL Failure Detection Virtual IP MySQL Cluster Galera Cluster MySQL Replication MaxScale MySQL Proxy ProxySQL

This webinar discusses HA strategies for HAProxy with Keepalived and Virtual IP. It covers the concepts around the HAProxy load balancer, and shows you how to use it with your SQL-based database clusters.

Agenda

  • What is HAProxy?
  • SQL Load balancing for MySQL
  • Failure detection using MySQL health checks
  • High Availability with Keepalived and Virtual IP
  • Use cases: MySQL Cluster, Galera Cluster and MySQL Replication
  • Alternative methods: Database drivers with inbuilt cluster support, MySQL proxy, MaxScale, ProxySQL
ClusterControl
The only management system you’ll ever need to take control of your open source database infrastructure.
Learn more