W3cubDocs

/MariaDB

MariaDB Audit Plugin

MariaDB and MySQL are used in a broad range of environments, but if you needed to record user access to be in compliance with auditing regulations for your organization, you would previously have had to use other database solutions. To meet this need, though, MariaDB has developed the MariaDB Audit Plugin. Although the MariaDB Audit Plugin has some unique features available only for MariaDB, it can be used also with MySQL.

Basically, the purpose of the MariaDB Audit Plugin is to log the server's activity. For each client session, it records who connected to the server (i.e., user name and host), what queries were executed, and which tables were accessed and server variables that were changed. This information is stored in a rotating log file or it may be sent to the local syslogd.

The MariaDB Audit Plugin works with MariaDB, MySQL (as of, version 5.5.34 and 10.0.7) and Percona Server. MariaDB started including by default the Audit Plugin from versions 10.0.10 and 5.5.37, and it can be installed in any version from MariaDB 5.5.20.

Additional documentation

Below are links to additional documentation on the MariaDB Audit Plugin. They explain in detail how to install, configure and use the Audit Plugin.

Tutorials

Below are links to some tutorials on MariaDB's site and other sites. They may help you to get more out of the MariaDB Audit Plugin.

Web Log Articles

Below are links to web log articles on the MariaDB Audit Plugin. You may find them useful in understanding better how to use the Audit Plugin. Since some of these articles are older, they won't include changes and improvements in newer versions. You can rely on the documentation pages listed above for the most current information.

Sub-Documents

Title Description
MariaDB Audit Plugin - Installation Installing the MariaDB Audit Plugin.
MariaDB Audit Plugin - Configuration Audit Plugin global variables within MariaDB
MariaDB Audit Plugin - Log Settings Log audit events to a file or syslog
MariaDB Audit Plugin - Location and Rotation of Logs Logs can be written to a separate file or to the system logs
MariaDB Audit Plugin - Log Format The audit log is a set of records written as a list of fields to a file in plain‐text format
MariaDB Audit Plugin - Versions Releases of the MariaDB Audit Plugin, and in which versions of MariaDB each...
MariaDB Audit Plugin Options and System Variables Description of Server_Audit plugin options and system variables.
MariaDB Audit Plugin - Status Variables Server Audit plugin status variables
Release Notes - MariaDB Audit Plugin MariaDB Audit Plugin release notes
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/mariadb-audit-plugin/