← Back to team overview

maria-discuss team mailing list archive

Re: enforce_storage_engine galera cluster

 

Hi!

On Mon, Dec 21, 2015 at 12:23 PM, Michele Tota <michele.tota@xxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>

Follow ups

References