From the course: Advanced MySQL and MariaDB

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Understanding and installing the Audit plugin

Understanding and installing the Audit plugin

From the course: Advanced MySQL and MariaDB

Start my 1-month free trial

Understanding and installing the Audit plugin

- MariaDB 5.5 featured the ability to write an audit plugin using an API. MySQL now offers a commercial audit plugin as part of their Enterprise offering. MariaDB has an audit plugin that ships for free with version 10.0 and higher. Both audit plugins log the server's activity. MariaDB's audit plugin and MySQL's audit plugins are very different from each other, including what they log, how they log, and what options you can set. However, both MySQL and MariaDB's audit plugins are plugins, so they have the same installation. The MySQL Enterprise plugin is called audit_log.so, and the MariaDB plugin is called server_audit.so. Note that the free MariaDB plugin can also run on MySQL servers. If you're using MySQL, make sure either the MySQL Enterprise plugin or the MariaDB plugin is copied to your plugin directory. If you're using MariaDB version 10.0, plugin should already be installed for you in the plugin directory. Let's find out where the plugin directory is, and we'll do that with…

Contents