MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial

Monday 1:30PM-4:30PM

@ Swift Suite

MySQL / MariaDB

3 hours tutorial

Beginner

Tracks:
Operations

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 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

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.


Speakers

Frederic Descamps

Frederic Descamps (Oracle)

Community Manager

Biography:

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 Gryp

Kenny Gryp (Percona)

MySQL Practice Manager

Biography:

Kenny is currently MySQL Practice Manager at Percona.


Slides



  Download Slides  

Percona Live

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA