blog
MySQL & MariaDB Load Balancing with ProxySQL
Proxies are building blocks of high availability setups for MySQL and MariaDB. They can detect failed nodes and route queries to hosts which are still available. If your master failed and you had to promote one of your slaves, proxies will detect such topology changes and route your traffic accordingly. More advanced proxies can do much more: route traffic based on precise query rules, cache queries or mirror them. They can even be used to implement different types of sharding.
Introducing ProxySQL!
Join us for this live joint webinar with ProxySQL’s creator, René Cannaò, who will tell us more about this new proxy and its features. We will also show you how you can deploy ProxySQL using ClusterControl. And we will give you an early walk-through of some of the exciting ClusterControl features for ProxySQL that we have planned.
Date, Time & Registration
Europe/MEA/APAC
Tuesday, February 28th at 09:00 GMT (UK) / 10:00 CET (Germany, France, Sweden)
North America/LatAm
Tuesday, February 28th at 9:00 Pacific Time (US) / 12:00 Eastern Time (US)
Agenda
- Introduction
- ProxySQL concepts (René Cannaò)
- Hostgroups
- Query rules
- Connection multiplexing
- Configuration management
- Demo of ProxySQL setup in ClusterControl (Krzysztof Książek)
- Upcoming ClusterControl features for ProxySQL
Speakers
René Cannaò, Creator & Founder, ProxySQL. René has 10 years of working experience as a System, Network and Database Administrator mainly on Linux/Unix platform. In the last 4-5 years his experience was focused mainly on MySQL, working as Senior MySQL Support Engineer at Sun/Oracle and then as Senior Operational DBA at Blackbird, (formerly PalominoDB). In this period he built an analytic and problem solving mindset and he is always eager to take on new challenges, especially if they are related to high performance. And then he created ProxySQL …
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.
We look forward to “seeing” you there and to insightful discussions!
If you have any questions or would like a personalised live demo, please do contact us.