Can not create table "role_has_permissions" when using Mysql Group Replication

[ThangNguyen153]

I'm using Mysql Group Replication and get error "The table does not comply with the requirements by an external plugin".

This issue seems happen on Many To Many relationship table such as "role_has_permissions" which contains 2 columns "permission_id" and "role_id" as PK and has foreign key constraint on "CASCADE".

From what I read in Mysql Group Replication document, I need to:

• Add new "ID" column as PK Auto Increment
• Update "permission_id" and "role_id" column to normal columns (not PK column)
• Remove "CASCADE" from this table
• Create Trigger to do same as what cascade does ( if still want to delete related record automatically)

Other Many to Many tables should flow the same rules above

I wonder if we have other solution such change configuration ,.... because I feel it's ridiculous when I have to modify migration just because I'm using Group Replication.