CODEWITHSUNDEEP
mysqlruby-on-railsdatabaseencryption
Adam Albrecht
Adam Albrecht

Reputation: 6870

Encrypt Entire Rails Database

I'd like to encrypt basically the entire database for my rails application (or at least many of the tables / columns) because I'm hosting a lot of sensitive data for clients. I'm using MySQL at the moment, but I could switch if necessary. Does anyone have any recommendations?

Thanks!

Upvotes: 3

Views: 2536

Answers (2)

Preston Marshall
Preston Marshall

Reputation: 1195

I think your best bet for encryption would be to make a encrypted partition on one of your drives, or possibly a virtual encrypted drive, then move the mysql data storage over to the encrypted partition. Note that you would need to enter the password on system boot to mount the partition, but if you automatically entered it the security would be useless. Basically this would protect you from physical intrusion or theft of the machine.

Upvotes: 1

ndbroadbent
ndbroadbent

Reputation: 13793

Have a look here: How to secure user data in the database with Rails?

My suggestion would be to use the safe (strongbox) gem.

Upvotes: 3

Related Questions