On Mon, Dec 21, 2015 at 12:47 PM, Michele Tota <michele.tota@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.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.


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