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