← Back to team overview

maria-discuss team mailing list archive

enforce_storage_engine galera cluster

 

Hi,
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.

This is our servers configuration, the same on all nodes:

...
enforce_storage_engine='InnoDB'
wsrep_on=ON
sql_mode=''
...

How can we enforce InnoDB on all nodes?

Thanks,
Michele


Follow ups