MySQL & MariaDB load balancing with ProxySQL & ClusterControl: introduction webinar

René Cannaò
Webinar Replay
Webinar Slides
Please Sign In to View Content
To view the webinar replay video or slides, "MySQL & MariaDB load balancing with ProxySQL & ClusterControl: introduction webinar", 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.

Proxies are building blocks of HA setups for MySQL & 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 be even used to implement different types of sharding.

Introducing ProxySQL!

In this joint webinar with ProxySQL’s creator, René Cannaò, we discuss this new proxy and its key features. We show you how you can deploy ProxySQL using ClusterControl. And we give you an early walk-through of some of the  exciting ClusterControl features for ProxySQL that we have planned for its next release.

Agenda

  1. Introduction
  2. ProxySQL concepts (René Cannaò)
    • Hostgroups
    • Query rules
    • Connection multiplexing
    • Configuration management
  3. Demo of ProxySQL setup in ClusterControl (Krzysztof Książek)
  4. Upcoming ClusterControl features for ProxySQL
ClusterControl
The only management system you’ll ever need to take control of your open source database infrastructure.