Comments - Aria Storage Engine
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
I just swapped out MySQL community for MariaDB.
Do I now automatically enjoy "crash-safe" MyISAM tables or do I need to change my existing MyISAM tables to MariaDB. If so, will I need to use transaction=1 ?
Thanks
You will need to update your tables to use the Aria storage engine.
Something like this:
ALTER TABLE `tablename` ENGINE=`MARIA` TRANSACTIONAL=1;
The Aria storage engine is still called 'Maria' in MariaDB 5.1.49.
This is not something you want to do on a large table or busy production server without bringing the server down first. Rebuilding a table can take a long time (depending on the size) and the table will be inaccessible while the change is being made.
As with any change, test it on a non-production table with example data first and test to ensure your data and applications work fine after the change has been made. Lastly, before rolling any changes out to production servers make backups.