For years, the largest web properties in the world have leveraged MySQL replication to scale to millions of users and to provide High Availability (HA) for their applications. In recent releases, Oracle MySQL engineering has significantly enhanced MySQL replication by introducing InnoDB Cluster. MySQL 8.0 includes integration with MySQL Shell to easily set up InnoDB ReplicaSets and InnoDB ClusterSets.
Join the MySQL team to get a free trial account and receive step-by-step instructions for setting up MySQL Enterprise Edition in multiple HA configurations.
Learning Objectives:
- Learn details on the internals of MySQL replications technologies from Asynchronous Replication to Group Replication.
- Learn how to setup Replication environments from simple Source/Replica to multiple ClusterSets. Including failover scenarios for both maintenance and crash.
Agenda
- Intro to MySQL Enterprise Edition Replication
- Lab 1: ReplicaSets
Setting up demo environments
Create ReplicaSets and test failovers
- Lab 2: InnoDB Cluster
Setup InnoDB Cluster
Create InnoDB Clusters and test failovers
- Lab 3: InnoDB ClusterSets
Create InnoDB ClusterSets and test failovers
- Conclusion: Beyond the Lab
