Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

Leveraging MySQL Utilities at Dropbox and Tango

Leveraging MySQL Utilities at Dropbox and Tango

 21 April 12:50 PM - 01:40 PM @ Ballroom E
Experience level: 
Beginner
Duration: 
50 minutes conference
Tracks:
Case Stories
Topics:
MySQL
Devops
Tools and Techniques

Description

The MySQL Utilities from Oracle have been available for some time but how useful are they? In this talk we will cover the various tools available and how we are using then in our shops to reduce our work load , increase efficiency and ensure data consistency. We are all familiar with Percona Toolkit but the MySQL Utilities seem not to be as well known or visible. After hearing this talk you will know more about the utilities and which we find the most useful in each of our environments. We will also offer suggestions for how this toolset can be improved. Overview some of the operations covered: o Database compares o DB copy o DB diff o Using mysqlmetagrep o Using mysqluserclone o mysqlfailover o mysqlrpl* utilities o Many more!

Speakers

David Turner's picture

David Turner

Storage SRE, Uber

Biography:

David Turner joined Uber in 2016. He has more than 10 years experience working with databases such as Oracle and MySQL. He was drawn to MySQL because of his interest in database internals and a deeper understanding of systems architecture. With MySQL he has found he has more freedom to explore. His experience in working at larger shops such as Dropbox, Facebook, Pinterest, Sprint, and Zendesk has given him a strong understanding of scaling issues and of managing massive amounts of data and databases.

Peter Boros's picture

Peter Boros

Storage SRE - databases, Dropbox

Biography:

Peter joined Dropbox's database team in February 2016, has a strong interest in automation and performance tuning. Before joining Dropbox, among many other things, he was Principal Architect at Percona, worked at Sun Microsystems, specialized there in performance tuning and was a DBA at Hungary's largest social networking site. He also taught many Oracle University MySQL courses. He has been using and working with open source software from early 2000s. He currently lives in Dublin, Ireland with his wife and son.

Ben Black's picture

Ben Black

DBA, Tango

Biography:

For the past 15 years, Ben has been a DBA, developer, and Sys Admin working on high volume production systems at Garmin, PalominoDB, and Tango.

Share this talk