Documentation Home
MySQL 9.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.0Mb
PDF (A4) - 40.1Mb
Man Pages (TGZ) - 259.0Kb
Man Pages (Zip) - 366.2Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb


MySQL 9.0 Reference Manual  / ...  / Security  / MySQL Enterprise Data Masking and De-Identification  /  Data-Masking Components Versus the Data-Masking Plugin

8.5.1 Data-Masking Components Versus the Data-Masking Plugin

Previously, MySQL enabled masking and de-identification capabilities using a server-side plugin, but transitioned to use the component infrastructure as an alternative implementation. The following table briefly compares MySQL Enterprise Data Masking and De-Identification components and the plugin library to provide an overview of their differences. It may assist you in making the transition from the plugin to components.

Note

Only the data-masking components or the plugin should be enabled at a time. Enabling both components and the plugin is unsupported and results may not be as anticipated.

Table 8.44 Comparison Between Data-Masking Components and Plugin Elements

CategoryComponentsPlugin
InterfaceService functions, loadable functionsLoadable functions
Support for multibyte character setsYes, for general-purpose masking functionsNo
General-purpose masking functionsmask_inner(),mask_outer()mask_inner(),mask_outer()
Masking of specific typesPAN, SSN, IBAN, UUID, Canada SIN, UK NINPAN, SSN
Random generation, specific typesemail, US phone, PAN, SSN, IBAN, UUID, Canada SIN, UK NINemail, US phone, PAN, SSN
Random generation of integer from given rangeYesYes
Persisting substitution dictionariesDatabaseFile
Privilege to manage dictionariesDedicated privilegeFILE
Automated loadable-function registration/deregistration during installation/uninstallationYesNo
Enhancements to existing functionsMore arguments added to thegen_rnd_email() functionN/A