May 30, 2019
 Percona Live Open Source Database Conference 2019
  Kenny Gryp, Frédéric Descamps

During this tutorial, attendees will get their hands on virtual machines and migrate standard Master-Slave architectures to the new MySQL InnoDB Cluster (native Group Replication) with minimal downtime. After explaining what Group Replication is and how it works (the magic behind it), we will experiment with multiple use cases to understand MySQL Group Replication. We will also get the attendees more comfortable with this new technology and explain all the benefits of the new features we have introduced since 8.0.14 like the different data consistency models supported.

During our experiments, we will try to:
- Cleanly stop a node
- Kill a node
- Re-join a node
- Produce conflicts and see how the cluster behaves
- Create data inconsistency
- Recover from full cluster outage

Finally, we will check how we can integrate MySQL InnoDB Cluster with external routing solutions like ProxySQL. We will also see how to use what the cluster exposes to performance_schema and sys schema to make the right choice.

We will highlight the new improvements made in MySQL 8.0 regarding Group Replication and InnoDB Cluster.



About the Authors

Kenny Gryp

Kenny is a MySQL expert having a lot of experience in performance and architecture.
 

Frédéric Descamps

Frédéric Descamps is MySQL Community Manager for EMEA & APAC. He joined the MySQL Community Team in May 2016. "@lefred" has been an OpenSource and MySQL consultant for more than 15 years. His favorite topics are High Availability and Performance.