验证 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屋！