Currently I have MariaDB 10.3 with 120 MyISAM table and 97 innoDB and planning to convert.
1. Is there official script can do that? if not, what MyISAM tables I should start with to convert to innoDB?
2. Changing "default-storage-engine=MyISAM" to "default-storage-engine=innoDB" in my.cnf before converting MyISAM to innoDB, does it have any negative impact on database inconsistencies, corruption, and orphaned data?
Continue reading...
1. Is there official script can do that? if not, what MyISAM tables I should start with to convert to innoDB?
2. Changing "default-storage-engine=MyISAM" to "default-storage-engine=innoDB" in my.cnf before converting MyISAM to innoDB, does it have any negative impact on database inconsistencies, corruption, and orphaned data?
Continue reading...