If Aria storage engine (previously called Maria) is the "new" MyISAM, which supports transaction and automatic crash recovery:
- Why still use MyISAM ?
- Should changing storage engine from MyISAM to Aria be a problem? (lose index or something)
|show 5 more comments|
It is very interesting this question would come up because a similar question was asked back in January 2011 ( When is the right time to use MariaDB instead of MySQL, and Why? ). Giving thought to that 16-month-old question and how I answered it in April 2011, here are my answers to your immediate questions:
MyISAM still has features that are unique and useful for small datasets and read slaves in HA setups
If you mysqldump the data and the schema into two separate files, you can always import data into table with either the MyISAM or Aria storage engines. Just keep around the data only mysqldump to be sure.