we have a problem using enforce_storage_engine variable set to InnoDB.
We have three servers in cluster (multi masters).
When we issue create table with engine=MyISAM the engine is correctly enforced to InnoDB only on the node we are connected to. On the other nodes the replicated table is created as MyISAM.
In our servers configuration (the same on all nodes) we have:
Some console output follows.
On the first node we have:
Creating table_2 creation we obtain a warning, table_2 is correctly created using InnoDB, and until this point, everything is working great.
When we check the same table on another cluster node, we have:
As you can read, creating a MyISAM table (table_2) on the first node produces a correct InnoDB table, but replication of the same table on the other cluster nodes happens using MyISAM engine.
It seems like engine enforcing is used during creation but not during replication....