Slackware 14.1 mariadb encrypted mydiamo
Do anybody have experience about the installation on a running mysql?
How does the encryption works...
If I've already a whloe dm-crpted device, does mydiamo take an effect, and/or is the database complete (at all) decrypted while running mariadb?
What is the effect in detail?
Nobody knows something?
Since you've already removed your post from the zero reply list ...
I don't use Mariadb, or mydiamo (or MySql) so if you're asking about some special encryption feature of those I can't offer any help.
Regarding the encryption of block devices ...
You encrypt the device (partition), which it sounds like you've done. When the operating system is running you access the files (and databases) there just as though encryption was not involved ... everything is encrypted/decrypted automatically. Your SQL queries are created just as though encryption was not involved.
If you reboot the computer and don't enter the proper key for the encrypted device then none of the files on the encrypted device can be accessed. It doesn't matter what application is running, database or otherwise.
Additionally, database programs also have have encrypted data types so that you can encrypt just the data in one field/column. This encrypted data type is independent of the block level encryption mentioned above.
Perhaps this is the explanation you were seeking?
I'm no expert in this area and others can explain more precisely.
|All times are GMT -5. The time now is 11:21 AM.|