Comments - Migrating mysql 5.5.19 to mariadb with encryption
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.
For upgrading, essentially yes, see Upgrading from MySQL to MariaDB. I'd suggest upgrading to the latest release through (currently MariaDB 10.1.11) rather than 10.1.4, which was a beta release. For encryption. the tables will not be encrypted unless they were specified so when created, so they will need to be altered. See Specifying which tables to encrypt.
Thank you very much.
Do I need to specify innodb_file_per_table in the my.cnf file to use encryption please?
Thank you
It requires innodb_file_per_table to be set to ON, which is the default.
Actually, I'm not sure if that applies in all situations. It requires innodb_file_per_table to be on to be able to create or alter individual tables with encryption options, so in your case you will need it to be able to alter the tables and encrypt them, but need to investigate more about what happens with innodb_file_per_table set to off from the start.