Documentation Home
MySQL 8.3 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.7Mb
PDF (A4) - 40.8Mb
Man Pages (TGZ) - 293.3Kb
Man Pages (Zip) - 408.3Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb
Excerpts from this Manual

MySQL 8.3 Reference Manual  /  ...  /  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.48 Comparison Between Data-Masking Components and Plugin Elements

Category Components Plugin
Interface Service functions, loadable functions Loadable functions
Support for multibyte character sets Yes, for general-purpose masking functions No
General-purpose masking functions mask_inner(), mask_outer() mask_inner(), mask_outer()
Masking of specific types PAN, SSN, IBAN, UUID, Canada SIN, UK NIN PAN, SSN
Random generation, specific types email, US phone, PAN, SSN, IBAN, UUID, Canada SIN, UK NIN email, US phone, PAN, SSN
Random generation of integer from given range Yes Yes
Persisting substitution dictionaries Database File
Privilege to manage dictionaries Dedicated privilege FILE
Automated loadable-function registration/deregistration during installation/uninstallation Yes No
Enhancements to existing functions More arguments added to the gen_rnd_email() function N/A