Rolling out Global Transaction IDs at Dropbox
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.
Storage SRE, Uber
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.
MySQL SRE, Dropbox / ProxySQL
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.