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
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.
Below are links to additional documentation on the MariaDB Audit Plugin. They explain in detail how to install, configure and use the Audit Plugin.
- Log Settings
- Log Location & Rotation
- Log Format
- Status Variables
- System Variables
- Release Notes
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.
- Introducing the MariaDB Audit Plugin
by Anatoliy Dimitrov, September 2, 2014
- 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.
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.
- Activating Auditing for MariaDB in 5 Minutes
by Ralf Gebhardt, September 29, 2013
- Query and Password Filtering with the MariaDB Audit Plugin
by Ralf Gebhardt, May 4, 2015
- Set Up a Remote Log File using rsyslog
by Ralf Gebhardt, December 16, 2013
- MySQL Auditing with MariaDB Auditing Plugin
by Peter Zeitsev, February 15, 2016
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.
Audit Plugin v1.1.7 Not Logging ConnectHi there, I've installed the MariaDB Audit Plugin version 1.1.7 and it's co...
Install Maria DB Audit plugin to mysqlHi I tired to installed maria db audit plugin to mysql community server 5....
MariaDB Audit plugin support for MySQL 5.7Is the Audit plugin available for MySQL 5.7 version of Community Edition? I...