Audit Plugin Overview

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.

Review these pages for detailed documentation:

• Installation

• Configuration

• Log Settings

• Log Location & Rotation

• Log Format

• Status Variables

• System Variables

Tutorials

• Activating MariaDB Audit Log by Jaykishan Mutkawoa, May 30, 2016

• Installing MariaDB Audit Plugin on Amazon RDS Amazon RDS supports using the MariaDB Audit Plugin on MySQL and MariaDB database instances.

Blog Posts

• MySQL Auditing with MariaDB Auditing Plugin by Peter Zaitsev, February 15, 2016