Verifying Mariadb 10.1 encryption

I have set up table-level InnoDB database encryption on Maria DB 10.1.8 (https://mariadb.com/kb/en/mariadb/data-at-rest-encryption/).

I'd like to know if there is any way to confirm that the data is truly encrypted. I've tried searching /var/lib/mysql/ibdata1 for sample data in the tables, but I don't know if that's a reliable test or not.

Answer

In our test suite we have few tests that insert a string and then search for it within data files. I think this is fairly reliable (and it did help us to find few bugs in the implementation).

Comments

Comments loading...
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.