ColumnStore Audit Plugin
Introduction
MariaDB server includes an optional Audit Plugin that enables logging and tracking of all user access and statements. This is included and can be enabled for ColumnStore
Installation
To enable the audit plugin for the currently running instance (but no across restarts) run the following as mcsmysql with the default root account:
To have this persist across restarts edit the ColumnStore my.cnf file (example shown for root install):
For more details see the audit plugin installation guide
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 Audit Plugin documentation.
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?