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.
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.
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.
Kenny is currently MySQL Practice Manager at Percona.