Database Encryption

Support/Development for MySQL, MariaDB, and other database systems
vdTOG
New Forum User
New Forum User
Posts: 4
Joined: Sat Feb 13, 2016 10:45 pm
Location: Brazil

Database Encryption

Unread post by vdTOG »

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
prupert
Forum Regular
Forum Regular
Posts: 573
Joined: Tue Aug 01, 2006 2:45 pm
Location: Netherlands

Re: Database Encryption

Unread post by prupert »

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.
Lemonbit Internet Dedicated Server Management
Post Reply