Description:
When running the "dba check-instance-configuration" and "dba configure-local-instance" it would be nice to receive the option to enforce InnoDB Cluster protection against 'breakable' options that can take nodes out, such as creating MyISAM tables and then inserting rows or allowing GIPK's to be ON but have show_gipk_in_create_table_and_information_schema = OFF.
How to repeat:
I'm migrating Drupal environments into an InnoDB Cluster from MariaDB and I want to avoid any risk of MyISAM table creation and also I want to enforce PK usage via sql_generate_invisible_primary_key=ON but I have to do this after running the checkInstanceConfiguration and ConfigureLocalInstance.
Suggested fix:
Seeing as ConfigureLocalInstance configures and restarts the instance, surely this could be asked or included as a possible option when executing the command? Eg.
mysqlsh icadmin@localhost:3306 -- dba configure-local-instance --restart=true --interactive=FALSE --Enforce=DisableMyISAM,GIPK_On
