Re: MySQL encription

[Georgi Kodinov]

Hi,

Depends on what exactly do you want to use on your dev environment.
The MySQL server (both enterprise and community) can do table encryption. But it needs to store the keys someplace.
For that it needs an active keyring backend plugin.
We have a number of these that store the keys in various backends: e.g. plain text file, encrypted file, Oracle key vault server etc.
Some of these keyring backend plugins are available only in the enterprise version.
So it all does depend on what you need for your development environment exactly.
Since you are an enterprise customer talking to MySQL support (as Peter suggested) is a good idea actually.
Failing that you need to asses if one of the keyring backend plugins available in the community edition will do it for your development environment.

Georgi "Joro" Kodinov
MySQL SrvGen team lead
Plovdiv, Bulgaria