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 @gabocic
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.