Comments - Migrating mysql 5.5.19 to mariadb with encryption

8 years, 1 month ago Christine Ross

Thank you very much.

Do I need to specify innodb_file_per_table in the my.cnf file to use encryption please?

Thank you

 
8 years, 1 month ago Ian Gilfillan

It requires innodb_file_per_table to be set to ON, which is the default.

 
8 years, 1 month ago Ian Gilfillan

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.

 
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.