MariaDB – Forcing Galera to Only Create InnoDB Tables

galeramariadb

I successfully run a cluster of 3 DB servers using MariaDB Galera 10.0.16. This setup handels a couple of web apps we have created, plus a dozen medium traffic Joomla websites.

My problem is that Galera doesn't like MyISAM. Pretty often, when a plugin or component in Joomla gets installed, it sets the MySQL engine in its install.sql like so:

ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1

When that happens, a simple Joomla component installation can (and has) break the replication.

Is there a way that I can force the server to ignore the ENGINE setting?

Thanks.

Best Answer

Percona XtraDB Cluster has this feature already (enforce_storage_engine) and for MariaDB there is a pending feature request reported by me to Colin...

https://mariadb.atlassian.net/browse/MDEV-6858

Related Question