At Letgo we built a 100% fault tolerance platform using technologies such as ProxySQL + Consul + Replication Manager and Puppet.
The idea of this talk would be to explain how is possible to use a highly available platform using those described technologies. ProxySQL will route read and write queries, consul will ensure ProxySQL nodes are available and replication manager will handle failovers if the master goes down.
All those configurations will be deployed using a configuration manager such as Puppet.
After describing all the pieces, the idea is to run a live demonstration.
I am a Linux System Engineer focused on automate infrastructures through configure management tools, design High Availability patterns, scalable procedures and web service tuning. I have 10 years experience as a system administrator always linked with mysql world, specially when I was working at PalominoDB where I was helping DBAs to automate infrastructures and operations tasks.