MySQL high availability & autofailover with ProxySQL & Orchestrator
How do you achieve high availability using MySQL? Master/slave replication has always been the goto strategy, but it is far from a complete solution. In this presentation, we will leverage tools like ProxySQL, Github’s Orchestrator project, and Consul to provide a single endpoint on top of master/slave replica sets that are automatically monitored, where automatic promotion of slaves happens in case of a dead master, where slave servers benefit from autofailover, and where read/write query splitting is abstracted.
Thijs Feryn is a technical evangelist at a Belgian webhosting company called Combell. His goal is to bring technology to the people and people to technology. He focuses on bridging the gap between code and infrastructure. Thijs is also involved in many open source communities and leads the PHPBenelux community. He speaks, listens, writes, codes, teaches, organizes and is above all very excited to speak at Codemotion!