Data masking for mysql

Question

I need to do data masking to sensitive data exists in mysql db. is there any data masking tool available for mysql with linux platform.

Comments

If you mean encryption you need to do that in the application because transparent encryption and decryption in the database layer makes little sense...

Answer 1

I don't think there's a generic tool for it. It depends on your data, format etc. ie: it's not the same a credit card record than an email or a phone number one.

It depends on your data, so you might want to do it from an application level.

Comments

Yes, we can do it at application level and database level as well. For example mobile no. is **********, digits can by shuffle(**********) or can replace with other letter/number(first 6 digits replace with X-- xxxxxx5877) by using data masking. We can use any one data masking technique at DB level to protect our sensitive data from external exposure.

I have sensitive data in existing mysql db. I need to do data masking at DB level. If any tools available for the same please respond.

---

write a simple PHP script iterating the records, read the column, mask the data and write it back.

Answer 2

Yes, you can use DataSunrise Data Masking. Supports MySQL database as well as other databases.
Can run on Linux or Windows.
DataSunrise Static data masking - to create a functional copy of production data in test while masking sensitive data.
DataSunrise Dynamic Data Masking - obfuscate data in runtime based on security policies.
Can be combined with Database firewall and database audit and activity monitoring datasunrise.com