How SurveyMonkey uses Ansible to manage its MySQL fleet
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.
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.
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.
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.