High Availability in ProxySQL

René Cannaò
Webinar Replay
Webinar Slides
Please Sign In to View Content
To view the webinar replay video or slides, "High Availability in ProxySQL", 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.

The proxy layer is crucial when building a highly available MySQL infrastructure; it is therefore imperative to not let it become a single point of failure on its own. And building a highly available proxy layer creates additional challenges, such as how to manage multiple proxy instances,  how to ensure that their configuration is in sync, Virtual IP and fail-over.

In this joint webinar with ProxySQL’s creator, René Cannaò, you will learn about building a solid, scalable and manageable proxy layer using ProxySQL. And we will show you how you can make your ProxySQL highly available when deploying it from ClusterControl.

Agenda

  • Introduction
  • High Availability in ProxySQL
    • Layered approach
    • Virtual IP
    • Keepalived
  • Configuration management in distributed ProxySQL clusters
  • Demo: ProxySQL + keepalived in ClusterControl
    • Deployment
    • Failover
  • Q&A
ClusterControl
The only management system you’ll ever need to take control of your open source database infrastructure.