如何在MySQL中使用透明数据加密? [英] How can I use transparent data encryption with MySQL?

问题描述

我想在MySQL上启用透明数据加密(TDE).我不介意整个数据库是否已加密(而不是几列，几行或几张表).我正在使用它进行研究，因此我正在寻找开放和免费的东西.我发现 zNcrypt ，但这是一种商业产品.他们本质上使用的是 eCryptfs ，它是开源的，但找不到为MySQL正确配置它的方法. 任何有关在MySQL上使用eCryptfs或任何其他在MySQL上启用TDE的解决方案的建议都将非常有帮助.谢谢！

I want to enable Transparent Data encryption (TDE) on MySQL. I don't mind if the entire db is encrypted (as opposed to a few columns or rows or tables). I am using this for a study, so I am looking for something that is open and free. I found zNcrypt but it's a commercial product. They are essentially using eCryptfs which is open-source, but couldn't find a way to rightly configure it for MySQL. Any pointers on using eCryptfs with MySQL or any other solution for enabling TDE with MySQL would be very helpful. Thanks!

推荐答案

我看到这个问题相对较旧，但以防万一:

I see this question is relatively old, but just in case:

eCryptfs可以被认为是文件系统，因此，您只需要挂载它，然后将您的MySQL指向

eCryptfs can be considered a filesystem, so, you should just need to mount it, and then point your MySQL datadir to the mounted directory. The only drawback is that it doesn't seems to support O_DIRECT, but I don't think MySQL uses it, does it?

这篇关于如何在MySQL中使用透明数据加密?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！