MariaDB Encryption at Rest - Existing Database Tables Not Encrypted

Michael Legg

Active Member
Mar 2, 2015
40
1
58
New Farm, Queensland, Australi
cPanel Access Level
Website Owner
I just upgraded our db server to MariaDB 10.4 with the express purpose of utilizing MariaDB's encryption at rest capabilities.

I've configured the server for encryption and now if I create a new table it appears to be encrypted. (It appears in the "information_schema.innodb_tablespaces_encryption" table.)

But the existing database tables do not appear in "information_schema.innodb_tablespaces_encryption".

I can't find anything on the web about how to encrypt existing tables, all the resources I can find seem to imply that it's supposed to happen automatically.

Has anyone here had any experience enabling encryption on an existing MariaDB database and getting the existing tables to encrypt?
 

Michael Legg

Active Member
Mar 2, 2015
40
1
58
New Farm, Queensland, Australi
cPanel Access Level
Website Owner