Advanced MySQL 8

Migrating from master-slave replication to MySQL InnoDB cluster

The MySQL InnoDB cluster is increasingly popular thanks to its high-availability features, so it's important that we look at how to migrate your replication mechanism from master-slave to InnoDB cluster.

First, you will need to have read through and understood Chapter 7, Group Replication in MySQL 8.0. Make sure that you understand Group Replication, the impact of using the MySQL database, and the pros and cons of each scenario.

There are several changes required in database table design that need to be followed carefully. Two important points to remember are as follows:

• InnoDB engine is a must for all tables
• All tables should have a primary key, not a null unique key

To list ...