MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial (Part 2)
During this tutorial, attendees will get their hands on virtual machines and migrate standard Master - Slave architecture to the new MySQL InnoDB Cluster (native Group Replication) with minimal down time. After explaining what group replication is and how it works (the magic behind it), we will experiment with multiple user cases to understand MySQL Group Replication, and make the attendees more comfortable with this new technology: During our experiments, we will try: - to cleanly stop a node - to kill a node - to re-join a node - to produce conflicts (like bfa and cf) and see how the cluster behaves - to create data inconsistency - to experiment wrong practices like replication filters And 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.
Senior MySQL Product Manager, Oracle
Matt Lord is a Senior Product Manager in the MySQL group at Oracle. He has over 20 years of database and application development experience with MySQL, Oracle, and Sybase using a wide array of programming languages in a variety of UNIX and MS Windows based environments. He has spent the last 13 years working for MySQL, the first year in the Training department and the subsequent 9 years within the Support team, before finally moving to Product Management where one of his primary focuses today is on making MySQL a natively distributed and highly available database that's easy to operate at scale.
MySQL Practice Manager, Percona
Kenny is currently MySQL Practice Manager at Percona.
MySQL Community Manager, Oracle
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.