This is a read-only copy of the MariaDB Knowledgebase generated on 2024-12-24. For the latest, interactive version please visit https://mariadb.com/kb/.

MaxScale data masking

We are currently in the process of implementing MaxScale 2.2 on our production servers. I am tasked with finding a solution to our DEV/QA data refreshes that will pull data from production into DEV/QA for testing purposes. Certain column data needs to be obscured (i.e. First Name, Last Name, Address) before we can import into a DEV/QA database. The data masking filter was a possible solution but the only way the data is obscured is to replace with a fixed character (i.e. "x") but this was not viable. One example of what we want to do is to have a MaxScale data masking filter option that will allow the column data to be replaced with a random value from a lookup table on the same database server. For example, the data masking filter would replace the column "first_name" with a random value from a lookup table called "first_names" on the same database server.

Is there any road map in the near future that will expand upon the data masking filter to allow replacing values with a random value in a lookup table?

Answer Answered by Markus Mäkelä in this comment.

I'd recommend filing this as a feature request on the MariaDB Jira under the MaxScale project: https://jira.mariadb.org/browse/MXS

Sounds like a very useful feature to have.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.