Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial (Part 2)

MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial (Part 2)

 24 April - 1:30 PM - 4:30 PM @ Ballroom C
Experience level: 
Beginner
Duration: 
6 hours tutorial
Tracks:
Operations
Topics:
MySQL
High Availability

Description

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.

Speakers

Matthew Lord's picture

Matthew Lord

Senior MySQL Product Manager, Oracle

Biography:

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.

Kenny Gryp's picture

Kenny Gryp

MySQL Practice Manager, Percona

Biography:

Kenny is currently MySQL Practice Manager at Percona.

Frédéric Descamps's picture

Frédéric Descamps

MySQL Community Manager, Oracle

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.

Share this talk