MySQL to Cassandra: Big Data, High Scale, Data Migration... Oh My!
Bazaarvoice has over 100 million of pieces of user generated content in our MySQL instances, and serves billions of page views every month to hundreds of millions of unique users across thousands of different web sites across the Internet. After nearly eight years of growth the company is poised to open up this content to a host of new brands and retailers, but faced the daunting challenge of merging all of this content into one data infrastructure that would scale both reads and writes horizontally as we continue to grow.
This session will talk about a number of the lessons learned as we have moved from multiple cluster MySQL and Solr infrastructure to a new multi-master Cassandra and ElasticSearch based data storage system.
As Chief Technology Officer and Executive Vice President of Engineering, Scott Bonneau is responsible for overseeing the strategic roadmap and building of Bazaarvoice's products and critical infrastructure systems, which serve 10+ billion interactions on average each month. Scott brings more than 13 years of experience in building highly scalable software systems in the enterprise software, consumer internet, and financial services industries to Bazaarvoice, including more than 7 years in senior leadership roles. He has a passion for building robust, scalable technologies and building fast-growing, agile, and innovative engineering teams.
Prior to joining Bazaarvoice in early 2011, Scott spent nearly 4 years at Google in engineering leadership roles under the AdWords product umbrella. While at Google, Scott built teams and technologies on Google's most substantial revenue generating product line and was recognized internally as both a technology and team-building innovator. Scott has also held senior leadership and individual contributor roles at RGM Advisors, a high-frequency securities trading company, Lombardi Software (acquired by IBM), MessageOne (acquired by Dell), and Trilogy Software.
Scott graduated Cum Laude from Rensselaer Polytechnic Institute in Troy, NY with a bachelor's of science degree in Computer Science. Outside of the office, Scott is a touring guitarist, having recorded multiple studio albums and played on stages across the country. He enjoys spending time with his three young children, playing poker, and being an avid video gamer.