In this demo, we will showcase how to perform master switching and failover using MySQL/MariaDB Replication Manager (MRM), a project to manage high availability in replicated database environments. We will review the various features of the MRM dashboard and how it integrates seamlessly with software such as ProxySQL to handle database traffic redirection. Finally we will describe several failover scenarios (in-sync, semi-sync, loss of data) and explain the approaches taken in MRM design in order to enforce best practices and achieve data consistency as much as possible.
Guillaume is an independant consultant and software developer. Previously he led the Remote DBA team at MariaDB and provided consulting services to various startups. His favorite topics are MySQL, Nginx, Golang, Elasticsearch, MongoDB among others.