Learn more about the newest masking feature introduced in MariaDB MaxScale 2.1.
Let’s be friends:
Comment (0)
Join the DZone community and get the full member experience.
With the masking filter that was introduced in MariaDB MaxScale 2.1, it is possible to mask columns so that, although the columns themselves are visible to clients, the data in those columns are not. For instance, we can arrange things so that a query like:
does not return a result like:
But instead, it gives us something like:
Taking the masking filter into use is quite straightforward. In the configuration file, you need to specify a section for the filter as follows:
The rules parameter specifies a file where the actual masking rules are. The rules are specified using JSON, and the following is sufficient in order to unconditionally mask the values of all columns whose name is ssn.
