Hello Nirbhay,
thanks for your reply. We have the 10.1.9 mariadb version; the bug that your refers is similar but in our case the enforcing works properly on the node used for the initial write, while replicated writes on other nodes generate tables using another engine.


On 21/12/2015 18:41, Nirbhay Choubey wrote:
Hi!

On Mon, Dec 21, 2015 at 12:23 PM, Michele Tota <michele.tota@lnf.infn.it> wrote:
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?

What's the MariaDB server version? A similar issue was fixed in 10.1.8.

https://mariadb.atlassian.net/browse/MDEV-8831

Best,
Nirbhay


Thanks,
Michele

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp