High Availability in ProxySQL

Presented by René Cannaò and Krzysztof Ksiazek
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

Presenters

René Cannaò

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 Ksiazek

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.

Comments & questions

Have any questions? Please, contact us.