How can I encrypt the content of my databases?
I don't want to keep the files in plain text on the server.
Thank you
Database Encryption
Re: Database Encryption
Table-level encryption is possible with MariaDB 10.1. See https://mariadb.com/kb/en/mariadb/data- ... ncryption/
If you do not want to use this feature, or if you are (most likely) on an older MySQL/MariaDB version you could use an encrypted file system.
(You should probably not forget to encrypt backups as well.)
If you only need some specific content encrypted (i.e. SSN, credit card data), and this does not need to be indexable/searchable, you could also opt for ad-hoc encryption of cell data, where the logic of encryption/decryption is implemented in your application.
If you do not want to use this feature, or if you are (most likely) on an older MySQL/MariaDB version you could use an encrypted file system.
(You should probably not forget to encrypt backups as well.)
If you only need some specific content encrypted (i.e. SSN, credit card data), and this does not need to be indexable/searchable, you could also opt for ad-hoc encryption of cell data, where the logic of encryption/decryption is implemented in your application.
Lemonbit Internet Dedicated Server Management