Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

How SurveyMonkey uses Ansible to manage its MySQL fleet

How SurveyMonkey uses Ansible to manage its MySQL fleet

 19 April 3:50 PM - 04:40 PM @ Ballroom E
Experience level: 
50 minutes conference
Operations and Management
Tools and Techniques


In this session we will review how the open-source database team at SurveyMonkey uses Ansible as both a configuration management and automation tool for our MySQL fleet. We'll review how we address several challenges: - Simultaneously supporting multiple versions of MySQL (5.1, 5.6, and 5.7) - Managing inherited clusters with configuration inconsistencies - Using Ansible as a configuration management tool - Deploying new clusters with one Ansible run By the end of this session, you'll see how Ansible can be a useful, flexible tool for managing a diverse, complicated MySQL environment, and be inspired to find new ways you can use automation in your environment.


Josh Varner's picture

Josh Varner

Data Infrastructure Engineering Manager, SurveyMonkey


Josh manages the open-source data infrastructure team at SurveyMonkey, working on MySQL and its supporting infrastructure. Prior to SurveyMonkey, Josh was a member of the DBA team at Twitter, working on the distributed column-store database, Vertica, and MySQL. Prior to that, he was a database engineer for a data consultancy, InterWorks.

David Bravant's picture

David Bravant

DBA Manager, SurveyMonkey


David manages the Open Source DB Team at SurveyMonkey. The team is responsible for all open source data stores and associated infrastructure at SurveyMonkey. Prior to this he spent 5 years at Twitter in the DBA Team, joining as only the second DBA and later managing the team. In a previous life he spent many years supporting and running large Oracle DB implementations.

Mark Filipi's picture

Mark Filipi

Senior Database Administrator, SurveyMonkey


Mark's role at SurveyMonkey spans a variety of applications and users that utilize MySQL. Previously at PalominoDB, he worked on everything from startups to video games to presidential elections. Based out of Kansas City, he enjoys very fast internet.

Share this talk