Severalnines Blog
The automation and management blog for open source databases

Webinar Replay & Slides: How To Set Up SQL Load Balancing with HAProxy

Severalnines
July 16, 2014
Posted in: Events

Thanks to everyone who attended and participated in last week’s webinar on ‘How To Set Up SQL Load Balancing With HAProxy’! 

If you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online.

Webinar Replay: How To Set Up Load Balancing with HAProxy

We covered the concepts around the popular open-source HAProxy load balancer, and demonstrated how to use it with your SQL-based database clusters. We also discussed HA strategies for HAProxy with Keepalived and Virtual IP.

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

Watch the Replay

Read the Slides

SPEAKER

Alex Yu, VP Products, Severalnines

ABOUT HAPROXY

HAProxy stands for High Availability Proxy, and is a great TCP/HTTP load balancer. It distributes a workload across a set of servers to maximize performance and optimize resource usage. 

For more information in advance of the webinar, check out our MySQL Load Balancing with HAProxy - Tutorial.

Related Post

How to build a stable MySQL Replication environment

Severalnines
November 29, 2016

During this webinar, participants will learn how to build a production-ready environment with MySQL replication. From OS and DB configuration checklists to schema changes and disaster recovery, they’ll have the information needed to plan and prepare the best setup for their requirements.

Posted in: DB Ops Events

Top 9 Tips for building a production-ready MySQL Replication environment

Severalnines
November 22, 2016

Join our new webinar during which we’ll cover our 9 Top Tips on how to build a stable MySQL Replication environment. From OS and DB configuration checklists to schema changes and disaster recovery,  you’ll have the tips needed for a production-ready replication setup.

Posted in: DB Ops Events

Webinar: Become a MongoDB DBA - Scaling and Sharding

Severalnines
October 27, 2016

In this third webinar of the ‘Become a MongoDB DBA’ series, we will focus on scaling and sharding your MongoDB setup.

Posted in: DB Ops Events MongoDB

Completing the MySQL Query Tuning Trilogy: working with optimizer & SQL tuning

Severalnines
October 27, 2016

This webinar was the third and last part of our webinar trilogy on MySQL Query Tuning, in which we discussed query tuning and related tools. In this trilogy we’ve covered SQL tuning, indexing, the optimizer and how to leverage EXPLAIN to gain insight into execution plans. Part 3 focussed on working with the optimizer and SQL tuning.

Posted in: DB Ops Events