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.