May 30, 2019
 Percona Live Open Source Database Conference 2019
  Ben Mildren, Andrew Moore, Dan Kowalewski

In this session we'll discuss how we use Ansible to manage the internal MySQL services at DigitalOcean, where this has worked well for us, as well as some of the issues we've experienced along the way.

We'll dive into how we use Ansible to manage MySQL, ProxySQL & Orchestrator and other related technologies in our environment, and will discuss topics such as static vs dynamic config management, Ansible performance tuning & anti-patterns, as well as testing strategies.

At the end of this session, you should have a good understanding of how Ansible could help in your environment, as well as the potential limitations you may need to think about.



About the Authors

Ben Mildren

Ben currently works as a Senior Engineer at DigitalOcean, previous roles have included MySQL Practice Manager at Percona, MySQL Team Technical Lead at Pythian, and Senior DBA at Nokia.
 

Andrew Moore

Andrew is a seasoned MySQL professional leading a team of DBAs in the EMEA region for Percona services department. With a background in administering production systems at large scale, Andrew enjoys the challenges that come with that territory. Andrew lives with his young family in Dorset, UK and enjoys the slower pace of life in the British countryside. When not tinkering with MySQL, Andrew is usually trying to Dockerize something.
 

Dan Kowalewski

Daniel has been been designing and deploying solutions around MySQL for over 10 years. He lives for those magic moments where response time drops by 90%, and loves adding more "nines" to everything.