Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

Rolling out Global Transaction IDs at Dropbox

Rolling out Global Transaction IDs at Dropbox

 19 April 02:20 PM - 3:10 PM @ Ballroom A
Experience level: 
Beginner
Duration: 
50 minutes conference
Tracks:
Case Stories
Topics:
MySQL
Devops
Tools and Techniques

Description

This talk explains why Dropbox considered rolling out global transaction IDs so early. Additionally we discuss the steps involved in deploying such a change across a large fleet, the challenges faced, open issues, and lessons learned during the migration. Overview: o Cluster management o The most common topologies are described and the issues with each are explored as well as Dropbox's replication topology and the reasons we chose it. o How MySQL replication works o Details of the replication flow are explained to help understand why moving to GTIDs is so compelling. o Positional vs GTIDS replication o Both replication architectures are compared, advantages and disadvantages with regard to cluster management as well as backup and recovery. o Roll out o The steps taken to roll out global transaction ids. We didn't do this alone. We reached out to Booking.com and Facebook for input as well as leveraged our relationship with Percona to ensure as smooth a transition as possible. o Issues o All the bumps and bruises we met as we moved from positional to gtid replication. o Where we are now o An update on our environment since we rolled out GTIDs. If you missed this talk at Oracle Openworld here's a second chance.

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.

René Cannaò's picture

René Cannaò

MySQL SRE, Dropbox / ProxySQL

Biography:

René has 10 years of working experience as System, Network and Database Administrator mainly on Linux/Unix platform. In the last 4-5 years his experience was focused mainly on MySQL, working as Senior MySQL Support Engineer at Sun/Oracle and now as Senior Operational DBA at Blackbird, (formerly PalominoDB). In this period he build an analytic and problem solving mindset and he is always eager to take on new challenges, especially if they are related to high performance.

Share this talk


Slides