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 each table that does not use InnoDB Engine, use the following command:
SELECT table_schema, table_name, engine, table_rows, (index_length...