I am trying to manage mysql group replication and I noticed a problem when manipulating users and grants. 10 of the main mysql tables in the main mysql database are MyIsam. So I cant add databases or user permissions because they fail and wont replicate. Master-master group replication requirs everything InnoDB.
ALTER TABLE works fine on regular custom databases/tables but how do you fix this on the main mysql database?
I tried this but they all fail:
ALTER TABLE mysql.db ENGINE = InnoDB;
ALTER TABLE mysql.tables_priv ENGINE = InnoDB;
ALTER TABLE mysql.user ENGINE = InnoDB;
ERROR: ERROR 1726 (HY000): Storage engine 'InnoDB' does not support system tables.
Another error running CREATE USER...
[ERROR] Plugin group_replication reported: 'Table db does not use the InnoDB storage engine. This is not compatible with Group Replication'
ERROR 3098 (HY000): The table does not comply with the requirements by an external plugin group_replication.
Server version: 5.7.23-log MySQL Community Server