Robust Data Masking Functions
MySQL Enterprise Masking and De-identification can hide or obfuscate sensitive data, by controlling how the data appears. It features robust masking algorithms including selective masking, blurring, random data substitution and other special techniques for credit card numbers, account numbers and other personally identifiable information, enabling IT departments to maintain structural rules to de-identify values. MySQL Enterprise Masking and De-identification functions include:
* Selective Masking - Obscures a particular portion of numbers or strings such as phone numbers, and payment card numbers.
* Strict or Relaxed Masking - Implement strict or relaxed masking to obfuscate data.
* Random Data Substitution - Replace real values with random values while maintaining format consistency.
* Blurring - Add a random variance to existing values such as randomized numeric ranges for salaries.
* Dictionary Substitution - Randomly replace values from task specific dictionaries.
* Blacklisting and Substitution - Replace specifically blacklisted data, but leave non-blacklisted in place.
https://www.mysql.com/products/enterprise/masking.html#:~:text=Robust%20Data%20Masking%20Functions,controlling%20how%20the%20data%20appears.&text=Random%20Data%20Substitution%20%2D%20Replace%20real,values%20while%20maintaining%20format%20consistency.