Percona Audit Log Plugin __hot__

-- Log only SELECT, INSERT, UPDATE, DELETE SET GLOBAL audit_log_include_commands = 'SELECT,INSERT,UPDATE,DELETE';

All audit log settings are (can be changed without restarting) using SET GLOBAL . percona audit log plugin

SET GLOBAL audit_log_enabled = ON;

– send logs to remote syslog or SIEM.

Overall, the Percona Audit Log Plugin provides a powerful tool for monitoring and logging database activity, helping to improve security, performance, and compliance. -- Log only SELECT, INSERT, UPDATE, DELETE SET

-- Filtering SET GLOBAL audit_log_include_accounts = 'app_user@%'; SET GLOBAL audit_log_include_commands = 'INSERT,UPDATE,DELETE'; SET GLOBAL audit_log_include_databases = 'prod'; SET GLOBAL audit_log_exclude_commands = ''; -- Log only SELECT

like root from logging to avoid filling disk with admin activity:

×