Faster MySQL replication using row dependencies

Tuesday 5:55 PM - 6:20 PM

@ Jones

MySQL/MariaDB

25 minutes conference

Intermediate

Tracks:
Case Studies/Use cases, Operations

Lag in asynchronous replication is proportional to the gap in throughput between the master and slave. While a great deal of work has been done to make masters faster on multi-core machines, slaves have been left behind. Today, the master-slave throughput gap is essentially a parallelism gap. Parallel application of a serial log of transactions is not trivial.

In this work, our aim was to match the slave's throughput with the master's instead of just making it 'X' times faster. We use information already present in row based binary logs to extract fine-grained dependencies between row mutations which enables the slave to schedule transactions to multiple threads just like the master would have. We also explore how we can relax the transaction execution model on the slave to make them more lightweight and boost single threaded performance.


Speakers

Abhinav Sharma

Abhinav Sharma (Facebook Inc.)

Software Engineer

Biography:

I'm a Software Engineer in the Database Engineering team at Facebook. My main focus is making cross-datacenter replication faster and more reliable.


Slides



  Download Slides  

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA