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





The interactive transcript could not be loaded.


Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Nov 15, 2017

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.

View the full LISA17 program: https://www.usenix.org/lisa17/program


When autoplay is enabled, a suggested video will automatically play next.

Up next

to add this to Watch Later

Add to

Loading playlists...