On Mon, Dec 21, 2015 at 12:47 PM, Michele Tota <michele.t...@lnf.infn.it> wrote:
> 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. > I tried the following on 10.1.9 : Version: Server version: 10.1.9-MariaDB-debug-log Source distribution Node 1: MariaDB [test]> SET @@enforce_storage_engine=INNODB; Query OK, 0 rows affected (0.01 sec) MariaDB [test]> CREATE TABLE t1(i INT) ENGINE=INNODB; Query OK, 0 rows affected (0.07 sec) MariaDB [test]> CREATE TABLE t2(i INT) ENGINE=MYISAM; ERROR 1286 (42000): Unknown storage engine 'MyISAM' Node 2: MariaDB [test]> SHOW TABLES; +----------------+ | Tables_in_test | +----------------+ | t1 | +----------------+ 1 row in set (0.00 sec) Do you get different results? Or your's is a different scenario altogether? Best, Nirbhay > > > On 21/12/2015 18:41, Nirbhay Choubey wrote: > > Hi! > > On Mon, Dec 21, 2015 at 12:23 PM, Michele Tota <michele.t...@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 >> > > >
_______________________________________________ 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
