maria-discuss team mailing list archive

[Michele Tota <michele.tota@xxxxxxxxxxx>]

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@xxxxxxxxxxx <mailto: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
>     <https://launchpad.net/%7Emaria-discuss>
>     Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>     <mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>
>     Unsubscribe : https://launchpad.net/~maria-discuss
>     <https://launchpad.net/%7Emaria-discuss>
>     More help   : https://help.launchpad.net/ListHelp