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.
Kenny is a MySQL expert with a lot of experience in performance and architecture. While he has focused on MySQL and automation for over a decade, he has also developed expertise in other areas. He's a well-rounded, multidimensional nerd who is skilled in many things: making a coffee on the side of a mountain, electrical building codes for single family dwellings in the US, the perfect ratio of cumin and asafoetida in tadka dal, and providing occupational therapy to a shy rabbit named Winston. He's adept at talking, so don't feel the need to limit in-session questions to MySQL.
"@lefred" has been consulting OpenSource and MySQL for over 15 years. After graduating in Management Information Technology, Frédéric Descamps started his career as a developer for an ERP under HPUX. He will then opt for a career in the world of open-source by joining one of the first Belgian start-up dedicated 100% to free projects around GNU/Linux. It is in 2011 that lefred joined Percona, one of the leading MySQL-based specialists. He decided to join the MySQL Community Team in 2016 as a MySQL Community Manager for EMEA & APAC. Frédéric is also a regular speaker of OpenSource Conferences. His blog mostly dedicated to MySQL is http://lefred.be