8.5.2.5 MySQL Enterprise Data Masking and De-Identification Component Variables

The MySQL Enterprise Data Masking and De-Identification components support the following system variables. Use these variables to configure related component operations. Variables are unavailable unless the appropriate MySQL Enterprise Data Masking and De-Identification components are installed (see Section 8.5.2.1, “MySQL Enterprise Data Masking and De-Identification Component Installation”).

• component_masking.dictionaries_flush_interval_seconds

  Command-Line Format	--component-masking.dictionaries-flush-interval-seconds=#
  System Variable	component_masking.dictionaries_flush_interval_seconds
  Scope	Global
  Dynamic	No
  SET_VAR Hint Applies	No
  Type	Integer
  Default Value	0
  Minimum Value	60
  Maximum Value (Unix)	18446744073709551615
  Maximum Value (Windows)	4294967295
  Unit	seconds

  Sets the interval, in seconds, to wait before attempting to schedule another flush of the data masking dictionaries table to the memory data masking dictionaries cache following a restart or previous execution. The value is handled as listed here:

  • 0: No flushing

  • 1 - 59 inclusive: Round up to 60, with a warning

  • >= 60: Wait this many seconds to perform flush

• component_masking.masking_database

  Command-Line Format	--component-masking.masking-database[=value]
  System Variable	component_masking.masking_database
  Scope	Global
  Dynamic	No
  SET_VAR Hint Applies	No
  Type	String
  Default Value	mysql

  Specifies the database to use for data masking dictionaries at server startup. Prior to MySQL 8.3.0, data masking dictionaries were stored in the mysql system schema exclusively. This variable is read only.

  Use this variable to set and persist a schema other than the default value (mysql). For additional information about setting up the data-masking components to use an alternative location for the data-masking table, see Install Using a Dedicated Schema. For general guidelines about using the PERSIST ONLY keyword, see Section 15.7.6.1, “SET Syntax for Variable Assignment”.