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

preview_player
Показать описание
Krzysztof Książek, Senior Support Engineer from Severalnines AB delivers their talk, "MySQL Load Balancers - MaxScale, ProxySQL, HAProxy, MySQL Router & nginx - a close up look", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.

Comment 💬, Share 🔗, Like 👍🏻, and Subscribe ✅ to our channel + Turn on the 🔔

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.

📺Subscribe To Our Channel + Turn on the 🔔 and Get More videos about #OpenSource #Databases, #kubernetes and many other things.

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.

You can find more information about #MySQL and Percona Live Online 2020 in these links 👇🏻👇🏻👇🏻

Connect With us on our Social Networks 👇🏻👇🏻👇🏻
Рекомендации по теме
Комментарии
Автор

It's a great video I need your help in terms of documentation or step by step video at the earliest please
I have a case like this
Haproxy is configured with mysql1 and mysql2

Server1 Haproxy
Server 2 mysql
Server 3 mysql

The condition is readonly acess for Server 2( mysql) and read and write acess for Server 3 (mysql)

How to configure it I need step by step 😌 please

honeysatwika