How can I use transparent data encryption with MySQL?

Question

I want to enable Transparent Data encryption (TDE) in MySQL. I don't mind if all db is encrypted (as opposed to multiple columns or rows or tables). I use this to learn, so I'm looking for something open and free. I found zNcrypt , but it is a commercial product. They essentially use eCryptfs , which is open source, but could not find a way to properly configure it for MySQL. Any pointers to using eCryptfs with MySQL or any other solution to enable TDE with MySQL would be very helpful. Thanks!

Answer 1

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

eCryptfs can be considered a file system, so you just need to install it, and then point your MySQL datadir to the mounted directory. The only downside is that it doesn't seem to support O_DIRECT, but I don't think MySQL uses it, does it?

Answer 2

This thread is pretty old, so I don't know if it will even be tracked. I hope the rules indicate that NetLib offers Encryptionizer for MySQL . It provides transparent data encryption (TDE) for MySQL on Windows with a simple point-and-click interface. No programming required.