MySQL Enterprise Dynamic Data Masking

仅在部分商业版中提供

MySQL Enterprise Dynamic Data Masking helps organizations protect sensitive data directly in MySQL. It enables server-side protection of sensitive values without requiring application changes or separate masked copies of data, and it extends MySQL Enterprise capabilities for masking and de-identification with query-time policy enforcement.

By attaching masking policy directly to base-table columns, MySQL can return either the original value or a masked value at query time based on the executing user or active role. In addition, MySQL Enterprise supports masking and de-identification functions that help hide, obfuscate, and substitute sensitive data for development, testing, analytics, and other non-production use cases.

Protect Sensitive Data at Query Time

Dynamic Data Masking gives organizations a centralized way to control how sensitive values are exposed at runtime. Instead of relying on each application to implement and maintain its own masking logic, MySQL can evaluate masking policy in the database layer and return masked or original results according to the executing user or active role.

Support Development, Test, and Analytics Use Cases

MySQL Enterprise masking capabilities also help organizations reduce exposure of confidential information outside production environments. Sensitive application data can be masked or de-identified so it can be used more safely for development, testing, analytics, or controlled sharing, while replacing real values with realistic but fictitious substitutes when needed.

Centralize Data Protection in MySQL

Because masking capabilities are built into MySQL Server, organizations can centralize masking logic in the database instead of distributing it across multiple applications and tools. This helps create a more consistent approach to sensitive data protection across users, roles, applications, and query paths.

Meet Data Protection and Privacy Requirements

The current MySQL Enterprise Masking and De-identification page positions these capabilities as helping organizations address privacy and regulatory requirements involving protection of personally identifiable information, payment data, and other confidential fields. Bringing that message into this page preserves that compliance-oriented value proposition while expanding it with query-time masking controls.

Robust Masking and De-identification Functions

MySQL Enterprise supports a range of masking and de-identification techniques for protecting confidential data, including selective masking, strict or relaxed masking, random data substitution, blurring, dictionary substitution, and blocklisting with substitution. These complement Dynamic Data Masking by supporting both runtime protection and non-production data protection workflows.

Extend MySQL Enterprise Security Controls

MySQL Enterprise Edition includes advanced capabilities for security, reliability, observability, and operational control. Dynamic Data Masking extends that portfolio in MySQL 9.7.0 LTS while preserving the broader masking and de-identification story already present in MySQL Enterprise.

Additional Resources