MySQL HA with ProxySQL, Consul, and Orchestrator
At VitalSource, we paired with Pythian to design a high-availability system using Orchestrator, consul, and ProxySQL that was specific to our environment. In this talk, I'll cover our architectural decisions and actual implementation that deviates, sometimes wildly, from their suggested solution, such as running Consul in Kubernetes. I'll discuss how we handled custom proxysql consul templates and other challenges we overcame. The presentation will include custom hooks and scripts that we've written. And finally, I'll demo the system that we have stood up.
Covered in the presentation:
- Our architecture and unique challenges
- Custom hooks and scripts