Video details

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

10.29.2017 at LISA

San Francisco

Gabriel Ciciliani (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.