Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 36.5Mb
PDF (A4) - 36.5Mb
PDF (RPM) - 36.6Mb
HTML Download (TGZ) - 10.6Mb
HTML Download (Zip) - 10.6Mb
HTML Download (RPM) - 9.4Mb
Man Pages (TGZ) - 223.1Kb
Man Pages (Zip) - 331.1Kb
Info (Gzip) - 3.3Mb
Info (Zip) - 3.3Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  ...  /  Elements of MySQL Enterprise Firewall

6.4.6.1 Elements of MySQL Enterprise Firewall

MySQL Enterprise Firewall is based on a plugin library that includes these elements:

  • A server-side plugin named MYSQL_FIREWALL examines SQL statements before they execute and, based on its in-memory data cache, renders a decision whether to execute or reject each statement.

  • Server-side plugins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL_WHITELIST implement INFORMATION_SCHEMA tables that provide views into the in-memory firewall cache.

  • Tables in the mysql system database provide persistent backing storage of firewall data.

  • Stored procedures perform tasks such as registering firewall subjects (entities to which the firewall applies), establishing their operational mode, and managing transfer of firewall data between the in-memory cache and persistent storage.

  • User-defined functions provide an SQL-level API for lower-level tasks such as synchronizing the cache with persistent storage.

  • System variables enable firewall configuration and status variables provide runtime operational information.