ColumnStore Audit Plugin

Overview

MariaDB server includes an optional that enables logging and tracking of all user access and statements. It is included, but disabled by default. It can be enabled for ColumnStore.

Installing the Audit Plugin

To enable the audit plugin for the currently running instance (but not across restarts), run the following as mcsmysql with the default root account:

To make this persist across restarts, edit the ColumnStore my.cnf file (example shown for root install):

For more details, see the

Enabling the Audit Plugin

To enable audit logging the following global variable must be set to ON:

To ensure this persists across restarts, edit the ColumnStore my.cnf file (example shown for root install):

This will enable logging to the file /usr/local/mariadb/columnstore/mysql/db/server_audit.log.

For example:

To have the log entries written to syslog the global variable server_audit_output_type should be changed from 'file' to 'syslog'. In this case the syslog_info entry contains the ColumnStore server instance name, for example:

For additional configuration and customization options see the documentation.