How We Learned to Stop Worrying and Read from Replicas

Thursday 4:40 PM - 5:05 PM

@ Hill Country D

PostgreSQLMySQL/MariaDB

25 minutes conference

Intermediate

Tracks:
MySQL, Polyglot Persistence

A standard pattern in scaling relational data access is to use replicas for reads, but this compromises read-after-write consistency. Unfortunately, since many use-cases require stronger consistency guarantees, the pattern is of limited utility. At Box much of our relational data access requires strong consistency for the purposes of enforcing enterprise permissions, but we need to scale too! To address this challenge, we have introduced a novel design pattern and a framework implementing it. This framework, currently used at scale to serve production traffic at Box, utilizes real-time replication position analysis to safely direct traffic that requires strong read-after-write consistency to read-only replicas.


Speakers

Vova Galchenko

Vova Galchenko (Box)

Sr. Manager

Biography:

Vova Galchenko runs the Database & Cache Infrastructure team at Box.


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