jeudi 5 mars 2015

Force MariaDB Galera to only create InnoDB tables


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.





Aucun commentaire:

Enregistrer un commentaire