MariaDB Server 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.
Versions
Below is a list of the releases of the MariaDB Audit Plugin, the most recent version first, and in which versions of MariaDB each relative plugin was included.
-
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