Case Study: Deploying a Multi-Region, Highly Available MySQL Architecture

Thursday, November 02, 2017 - 11:00 am11:30 am

Gabriel Ciciliani, OSDB Internal Principal Consultant at Pythian


A customer recently asked us to design a multi region database architecture that allows their application to read by default from a local database instance while writing on a single master region. It would also need an automated way to handle failures on any of the regional database instances by redirecting both, read and write traffic to an available region.

In this session we are going to go through the architecture designed to fulfill the above requirements, what technologies were considered and why ProxySQL was chosen.

We will also also discuss advantages and limitations of the proposed architecture while sharing a few lessons learned in the process.

Open Access Media

USENIX is committed to Open Access to the research presented at our events. Papers and proceedings are freely available to everyone once the event begins. Any video, audio, and/or slides that are posted after the event are also free and open to everyone. Support USENIX and our commitment to Open Access.

Presentation Audio

@conference {207167,
author = {Gabriel Ciciliani},
title = {Case Study: Deploying a Multi-Region, Highly Available MySQL Architecture},
year = {2017},
address = {San Francisco, CA},
publisher = {{USENIX} Association},