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.
Thank you very much.
Do I need to specify innodb_file_per_table in the my.cnf file to use encryption please?
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.