Brussels / 4 & 5 February 2017


Miklos Mukka Szel

Photo of Miklos Mukka Szel

Scalability without automation can be tricky even in the cloud. Ansible is an excellent tool if you want to install, configure, and manage many servers at once.

During the presentation we'll build a fully working environment with Ansible, MHA and ProxySQL.

Attendees will gain insight into how to leverage Ansible plays to automate many tasks for managing a highly available MySQL environment with the ability of read/write split, load balancing, on-the-fly query rewrite(ProxySQL). We're going to demonstrate scenarios like: - Building HA environment in 3 minutes - ProxySQL auto dynamic config generation with Ansible - failover without losing a single SELECT

A fully working Ansible playbook will be available for the attendees running in Docker

About me: Miklos is a Senior Engineer/DBA at Edmodo with 15 years experience in System and Network Administration. He is a MySQL user since version 3.23 and this was his main professional interest in the last 5 years. Previously he worked for Pythian/PalominoDB as a Senior MySQL Consultant and Walt Disney Intl as the main MySQL DBA and he was responsible for the performance of hundreds of sites.

DAMP: Docker is the component that makes the whole environment portable (only bash and Docker needed to set it up) Ansible is an agentless config management system that makes the whole setup automated and painless ProxySQL is a rising star on MySQL's horizon giving full control to DBAs over queries before they hit the DBs. MHA is an proven MySQL HA solution that's easily customizable

My aim with this demo/repo is to show people how easy to set up a test environment with to test a really good MySQL HA/Proxy solution.



Title Day Room Track Start End
Painless MySQL HA, Scalability and Flexibility
With Ansible, MHA and ProxySQL
Saturday H.1309 (Van Rijn) MySQL and Friends 14:35 14:55