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