Vitor Oliveira

Designing and operating high-performance, efficient, manageable and reliable MySQL replication deployments requires knowledge of the intricacies of the underlying technologies. MySQL Replication is no exception to this rule, even if it is becoming simpler to manage and operate by every release.

This session will provide insights on the main areas that affect the performance of Asynchronous Replication and Group Replication, and how to configure them to make the most out of the underlying computing system. We will also demonstrate the practical improvements that can be seen by going through various benchmarks. You will then understand when and how it would apply to your usage, allowing you to provide a better MySQL database service. Join us for an interesting dive into the always exciting world of MySQL Replication performance.

MySQL Group Replication brings together group communication techniques and database replication to build a resilient, highly available database service. Fault-tolerance comes, however, at the cost of complexity and extra work that the system itself has to do.

In this session, we will look at how Group Replication performs and how it can meet the most demanding performance requirements. We will also bring forth a few tips and guidelines to configure and manage it in the most optimal way. These may help you to set it up efficiently and meet your infrastructure requirements. At the end of the session you will have learned how to make the most out of the Group Replication plug-in in terms of HA while achieving good performance overall.