Anyone looking for a high availability master-slave management solution for MySQL may come across ProxySQL and Orchestrator. This combination of products solves many problems, but still requires some manual labour when the configuration changes, when there is a network split and other scenarios. In this talk I will discuss the standard architecture, the solutions it provides and what it's missing. I will then share an automation solution developed at Wix, that solves those problems using Consul, to combine everything together.
Avi is a DBA at Wix.com, website builder platform and home of over 100M websites. He is a firm believer in a developer-centric culture and automation. Avi has 13 years of DBA experience including design, development and implementation of many mission critical databases.