ProxySQL Adaptive query routing based on GTID tracking

Wednesday 4:30 PM - 4:55 PM

@ Jones

MySQL/MariaDB

25 minutes conference

Intermediate

Tracks:
Operations, Developer

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 consistently 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

Nick Vyzas

Nick Vyzas (ProxySQL)

Senior DBA / ProxySQL Developer

Biography:

Currently a senior MySQL DBA & ProxySQL developer. Activities include operational DBA tasks, Ansible automation, Python scripting, C/C++ development of ProxySQL and maintaining the CI/CD ProxySQL build environment. Over the last 15 years my focus has been on open source software implementation and integration at various companies around the world... in addition to drinking colossal quantities of coffee. Yes, I take my coffee very, very seriously.


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