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.

Gabriel Ciciliani, OSDB Internal Principal Consultant at Pythian

Gabriel has been dedicated to databases as a DBA and consultant for the last 10 years. He has lead and participated in multiple projects across many technologies, including Oracle, MySQL, SQL Server and MongoDB. Gabriel defines himself as an automation super fan, he is one of the developers of the MySQL/MongoDB DBaaS solution currently in use in MercadoLibre, the largest e-commerce platform in Latin America and top ten world wide. Gabriel holds a college degree in electronics, a degree in industrial engineering and he is currently studying for his masters in systems information engineering. He is also an Oracle, AWS and Microsoft certified professional. Currently he is a Internal Principal Consultant at Pythian specializing in MySQL and MongoDB.

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.

@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},
month = oct

Presentation Video 

Presentation Audio