Consistent Reads Using ProxySQL and GTID

Tuesday 3:50PM-4:40PM

@ Room E

MySQL / MariaDB

50 minutes conference

Advanced

Tracks:
Business / Case Studies, Operations

MySQL replication allows you to write on one writer server and easily scale out reads by redirecting reads to reader servers. But how do we guarantee read consistency with their last write? Galera replication can guarantee that, while MySQL Group Replication and standard MySQL async replication cannot.

If you are running MySQL Server or Percona Server, version 5.7 or newer, with GTID enabled, ProxySQL 2.0 is now able to ensure read consistently with the last write. ProxySQL is able to stream GTID information from all the reader servers, and in real-time is able to determine which reader server(s) is able to execute the SELECT statement producing a resultset that is read consistent with the last write (and GTID) executed by each client.

This presentation will show the technical details that allow you to build an architecture with thousands of ProxySQL instances and MySQL servers, and how GTID information is processed in real-time with limited bandwidth footprint.


Speakers

Frédéric Descamps

Frédéric Descamps (Oracle)

MySQL Community Manager

Biography:

Frédéric Descamps is MySQL Community Manager for EMEA & APAC. He joined the MySQL Community Team in May 2016. "@lefred" has been an OpenSource and MySQL consultant for more than 15 years. His favorite topics are High Availability and Performance.


René Cannaò

René Cannaò (ProxySQL)

CEO

Biography:

René founded ProxySQL in 2016 after developing it since 2013. He has over 15 years of experience as Database Administrator mostly on MySQL, working as Senior MySQL Support Engineer at Sun/Oracle, Senior Operational DBA at Blackbird, and consulting for small and large companies like Dropbox. In this period he build an analytic and problem solving mindset, he is always eager to take on new challenges, especially if they are related to high performance.


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