LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Slackware (https://www.linuxquestions.org/questions/slackware-14/)
-   -   Slackware 14.1 mariadb encrypted mydiamo (https://www.linuxquestions.org/questions/slackware-14/slackware-14-1-mariadb-encrypted-mydiamo-4175485826/)

carlitoco 11-25-2013 09:34 AM

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?

Thank you!

carlitoco 11-27-2013 04:16 AM

Nobody knows something?

TracyTiger 11-27-2013 12:18 PM

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.

tux_dude 11-27-2013 06:41 PM

Quote:

Originally Posted by carlitoco (Post 5070353)
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?

Thank you!

Having MyDiamo on dm-crypt device will provide two level encryption. The dm-crypt device ensures your data is protected if the device falls into the wrong person's hand (if they don't have your keys). MyDiamo encrypts the database data, which prevent someone with unauthorized access to your system (or device if your dm key is compromised) from gaining access to your data by dumping the DBs or copying the DB files.


All times are GMT -5. The time now is 05:28 PM.