验证MariaDB 10.1加密 [英] Verifying MariaDB 10.1 encryption

问题描述

我已经设置了表级InnoDB数据库加密在MariaDB上.

I have set up table-level InnoDB database encryption on MariaDB.

我想知道是否有任何方法可以确认数据是真正加密的.我曾尝试在/var/lib/mysql/ibdata1 中搜索表中的样本数据，但是我不知道这是否是可靠的测试.

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.

推荐答案

我在mariadb.com上发布了此问题，并建议在grep中填充一些已知数据.

I posted this question on mariadb.com, and the suggestion there was to perfom a grep for some known data.

Rackspace的DBA建议改用strings命令，以更好地处理二进制数据，例如:

A DBA at Rackspace suggested using the strings command instead, to better handle the binary data, for example:

strings /var/lib/mysql/sample_table/user.ibd | grep "knownuser"

这种方法不会在加密表上返回任何结果，也不会在未加密表上返回结果(假设两个表均已加载"knownuser").

This approach returns no results on an encrypted table and does return results on an unencrypted table (assuming both have "knownuser" loaded into them).

这篇关于验证MariaDB 10.1加密的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！